5 Replies Latest reply on Jul 5, 2012 5:14 AM by Hemant K Chitale

    RESTORE ARCHIVELOG FROM SEQUENCE using RMAN

    922134
      Hi,

      My primary databse is on file system having 10.2.0.5 db version.
      My standby db is on ASM(11.2.0.2)
      Operating system is Windows 2003.


      I have taken rman backup of missing archive logs and fileset is tranferd on standby database server.

      While restoring missing archivelogs using RMAN on standby database I am getting an folloeing error message.


      I am using standby db controlfile instead of catalog database to use the rman.


      RMAN> run {
      2> ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT = 'D:\dbawork\na38551\MKS01P_ARCH\';
      3> RESTORE ARCHIVELOG FROM SEQUENCE 128458 UNTIL SEQUENCE 128510;
      4> RELEASE CHANNEL ch1;
      5> }

      allocated channel: ch1
      channel ch1: sid=85 devtype=DISK

      Starting restore at 02-JUL-12

      archive log thread 1 sequence 128501 is already on disk as file +ORAFLASH/mks01p/mks01p_seq128501_trd1_rid617106566.arc
      archive log thread 1 sequence 128502 is already on disk as file +ORAFLASH/mks01p/mks01p_seq128502_trd1_rid617106566.arc
      archive log thread 1 sequence 128503 is already on disk as file +ORAFLASH/mks01p/mks01p_seq128503_trd1_rid617106566.arc
      restore not done; all files readonly, offline, or already restored
      Finished restore at 02-JUL-12

      released channel: ch1



      Please help me to restore archive log files on standby database.
        • 1. Re: RESTORE ARCHIVELOG FROM SEQUENCE using RMAN
          Mahir M. Quluzade
          Hi,

          I think following link will help you
          http://www.juhanak.cz/database/oracle/dba/rman/RESTORE_ARCHIVELOGS_set_archivelog_destination.rman
          Regards
          Mahir M. Quluzade
          www.mahir-quluzade.com
          • 2. Re: RESTORE ARCHIVELOG FROM SEQUENCE using RMAN
            Hemant K Chitale
            and fileset is tranferd on standby database server.
            Catalog the fileset with "CATALOG START WITH /location_on_standbyserver ;'
            Then do a RESTORE ARCHIVELOG

            Hemant K Chitale
            • 3. Re: RESTORE ARCHIVELOG FROM SEQUENCE using RMAN
              922134
              Hi,

              Archive log are not appying on standby database..its also not fetching archivelogs from primary database.
              please find alert log message :



              Clearing online redo logfile 1 +ORAREDO1/mks01p/mks01p_redo01a.rdo
              Clearing online log 1 of thread 1 sequence number 0
              Wed Jul 04 03:12:53 Pacific Daylight Time 2012
              Errors in file d:\oracle\admin\mks01p\bdump\mks01p_mrp0_4920.trc:
              ORA-00313: open failed for members of log group 1 of thread 1
              ORA-00312: online log 1 thread 1: '+ORAREDO3/mks01p/mks01p_redo01b.rdo'
              ORA-17503: ksfdopn:2 Failed to open file +ORAREDO3/mks01p/mks01p_redo01b.rdo
              ORA-15001: diskgroup "ORAREDO3" does not exist or is not mounted
              ORA-15001: diskgroup "ORAREDO3" does not exist or is not mounted
              ORA-00312: online log 1 thread 1: '+ORAREDO1/mks01p/mks01p_redo01a.rdo'
              ORA-17503: ksfdopn:2 Failed to open file +ORAREDO1/mks01p/mks01p_redo01a.rdo
              ORA-15001: diskgroup "ORAREDO1" does not exist or is not mounted
              ORA-15001: diskgroup "ORAREDO1" does not exist or is not mounted

              Wed Jul 04 03:12:53 Pacific Daylight Time 2012
              Errors in file d:\oracle\admin\mks01p\bdump\mks01p_mrp0_4920.trc:
              ORA-00349: failure obtaining block size for '+ORAREDO1/mks01p/mks01p_redo01a.rdo'
              ORA-15001: diskgroup "ORAREDO1" does not exist or is not mounted

              Clearing online redo logfile 1 complete
              Media Recovery Waiting for thread 1 sequence 128801
              Wed Jul 04 03:12:54 Pacific Daylight Time 2012
              Completed: alter database recover managed standby database disconnect from session
              Wed Jul 04 03:26:50 Pacific Daylight Time 2012
              db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
              user-specified limit on the amount of space that will be used by this
              database for recovery-related files, and does not reflect the amount of
              space available in the underlying filesystem or ASM diskgroup.
              • 4. Re: RESTORE ARCHIVELOG FROM SEQUENCE using RMAN
                jhasanoff
                It seems you have problem with your disk group "ORAREDO3". Check if this diskgroup is mounted and all disks is online.
                • 5. Re: RESTORE ARCHIVELOG FROM SEQUENCE using RMAN
                  Hemant K Chitale
                  These messages relate to the Online redo Logs --which may or may not exist on the Standby site.

                  you say that you have copied the backup of the archivelogs from the primary to the standby. To restore the archivelogs from the backup, you need to first CATALOG them with the "CATALOG" command in RMAN. Then you can restore them into the Standbys archive log destination which is an FRA in ASM.


                  Hemant K Chitale