This discussion is archived
1 2 3 4 Previous Next 45 Replies Latest reply: Mar 20, 2013 3:40 AM by cliff64 Go to original post RSS
  • 15. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    That is why I am so confused with oracle docs , it includes lots of "unnecessary" things :(
    and that is why I prefer reading blogs and forums becuase what you see is what you get ;)

    So, am I right that archive logs are backed up by default? or should include it in the list?

    thanks...
  • 16. Re: RMAN again?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    am I right that archive logs are backed up by default?
    NO. They have to be backed up.

    Either
    BACKUP DATABASE PLUS ARCHIVELOG;
    OR
    BACKUP DATABASE;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    BACKUP ARCHIVELOG ALL;
    optionally you can add a DELETE INPUT to the BACKUP command to delete archivelogs after they are backed up.


    That is why I am so confused with oracle docs , it includes lots of "unnecessary" things
    No. The documentation includes a lot of useful information.
    why I prefer reading blogs and forums becuase what you see is what you get
    Which is incomplete. Blogs and forums can only supplement the documentation -- not replace it.

    Not reading the documentation is not acceptable and is unprofessional and risky for your organization.


    Hemant K Chitale

    Edited by: Hemant K Chitale on Mar 14, 2013 10:35 AM
  • 17. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    Thanks for being so thoughtful :)
  • 18. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    Hi all again.

    Just a clarification, how do I include in the rman backup my init.ora and spfile? or is it included by default?


    Thanks again
  • 19. Re: RMAN again?
    Justin_Mungal Journeyer
    Currently Being Moderated
    yxes2013 wrote:
    Hi all again.

    Just a clarification, how do I include in the rman backup my init.ora and spfile? or is it included by default?


    Thanks again
    If you enable autobackups of the control file, then the control file and spfile will be included whenever you take a backup of the database.
  • 20. Re: RMAN again?
    Levi-Pereira Guru
    Currently Being Moderated
    Justin Mungal wrote:
    yxes2013 wrote:
    Hi all again.

    Just a clarification, how do I include in the rman backup my init.ora and spfile? or is it included by default?


    Thanks again
    If you enable autobackups of the control file, then the control file and spfile will be included whenever you take a backup of the database.
    Init.ora is not backed up by RMAN.

    If you want backup init.ora you will need use OS command (like cp or tar)
  • 21. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    Thanks dear :)

    You mean there is no 1 stop shop for RMAN? where everything is backed up? So If I restore my backup to the DR site and I lost my init.ora, what how do I recreate it? :(
  • 22. Re: RMAN again?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    If you are not using an SPFILE but only a PFILE, you must backup the PFILE. A good DBA would also be ensuring backups of $ORACLE_HOME, alert_SID.log, listener.ora, tnsnames.ora, /etc/oratab, /etc/oraInst.loc, the Inventory directory and the initSID.ora file. I guess you have forgotten about all the other files that must also be backed up ?

    Hemant K Chitale
  • 23. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    Thanks hem, :)

    I just thought RMAN will take care of everything to lessen the stress for DBAs. :(
    You know most of us are forgetful.
  • 24. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    Hi again Hem at all,

    So this is my final cmd parameter:

    run {
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/EVA-DISK/RMAN/data/%F';
    backup format '/mnt/EVA-DISK/RMAN/data/%F' database;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    BACKUP ARCHIVELOG ALL;
    delete obsolete;
    }

    Note: That I am forcing RMAN to write it to my own specified name folder, because it is very hard to remember the default long-named folders where RMAN saves them.

    Now, I want to test recovery. Why is that the docs is setting DBID? When in fact it is not stated in my complete RMAN backup? Is it mandatory to use DBID in recovery?
    How can I tell rman that my backup files to be recovered are in '/mnt/EVA-DISK/RMAN/data/%F'?


    Thanks a lot,
  • 25. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    dup
  • 26. Re: RMAN again?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    because it is very hard to remember the default long-named folders where RMAN saves them.
    Aren't you consistently being lazy ?

    Oracle can't know the DBID of the database without the controlfile. If you are restoring the controlfile, it has to identify that the controlfile it is restoring is for the correct database. Therefore, you must identify the DBID and Oracle can then read the DBID from the controlfile to validate this.

    Note that if you are using a Recovery Catalog, it can identify the DBID from the Recovery Catalog. So, you need to specify the DBID only if you are using NOCATALOG.


    Hemant K Chitale
  • 27. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    I am reading the rtfm, but Its a little bit confusing :(
    This dbid adds more to the confusion.

    Wait I try running the recovery. brb...

    Edited by: yxes2013 on 19.3.2013 19:35
  • 28. Re: RMAN again?
    yxes2013 Newbie
    Currently Being Moderated
    Hi Again Hem and all,

    I run rman backup again :

    This is 11.2.0.1 db in SLES 11

    I use the commnad:

    rman target / @/opt/oracle/RMAN/backup.cmd log=/opt/oracle/RMAN/backup.log

    parameter:
    run {
         CONFIGURE CONTROLFILE AUTOBACKUP ON;
         backup database;
         SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
         BACKUP ARCHIVELOG ALL;
         delete obsolete;
         }
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/20/2013 18:33:31
    ORA-19809: limit exceeded for recovery files
    ORA-19804: cannot reclaim 52428800 bytes disk space from 4070572032 limit
    Don't you think it is illogical why does it have small limit by default?


    But I did not set any limits at all :(
    SQL> show parameter limit
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    asm_power_limit                      integer     1
    java_soft_sessionspace_limit         integer     0
    parallel_degree_limit                string      CPU
    resource_limit                       boolean     FALSE
    Edited by: yxes2013 on 19.3.2013 20:07
  • 29. Re: RMAN again?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    4070572032 limit
    Is instance parameter DB_RECOVERY_FILE_DEST_SIZE

    A forums search or google search for the error would have helped you.

    Hemant K Chitale

Legend

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