1 2 Previous Next 23 Replies Latest reply: Mar 15, 2013 9:05 PM by yxes2013 RSS

    RMAN again?

    yxes2013
      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
          many more :
          http://docs.oracle.com/cd/B14117_01/server.101/b10770/rcmsynta.htm
          • 2. Re: RMAN again?
            Niket Kumar
            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..
              Please refer foll. link
              http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta040.htm
              • 4. Re: RMAN again?
                asahide
                Hi,

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

                  http://www.rmanbackup.com/
                  • 6. Re: RMAN again?
                    Osama_Mustafa
                    You can start by reading oracle documentation
                    http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm
                    • 7. Re: RMAN again?
                      yxes2013
                      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..
                        You can use the foll in RMAN:

                        crosscheck archivelog all;
                        BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
                        • 9. Re: RMAN again?
                          yxes2013
                          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
                            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..
                              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
                                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
                                  I thanks you all :)
                                  • 14. Re: RMAN again?
                                    yxes2013
                                    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