This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Mar 15, 2013 7:05 PM by yxes2013 RSS

RMAN again?

yxes2013 Newbie
Currently Being Moderated
Hi All,

I have not used RMAN for a long time, as I am only supporting development systems for the past months and i do export/import for backups only.

I forgot my RMAN lessons already :( and I want to use it now for standby and replication testing.

Can I have a refresher please. Just the simplest default & basic commands.

1. rman target /
2. backup database;
3. crosscheck backup;
4. delete obsolete;

What else do I miss?

Thanks a lot,

zxy

Edited by: yxes2013 on 25.2.2013 23:09
  • 1. Re: RMAN again?
    Girish Sharma Guru
    Currently Being Moderated
    many more :
    http://docs.oracle.com/cd/B14117_01/server.101/b10770/rcmsynta.htm
  • 2. Re: RMAN again?
    Niket Kumar Pro
    Currently Being Moderated
    check rman policies

    rman>show all; --- to configure rman policied (include controlfile and spfile backup.)
    rman>backup archivelog all; -------- to take archivelog backup;other thins you are already using. change format for backup for backup location.
  • 3. Re: RMAN again?
    Vedant.. Journeyer
    Currently Being Moderated
    Please refer foll. link
    http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta040.htm
  • 4. Re: RMAN again?
    asahide Expert
    Currently Being Moderated
    Hi,

    Check archive log mode :)
    Regards,
  • 5. Re: RMAN again?
    Sunny kichloo Expert
    Currently Being Moderated
    Also this will help

    http://www.rmanbackup.com/
  • 6. Re: RMAN again?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    You can start by reading oracle documentation
    http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm
  • 7. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    I thank you all :)

    I just want the simplest backup command that backs up everything and not the complex ones. Just to live a day and be able to pass the "connect until archive freed" error.


    Is "backup database" command backs up everything + controlfile + spfile + archives?
    What else do I need to backup?
  • 8. Re: RMAN again?
    Vedant.. Journeyer
    Currently Being Moderated
    You can use the foll in RMAN:

    crosscheck archivelog all;
    BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
  • 9. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
    I dont like compression as this might corrupt the file :(. I just want a simple backup but complete.

    My question is > Is the command "backup database" includes controlfile and spfile? or do I need to state it literally as backup database plus controlfile plus spfile plus archivelog plus all other files.
    Are there other files missing?

    Thanks
  • 10. Re: RMAN again?
    Justin_Mungal Journeyer
    Currently Being Moderated
    yxes2013 wrote:
    BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
    I dont like compression as this might corrupt the file :(. I just want a simple backup but complete.

    My question is > Is the command "backup database" includes controlfile and spfile? or do I need to state it literally as backup database plus controlfile plus spfile plus archivelog plus all other files.
    Are there other files missing?
    It depends... but don't take my word for it:

    If CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and the current server parameter file (if used to start up the database) at the end of a successful BACKUP command. If the database runs in ARCHIVELOG level, RMAN makes control file autobackups when a structural change to the database affects the contents of the control file.

    http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#i1016424

    >
    Thanks
    If I may ask you a question, why are you asking questions that are all answered in the documentation? Wouldn't you rather read the documentation and have a thorough understanding of the database, rather than depending on answers that may lack accuracy on an Internet forum?
  • 11. Re: RMAN again?
    Vedant.. Journeyer
    Currently Being Moderated
    My question is > Is the command "backup database" includes controlfile and spfile? or do I need to state it literally as backup database plus controlfile plus spfile plus archivelog plus all other files.
    Set the foll RMAN parameter:

    CONFIGURE CONTROLFILE AUTOBACKUP to ON
    (Refer link : http://docs.oracle.com/cd/B19306_01/rac.102/b14197/rmanops.htm)

    and then use the command BACKUP DATABASE PLUS ARCHIVELOG;
    (Refer link : http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#CHDBGAJB)
  • 12. Re: RMAN again?
    864103 Newbie
    Currently Being Moderated
    yes you can

    just add in your rman configuration
    configure controlfile autobackup on ;
    the above command will take backed up on your spfile and controlfile when you do any backed up ,
    also any phisical change add datafile , remove datafile ,...,etc with this configuration will take backed up also
    to your controlfile.
  • 13. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    I thanks you all :)
  • 14. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    Thanks Justin ;)
    If I may ask you a question, why are you asking questions that are all answered in the documentation? Wouldn't you rather read the documentation and have a thorough understanding of the database, rather than depending on answers that may lack accuracy on an Internet forum?
    Hmmm...docs are quite confusing :( because there are lots of choices and options. It is very much far better here because it is self-explanatory ;)

    cheers...
1 2 Previous Next

Legend

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