restore Issue

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mahesh Hardikar
    #1

    restore Issue

    Hello ,

    I am testing cold backup restore.

    Source Details :

    OS : Red Hat AS 2.1 64Bit
    Database : Oracle9i Enterprise Edition Release 9.2.0.2.0 64 Bit -
    Production

    Destination :

    OS : Red Hat AS 2.1 32 Bit
    Database : Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

    Now in this scene , is it possible to restore datafiles from source to
    destination ? here source is 64 Bit Oracle & Destn is 32 Bit.

    Client is asking me if in this scene , it will be possible to have
    Destination hardware to be used for configuring Standby Database.

    For test , I restored datafiles from source to destn. Recreated
    controlfile & tried opening. Database got opened. But when I try to
    alter tablespace TEMP to add file, it gives error :

    ORA-00604 : error occured at recursive SQL Level 1
    ORA-06553 : PLS-801 internal error [56319]

    I get same error if I try to create a test tablespace although
    resizing a datafile goes thru.

    Any pointers on this are highly appreciated ...

    Thanks & Regards,
    Mahesh Hardikar
    Tags: None
    • Frank
      #2
      Re: restore Issue

      Mahesh Hardikar wrote:
      Hello ,
      >
      I am testing cold backup restore.
      >
      Source Details :
      >
      OS : Red Hat AS 2.1 64Bit
      Database : Oracle9i Enterprise Edition Release 9.2.0.2.0 64 Bit -
      Production
      >
      Destination :
      >
      OS : Red Hat AS 2.1 32 Bit
      Database : Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
      >
      Now in this scene , is it possible to restore datafiles from source to
      destination ? here source is 64 Bit Oracle & Destn is 32 Bit.
      >
      Client is asking me if in this scene , it will be possible to have
      Destination hardware to be used for configuring Standby Database.
      >
      For test , I restored datafiles from source to destn. Recreated
      controlfile & tried opening. Database got opened. But when I try to
      alter tablespace TEMP to add file, it gives error :
      >
      ORA-00604 : error occured at recursive SQL Level 1
      ORA-06553 : PLS-801 internal error [56319]
      >
      I get same error if I try to create a test tablespace although
      resizing a datafile goes thru.
      >
      Any pointers on this are highly appreciated ...
      >
      Thanks & Regards,
      Mahesh Hardikar
      What makes you think you can use "64-bit files"
      on a 32-bit OS?
      Something like restoring 9i in a 8i env...
      --
      Regards, Frank van Bortel

        Comment

        • sybrandb@yahoo.com
          #3
          Re: restore Issue

          hardikarm@yahoo .com (Mahesh Hardikar) wrote in message news:<4a1c57c2. 0310022058.22be e496@posting.go ogle.com>...
          Hello ,
          >
          I am testing cold backup restore.
          >
          Source Details :
          >
          OS : Red Hat AS 2.1 64Bit
          Database : Oracle9i Enterprise Edition Release 9.2.0.2.0 64 Bit -
          Production
          >
          Destination :
          >
          OS : Red Hat AS 2.1 32 Bit
          Database : Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
          >
          Now in this scene , is it possible to restore datafiles from source to
          destination ? here source is 64 Bit Oracle & Destn is 32 Bit.
          >
          Client is asking me if in this scene , it will be possible to have
          Destination hardware to be used for configuring Standby Database.
          >
          For test , I restored datafiles from source to destn. Recreated
          controlfile & tried opening. Database got opened. But when I try to
          alter tablespace TEMP to add file, it gives error :
          >
          ORA-00604 : error occured at recursive SQL Level 1
          ORA-06553 : PLS-801 internal error [56319]
          >
          I get same error if I try to create a test tablespace although
          resizing a datafile goes thru.
          >
          Any pointers on this are highly appreciated ...
          >
          Thanks & Regards,
          Mahesh Hardikar
          Unix 32-bit and Unix 64-bit is NOT filesystem compatible. This has to
          do with little and big endian filesystems.

          Sorry

          Sybrand Bakker
          Senior Oracle DBA

            Comment

            Previous template Next
            Working...