1 2 Previous Next 21 Replies Latest reply: Sep 23, 2013 4:19 AM by yxes2013 Go to original post RSS
      • 15. Re: rman backup parameter
        yxes2013

        Hi all,

         

         

        I got output in FRA backupset

         

        -rw-------    1 oracle   dba         7766016 Sep 23 08:38 ../../backupset/2013_09_23/o1_mf_ncnnf_TAG20130923T083833_93z3dbk3_.bkp

        -rw-------    1 oracle   dba         7766016 Sep 23 08:38 ../../backupset/2013_09_23/o1_mf_ncnnf_TAG20130923T083831_93z3d8dn_.bkp

        -rw-------    1 oracle   dba          244736 Sep 23 08:38 ../../backupset/2013_09_23/o1_mf_annnn_TAG20130923T083830_93z3d64y_.bkp

        -rw-------    1 oracle   dba         1114112 Sep 23 08:38 ../../backupset/2013_09_23/o1_mf_ncsnf_TAG20130923T083652_93z3d4t7_.bkp

        -rw-------    1 oracle   dba       516030464 Sep 23 08:38 ../../backupset/2013_09_23/o1_mf_nnndf_TAG20130923T083652_93z395vo_.bkp

        -rw-------    1 oracle   dba       220812800 Sep 23 08:36 ../../backupset/2013_09_23/o1_mf_annnn_TAG20130923T083617_93z381cy_.bkp


        My guess is that the first 2 are the controlfiles, The last 2 are db backups, the 3rd is the spfile, What is the fourth?


        Thanks a lot,



         

        Message was edited by: yxes2013

        • 16. Re: rman backup parameter
          user12075536123

          I guess it is archielog backup.

          Please post the output of rman backup cmd or rman list backup cmd.

          • 17. Re: rman backup parameter
            user12075536123

            you may ignore snapshot controlfile.
            I think it is not necessary to backup controlfile for standby. it is DataGuard controlfile.


            when recovering from disaster,
            if controlfile is not broken, you do not restore controlfile.
            if controlfile is     broken, you restore backup controlfile.

            • 18. Re: rman backup parameter
              yxes2013

              Thanks user120,

               

              I guess it is archielog backup.

              Please post the output of rman backup cmd or rman list backup cmd.

               

              But why does it put in backupset when there is directory "ARC" for archivelogs?

               

              I can see it in the log also:

               

              Starting backup at 23-SEP-13

              current log archived

              using target database control file instead of recovery catalog

              allocated channel: ORA_DISK_1

              channel ORA_DISK_1: SID=70 device type=DISK

              channel ORA_DISK_1: starting compressed archived log backup set

              channel ORA_DISK_1: specifying archived log(s) in backup set

              input archived log thread=1 sequence=2521 RECID=1 STAMP=826882897

              channel ORA_DISK_1: starting piece 1 at 23-SEP-13

              channel ORA_DISK_1: finished piece 1 at 23-SEP-13

              piece handle=/u02/oracle/fast_recovery_area/BATCH/backupset/2013_09_23/o1_mf_annnn_TAG20130923T094138_93z72lqh_.bkp tag=TAG20130923T094138 comment=NONE

              channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

              Finished backup at 23-SEP-13

               

              So it is the currentlog, and it is place along with the dbf  datba backupset.

               

              Ok it clear now

              • 19. Re: rman backup parameter
                yxes2013

                Thanks user120,

                ===========

                you may ignore snapshot controlfile.
                I think it is not necessary to backup controlfile for standby. it is DataGuard controlfile.


                when recovering from disaster,
                if controlfile is not broken, you do not restore controlfile.
                if controlfile is     broken, you restore backup controlfile.

                ===========

                 

                We have dataguard also Does it mean if I restore incremental backup to our standby db (just to resolve gaps) , I can use the backup controlfile instead of  the standby controlfile?

                • 20. Re: rman backup parameter
                  user12075536123

                  It corrects about the following.
                  > I guess it is archielog backup.


                  when rman backup system tablespace, controlfile and spfile are backed up automatically.
                  the fourth is this backup.


                  =====

                   

                  I guess as follows.

                  o1_mf_ncnnf_・・・ is controlfile backup

                  o1_mf_nnndf_・・・ is datafile backup

                  o1_mf_annnn_・・・ is archivelog backup

                  o1_mf_ncsnf_・・・ is controlfile/spfile autobackup when rman backup system tablespace

                  • 21. Re: rman backup parameter
                    yxes2013

                    I thank you all

                    1 2 Previous Next