2 Replies Latest reply: Feb 12, 2013 7:14 PM by Hemant K Chitale RSS

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

    990685
      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 /
      run{
      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:

      *.db_file_name_convert='DB1','STBY1'
      *.db_name='DB1'
      *.db_recovery_file_dest='E:\FLASH_RECOVERY_AREA'
      *.db_unique_name='STBY1'
      *.fal_client='STBY1'
      *.fal_server='DB1'
      *.log_archive_config='DG_CONFIG=(DB1, STBY1)'
      *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STBY1'
      *.log_archive_dest_2='SERVICE=DB1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB1'
      *.log_file_name_convert='DB1','STBY1'

      Apologies for not printing out these messages.

      Any help would be great!

      Ronnie

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

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