This discussion is archived
1 2 3 4 Previous Next 45 Replies Latest reply: Mar 20, 2013 3:40 AM by cliff64 RSS

RMAN again?

yxes2013 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    They are explained in the Backup and Recovery Reference manual.


    Hemant K Chitale
  • 2. Re: RMAN again?
    CKPT Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I thank you all :)
  • 5. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I have read that but I can not understand what it said :(
  • 8. Re: RMAN again?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Yes. A Backup of the ArchiveLogs is missing.



    Hemant K Chitale
  • 13. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points