12 Replies Latest reply: May 27, 2013 8:18 AM by maja RSS

    Rman backup on physical standby database without cancelling MRP

    maja
      Hi all,

      Could anyone share, is this possible to take RMAN backup on physical standby database without cancelling MRP process.

      regarrds,
        • 1. Re: Rman backup on physical standby database without cancelling MRP
          swapnil kambli
          http://docs.oracle.com/cd/E11882_01/server.112/e25608/rman.htm#CHDHAJFD
          • 2. Re: Rman backup on physical standby database without cancelling MRP
            Mahir M. Quluzade
            Hi,
            On Standby Side:
            
            SQL> alter database mount; 
            
            Database altered.
            
            SQL> alter database recover managed standby database using current logfile disconnect from session; 
            
            Database altered.
            
            SQL> select max(Sequence#)  from v$archived_log;
            
            MAX(SEQUENCE#)
            --------------
                    405
            
            SQL> select max(Sequence#)  from v$archived_log where applied='YES';
            
            MAX(SEQUENCE#)
            --------------
                    404
            
            SQL> exit
            Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
            With the Partitioning, OLAP, Data Mining and Real Application Testing options
            [oracle@oel62-x64 Desktop]$ rman target / 
            
            Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 21 15:31:43 2013
            
            Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
            
            connected to target database: ADMDB (DBID=4063877183, not open)
            
            RMAN> backup database plus archivelog delete all input;
            
            
            Starting backup at 21-MAY-13
            using target database control file instead of recovery catalog
            allocated channel: ORA_DISK_1
            channel ORA_DISK_1: SID=32 device type=DISK
            channel ORA_DISK_1: starting archived log backup set
            channel ORA_DISK_1: specifying archived log(s) in backup set
            input archived log thread=1 sequence=390 RECID=391 STAMP=815416638
            input archived log thread=1 sequence=391 RECID=392 STAMP=815421952
            input archived log thread=1 sequence=392 RECID=393 STAMP=815422343
            input archived log thread=1 sequence=393 RECID=394 STAMP=815422434
            input archived log thread=1 sequence=394 RECID=395 STAMP=815422570
            input archived log thread=1 sequence=395 RECID=396 STAMP=815476598
            input archived log thread=1 sequence=396 RECID=397 STAMP=815476615
            input archived log thread=1 sequence=397 RECID=398 STAMP=815476645
            input archived log thread=1 sequence=398 RECID=399 STAMP=815477471
            input archived log thread=1 sequence=399 RECID=400 STAMP=815477475
            input archived log thread=1 sequence=400 RECID=401 STAMP=815477628
            input archived log thread=1 sequence=401 RECID=403 STAMP=815584146
            input archived log thread=1 sequence=402 RECID=402 STAMP=815584137
            input archived log thread=1 sequence=403 RECID=405 STAMP=816017446
            *input archived log thread=1 sequence=404 RECID=404 STAMP=816017444*
            *input archived log thread=1 sequence=405 RECID=406 STAMP=816017455*
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_annnn_TAG20130521T153202_8spm937d_.bkp tag=TAG20130521T153202 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
            channel ORA_DISK_1: deleting archived log(s)
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_14/o1_mf_1_390_8s48hfrp_.arc RECID=391 STAMP=815416638
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_14/o1_mf_1_391_8s4fohwb_.arc RECID=392 STAMP=815421952
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_14/o1_mf_1_392_8s4g1q0v_.arc RECID=393 STAMP=815422343
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_14/o1_mf_1_393_8s4g4l8z_.arc RECID=394 STAMP=815422434
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_14/o1_mf_1_394_8s4g8t9h_.arc RECID=395 STAMP=815422570
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_15/o1_mf_1_395_8s631622_.arc RECID=396 STAMP=815476598
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_15/o1_mf_1_396_8s631qjj_.arc RECID=397 STAMP=815476615
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_15/o1_mf_1_397_8s632od8_.arc RECID=398 STAMP=815476645
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_15/o1_mf_1_398_8s63whqc_.arc RECID=399 STAMP=815477471
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_15/o1_mf_1_399_8s63wly4_.arc RECID=400 STAMP=815477475
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_15/o1_mf_1_400_8s641d8j_.arc RECID=401 STAMP=815477628
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_16/o1_mf_1_401_8s9d21jk_.arc RECID=403 STAMP=815584146
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_16/o1_mf_1_402_8s9d1skv_.arc RECID=402 STAMP=815584137
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_403_8spm6p4h_.arc RECID=405 STAMP=816017446
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_404_8spm6mqj_.arc RECID=404 STAMP=816017444
            RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_405_8spm6yg0_.arc thread=1 sequence=405
            Finished backup at 21-MAY-13
            
            Starting backup at 21-MAY-13
            using channel ORA_DISK_1
            channel ORA_DISK_1: starting full datafile backup set
            channel ORA_DISK_1: specifying datafile(s) in backup set
            input datafile file number=00001 name=/u01/app/oracle/oradata/stldb/system01.dbf
            input datafile file number=00002 name=/u01/app/oracle/oradata/stldb/sysaux01.dbf
            input datafile file number=00005 name=/u01/app/oracle/oradata/stldb/example01.dbf
            input datafile file number=00003 name=/u01/app/oracle/oradata/stldb/undotbs01.dbf
            input datafile file number=00006 name=/u01/app/oracle/oradata/stldb/appdata01.dbf
            input datafile file number=00004 name=/u01/app/oracle/oradata/stldb/users01.dbf
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_nnndf_TAG20130521T153213_8spm9fnc_.bkp tag=TAG20130521T153213 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:02:15
            channel ORA_DISK_1: starting full datafile backup set
            channel ORA_DISK_1: specifying datafile(s) in backup set
            including current control file in backup set
            including current SPFILE in backup set
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_ncsnf_TAG20130521T153213_8spmfqxf_.bkp tag=TAG20130521T153213 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
            Finished backup at 21-MAY-13
            
            Starting backup at 21-MAY-13
            using channel ORA_DISK_1
            specification does not match any archived log in the repository
            backup cancelled because there are no files to backup
            Finished backup at 21-MAY-13
            
            RMAN> exit
            
            
            Recovery Manager complete.
            [oracle@oel62-x64 Desktop]$ sqlplus / as sysdba
            
            SQL*Plus: Release 11.2.0.3.0 Production on Tue May 21 15:34:42 2013
            
            Copyright (c) 1982, 2011, Oracle.  All rights reserved.
            
            
            Connected to:
            Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
            With the Partitioning, OLAP, Data Mining and Real Application Testing options
            
            SQL> select max(Sequence#) from  v$archived_log;
            
            MAX(SEQUENCE#)
            --------------
                    405
            
            SQL> select max(Sequence#) from v$archived_log where applied='YES';
            
            MAX(SEQUENCE#)
            --------------
                    404
            
            SQL> 
            There have no problem, backup database when MRP is running. But if you want delete, then you are getting RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process.
            And will not delete this archived log, because it is needed for standby or upstream capture process.

            Updated
            When MRP stoped
            SQL> alter database recover managed standby database cancel;
            
            Database altered.
            
            SQL> exit
            Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
            With the Partitioning, OLAP, Data Mining and Real Application Testing options
            [oracle@oel62-x64 Desktop]$ rman target / 
            
            Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 21 15:46:07 2013
            
            Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
            
            connected to target database: ADMDB (DBID=4063877183, not open)
            
            RMAN> backup database plus archivelog delete all input;
            
            
            Starting backup at 21-MAY-13
            using target database control file instead of recovery catalog
            allocated channel: ORA_DISK_1
            channel ORA_DISK_1: SID=24 device type=DISK
            channel ORA_DISK_1: starting archived log backup set
            channel ORA_DISK_1: specifying archived log(s) in backup set
            input archived log thread=1 sequence=405 RECID=406 STAMP=816017455
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_annnn_TAG20130521T154617_8spn3s9w_.bkp tag=TAG20130521T154617 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
            channel ORA_DISK_1: deleting archived log(s)
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_405_8spm6yg0_.arc RECID=406 STAMP=816017455
            Finished backup at 21-MAY-13
            
            Starting backup at 21-MAY-13
            using channel ORA_DISK_1
            channel ORA_DISK_1: starting full datafile backup set
            channel ORA_DISK_1: specifying datafile(s) in backup set
            input datafile file number=00001 name=/u01/app/oracle/oradata/stldb/system01.dbf
            input datafile file number=00002 name=/u01/app/oracle/oradata/stldb/sysaux01.dbf
            input datafile file number=00005 name=/u01/app/oracle/oradata/stldb/example01.dbf
            input datafile file number=00003 name=/u01/app/oracle/oradata/stldb/undotbs01.dbf
            input datafile file number=00006 name=/u01/app/oracle/oradata/stldb/appdata01.dbf
            input datafile file number=00004 name=/u01/app/oracle/oradata/stldb/users01.dbf
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_nnndf_TAG20130521T154618_8spn3v4f_.bkp tag=TAG20130521T154618 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:01:16
            channel ORA_DISK_1: starting full datafile backup set
            channel ORA_DISK_1: specifying datafile(s) in backup set
            including current control file in backup set
            including current SPFILE in backup set
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_ncsnf_TAG20130521T154618_8spn6779_.bkp tag=TAG20130521T154618 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
            Finished backup at 21-MAY-13
            
            Starting backup at 21-MAY-13
            using channel ORA_DISK_1
            specification does not match any archived log in the repository
            backup cancelled because there are no files to backup
            Finished backup at 21-MAY-13
            
            RMAN> 
            Apply process is stopped and new redo received from primary.
            SQL> select max(Sequence#)  from v$archived_log;
            
            MAX(SEQUENCE#)
            --------------
                    407
            
            SQL> select max(Sequence#)  from v$archived_log where applied='YES';
            
            MAX(SEQUENCE#)
            --------------
                    405
            
            SQL> exit
            Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
            With the Partitioning, OLAP, Data Mining and Real Application Testing options
            [oracle@oel62-x64 Desktop]$ rman target / 
            
            Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 21 15:49:28 2013
            
            Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
            
            connected to target database: ADMDB (DBID=4063877183, not open)
            
            RMAN> backup database plus archivelog delete all input;
            
            
            Starting backup at 21-MAY-13
            using target database control file instead of recovery catalog
            allocated channel: ORA_DISK_1
            channel ORA_DISK_1: SID=32 device type=DISK
            channel ORA_DISK_1: starting archived log backup set
            channel ORA_DISK_1: specifying archived log(s) in backup set
            input archived log thread=1 sequence=406 RECID=407 STAMP=816018527
            input archived log thread=1 sequence=407 RECID=408 STAMP=816018530
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_annnn_TAG20130521T154937_8spnb1y3_.bkp tag=TAG20130521T154937 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
            channel ORA_DISK_1: deleting archived log(s)
            RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_406_8spn8hkn_.arc thread=1 sequence=406
            RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
            archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_407_8spn8l69_.arc thread=1 sequence=407
            Finished backup at 21-MAY-13
            
            Starting backup at 21-MAY-13
            using channel ORA_DISK_1
            channel ORA_DISK_1: starting full datafile backup set
            channel ORA_DISK_1: specifying datafile(s) in backup set
            input datafile file number=00001 name=/u01/app/oracle/oradata/stldb/system01.dbf
            input datafile file number=00002 name=/u01/app/oracle/oradata/stldb/sysaux01.dbf
            input datafile file number=00005 name=/u01/app/oracle/oradata/stldb/example01.dbf
            input datafile file number=00003 name=/u01/app/oracle/oradata/stldb/undotbs01.dbf
            input datafile file number=00006 name=/u01/app/oracle/oradata/stldb/appdata01.dbf
            input datafile file number=00004 name=/u01/app/oracle/oradata/stldb/users01.dbf
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_nnndf_TAG20130521T154939_8spnb3f5_.bkp tag=TAG20130521T154939 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
            channel ORA_DISK_1: starting full datafile backup set
            channel ORA_DISK_1: specifying datafile(s) in backup set
            including current control file in backup set
            including current SPFILE in backup set
            channel ORA_DISK_1: starting piece 1 at 21-MAY-13
            channel ORA_DISK_1: finished piece 1 at 21-MAY-13
            piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_ncsnf_TAG20130521T154939_8spndhly_.bkp tag=TAG20130521T154939 comment=NONE
            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
            Finished backup at 21-MAY-13
            
            Starting backup at 21-MAY-13
            using channel ORA_DISK_1
            specification does not match any archived log in the repository
            backup cancelled because there are no files to backup
            Finished backup at 21-MAY-13
            
            RMAN> 
            I think, codes is understandable.

            Regard
            Mahir M. Quluzade

            Edited by: Mahir M. Quluzade on May 21, 2013 3:36 PM
            • 3. Re: Rman backup on physical standby database without cancelling MRP
              maja
              Hi,

              Superb article. What is the steps for ADG
              • 4. Re: Rman backup on physical standby database without cancelling MRP
                maja
                thank u kambli, let you know after read this blog
                • 5. Re: Rman backup on physical standby database without cancelling MRP
                  Mahir M. Quluzade
                  maja wrote:
                  Hi,

                  Superb article. What is the steps for ADG
                  Hi,

                  Steps ADG :
                   On Standby : 
                   
                   sqlplus / as sysdba
                   startup mount; 
                   alter database recover managed standby  database cancel; --- if MRP is running
                   alter database open; 
                   alter database recover managed standby  database using current logfile disconnect from  session;
                   select database_role, open_mode from v$database; 
                   
                   DATABASE_ROLE             OPEN_MODE
                   ------------------------ ------------------------------------------
                   PHYSICAL STANDBY  READ ONLY  WITH APPLY
                  Regards
                  Mahir M. Quluzade
                  • 7. Re: Rman backup on physical standby database without cancelling MRP
                    Mahir M. Quluzade
                    Please, mark as answered your thread if your question is answered, for clear forum!

                    Thanks
                    Mahir M. Quluzade
                    http://www.mahir-quluzade.com
                    • 8. Re: Rman backup on physical standby database without cancelling MRP
                      maja
                      One more question, while we take Rman backup when the database is in read only mode, backup is valid or not
                      • 9. Re: Rman backup on physical standby database without cancelling MRP
                        Mahir M. Quluzade
                        maja wrote:
                        One more question, while we take Rman backup when the database is in read only mode, backup is valid or not
                        Yes you can take backup when database opened read only mode;
                        SQL> select database_role from v$database;
                        
                        DATABASE_ROLE
                        ----------------
                        PHYSICAL STANDBY
                        
                        SQL> select database_role, open_mode from v$database;
                        
                        DATABASE_ROLE      OPEN_MODE
                        ---------------- --------------------
                        PHYSICAL STANDBY READ ONLY
                        
                        SQL> exit
                        Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
                        With the Partitioning, OLAP, Data Mining and Real Application Testing options
                        [oracle@oel62-x64 Desktop]$ rman target / 
                        
                        Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 21 17:46:54 2013
                        
                        Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
                        
                        connected to target database: ADMDB (DBID=4063877183)
                        
                        RMAN> backup database plus archivelog delete all input;
                        
                        
                        Starting backup at 21-MAY-13
                        using target database control file instead of recovery catalog
                        allocated channel: ORA_DISK_1
                        channel ORA_DISK_1: SID=33 device type=DISK
                        channel ORA_DISK_1: starting archived log backup set
                        channel ORA_DISK_1: specifying archived log(s) in backup set
                        input archived log thread=1 sequence=406 RECID=407 STAMP=816018527
                        input archived log thread=1 sequence=407 RECID=408 STAMP=816018530
                        channel ORA_DISK_1: starting piece 1 at 21-MAY-13
                        channel ORA_DISK_1: finished piece 1 at 21-MAY-13
                        piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_annnn_TAG20130521T174712_8spv6jol_.bkp tag=TAG20130521T174712 comment=NONE
                        channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
                        channel ORA_DISK_1: deleting archived log(s)
                        RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
                        archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_406_8spn8hkn_.arc thread=1 sequence=406
                        RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
                        archived log file name=/u01/app/oracle/fast_recovery_area/stldb/STLDB/archivelog/2013_05_21/o1_mf_1_407_8spn8l69_.arc thread=1 sequence=407
                        Finished backup at 21-MAY-13
                        
                        Starting backup at 21-MAY-13
                        using channel ORA_DISK_1
                        channel ORA_DISK_1: starting full datafile backup set
                        channel ORA_DISK_1: specifying datafile(s) in backup set
                        input datafile file number=00001 name=/u01/app/oracle/oradata/stldb/system01.dbf
                        input datafile file number=00002 name=/u01/app/oracle/oradata/stldb/sysaux01.dbf
                        input datafile file number=00005 name=/u01/app/oracle/oradata/stldb/example01.dbf
                        input datafile file number=00003 name=/u01/app/oracle/oradata/stldb/undotbs01.dbf
                        input datafile file number=00006 name=/u01/app/oracle/oradata/stldb/appdata01.dbf
                        input datafile file number=00004 name=/u01/app/oracle/oradata/stldb/users01.dbf
                        channel ORA_DISK_1: starting piece 1 at 21-MAY-13
                        channel ORA_DISK_1: finished piece 1 at 21-MAY-13
                        piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_nnndf_TAG20130521T174713_8spv6l1r_.bkp tag=TAG20130521T174713 comment=NONE
                        channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
                        channel ORA_DISK_1: starting full datafile backup set
                        channel ORA_DISK_1: specifying datafile(s) in backup set
                        including current control file in backup set
                        including current SPFILE in backup set
                        channel ORA_DISK_1: starting piece 1 at 21-MAY-13
                        channel ORA_DISK_1: finished piece 1 at 21-MAY-13
                        piece handle=/u01/app/oracle/fast_recovery_area/stldb/STLDB/backupset/2013_05_21/o1_mf_ncsnf_TAG20130521T174713_8spv7dd8_.bkp tag=TAG20130521T174713 comment=NONE
                        channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
                        Finished backup at 21-MAY-13
                        
                        Starting backup at 21-MAY-13
                        using channel ORA_DISK_1
                        specification does not match any archived log in the repository
                        backup cancelled because there are no files to backup
                        Finished backup at 21-MAY-13
                        
                        RMAN> 
                        Regards
                        Mahir M. Quluzade
                        • 10. Re: Rman backup on physical standby database without cancelling MRP
                          maja
                          Using this backup, Can we recover the database using until SCN or Time?
                          • 11. Re: Rman backup on physical standby database without cancelling MRP
                            Mahir M. Quluzade
                            If you have archived redo logs backups, then yes you can do that.