1 2 3 4 Previous Next 45 Replies Latest reply: Mar 20, 2013 5:19 AM by yxes2013 RSS

    RMAN again?

    yxes2013
      Hi all,

      I saw this rman backup cmd parameter:
           CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/EVA-DISK/RMAN/data/%F';
           backup format '/mnt/EVA-DISK/RMAN/data/%d_LVL0_%T_%u_s%s_p%p' database;
      Where can I get the value of these "%" variables? Does it have default value? What happened if I do not specify it?
      for example :
      backup format '/mnt/EVA-DISK/RMAN/data/' or
      backup format '/mnt/EVA-DISK/RMAN/data/%'

      What will be the output name of my database backup?

      Thanks a lot,

      zxy
        • 1. Re: RMAN again?
          Hemant K Chitale
          They are explained in the Backup and Recovery Reference manual.


          Hemant K Chitale
          • 2. Re: RMAN again?
            CKPT
            yxes2013 wrote:
            Hi all,

            I saw this rman backup cmd parameter:
            CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/EVA-DISK/RMAN/data/%F';
            backup format '/mnt/EVA-DISK/RMAN/data/%d_LVL0_%T_%u_s%s_p%p' database;
            Where can I get the value of these "%" variables? Does it have default value? What happened if I do not specify it?
            for example :
            backup format '/mnt/EVA-DISK/RMAN/data/' or
            backup format '/mnt/EVA-DISK/RMAN/data/%'

            What will be the output name of my database backup?

            Thanks a lot,

            zxy
            To find out backups easily, lets suppose you do have 2-3 databases in the same server and it is the time to check which backup consists of which database, If you mention %F then piece name comes with DBID with timestamp, Like that there are many options. You can refer below MOS & oracle documentation.

            +What are the various % format code used during RMAN backups [ID 553927.1]+
            http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsubcl010.htm
            • 3. Re: RMAN again?
              Shivananda Rao
              Hello,

              Take a look at this http://docs.oracle.com/cd/E14072_01/backup.112/e10643/rcmsubcl010.htm#RCMRF195


              Regards,
              Shivananda
              • 4. Re: RMAN again?
                yxes2013
                I thank you all :)
                • 5. Re: RMAN again?
                  yxes2013
                  Hi all again,

                  I can not understand what is the difference and usage of these two(2) control files in disaster recovery.

                  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/EVA-DISK/RMAN/data/%F';
                  CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/EVA-DISK/RMAN/data/snapcf_PROD.f';


                  When do I need each of them?


                  Thanks a lot,
                  • 6. Re: RMAN again?
                    Fran
                    all your doubts are resolved with documentation, please check:
                    http://docs.oracle.com/cd/E25178_01/backup.1111/e10642/rcmconfb.htm
                    • 7. Re: RMAN again?
                      yxes2013
                      I have read that but I can not understand what it said :(
                      • 8. Re: RMAN again?
                        Hemant K Chitale
                        The Autobackup is a backup of the controlfile.

                        The Snapshot is a read-consistent copy of the current controlfile that RMAN creates for it's own use. This is used for resynching with a Catalog (if you have one) and also to have a readonly copy of the controlfile that RMAN can use (because the current controlfile is constantly being updated by lgwr, ckpt etc)

                        See http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfa.htm#i1015609


                        Hemant K Chitale
                        • 9. Re: RMAN again?
                          yxes2013
                          Thanks dear :)
                          The Snapshot is a read-consistent copy of the current controlfile that RMAN creates for it's own use. This is used for resynching with a Catalog (if you have one) and also to have a readonly copy of the controlfile that RMAN can use (because the current controlfile is constantly being updated by lgwr, ckpt etc)
                          I still can not understand this :(
                          You mean if I backup my controlfile using:

                          CONFIGURE CONTROLFILE AUTOBACKUP ON;
                          or
                          CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/EVA-DISK/RMAN/data/%F';

                          My control file backup is not consistent and is therefore not reliable? Because we have to assume that the controlfile is always constantly updated.

                          Thanks,
                          • 10. Re: RMAN again?
                            Levi Pereira
                            My control file backup is not consistent and is therefore not reliable? Because we have to assume that the controlfile is always constantly updated.
                            This means datafiles/controlfile also is updated constantly, so backup of datafile also is not reliable? No. You are wrong and lack recovery concept.

                            This backup controlfile is reliable, since you have a valid backup (datafiles and archive logs) which is part of that controlfile backup.

                            To understand how Oracle performs recovery is first necessary to understand Oracle SCN and how is used for instance and media recovery.

                            Read it:
                            http://community.dbapool.com/articlelist.php?articles=1029200701
                            • 11. Re: RMAN again?
                              yxes2013
                              I just want simple and complete recoverable hot backup :(

                              Kindly tell me if this is enough as recoverable complete hot backup and nothing is missing.

                              backup.cmd
                              =========
                              run {
                              CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u05/RMAN/%F';
                              backup format '/u05/RMAN/%d_LVL0_%T_%u_s%s_p%p' database;
                              }

                              Thanks a lot,
                              • 12. Re: RMAN again?
                                Hemant K Chitale
                                Yes. A Backup of the ArchiveLogs is missing.



                                Hemant K Chitale
                                • 13. Re: RMAN again?
                                  yxes2013
                                  I thought it will be backed up by default :(

                                  So I should not care about the snap controlfile?
                                  • 14. Re: RMAN again?
                                    Hemant K Chitale
                                    A Snapshot controlfile is not part of the backup. Yes, you should "not care" about it -- you should not consider it in your backup and recovery plans. Think of it as "internal to RMAN".


                                    Hemant K Chitale
                                    1 2 3 4 Previous Next