2 Replies Latest reply on Feb 13, 2013 1:14 AM by Hemant K Chitale

    RMAN looking at different location for restore on physical standby (10g)

      Hey all,

      I have been trying for days to figure this out, without success. :(

      I have 2 databases. Primary ( DB1 ) and Standby ( STBY1 ). My standby database went kaput, and i have as a result deleted the standby database in order to re-create it from a full primary backup.

      Oracle 10g R2 on Server 2003.

      I have followed several guides, and at this time i have done the following:

      - Configured standby re-do logs on primary
      - backed up current controlfile for standby
      - backed up database plus archivelog
      - configured the tnsnames
      - created the pfile from spfile on primary, copied to standby.
      - Transferred the backup from primary location (E:\FLASH_RECOVERY_AREA\ DB1 \BACKUPSET\2013_02_12) to standby location (E:\FLASH_RECOVERY_AREA\ STBY1 \BACKUPSET\2013_02_12)
      - Edited the pfile for the standby database ( STBY1 )
      - Created a new instance through cmd (oradim -new -sid STBY1 -INTPWD password -STARTMODE manual)
      - Created the spfile from pfile on failover
      - startup nomount

      The problem is here. I connect to RMAN from standby
      rman nocatalog
      connect target sys/password@ DB1
      connect auxiliary /
      set until scn xxx;
      duplicate target database for standby dorecover;

      I receive an error message saying that it cannot find the file location of the backups that its trying to find. I see in the error that it tries to look locally for E:\FLASH_RECOVERY_AREA\ DB1 \BACKUPSET\2013_02_12), however the actual location is (E:\FLASH_RECOVERY_AREA\ STBY1 \BACKUPSET\2013_02_12)

      I have read that the locations need to be the same, however the instance names are different, and i thought i changed the pfile to accomodate that.

      My assumption is that i have made an error in the pfile. However i cannot see any issues there.

      Some things that i have changed in the pfile for standby:

      *.log_archive_config='DG_CONFIG=(DB1, STBY1)'

      Apologies for not printing out these messages.

      Any help would be great!


      Edited by: 987682 on Feb 12, 2013 2:30 PM

      Edited by: 987682 on Feb 12, 2013 2:30 PM