DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: backup rman

  1. #1
    Join Date
    Jan 2001
    Posts
    216
    Hi

    I am doing incremental backups on our database using rman.
    Here is an example script that I am using :

    replace script backup_db_level_1 {
    execute script alloc_all_disks;
    execute script set_maxcorrupt;
    backup
    incremental level 1
    skip inaccessible
    tag backup_db_level_1
    filesperset 6
    format '/backup/df_t%t_s%s_p%p'
    database;
    execute script rel_all_disks;
    execute script archive_log_current;
    execute script backup_al_all;
    }

    There are similar scripts for level 0 and level 2 backups.
    In addition to this, I am planning on backing up (using os copy commands) password file and init.ora file.
    What else is necessary for a proper database backup ?
    Should I expilicitly backup control file too ?

    Thanks a lot for your input

  2. #2
    Join Date
    Jan 2001
    Posts
    216
    It would help me a lot if anyone could guide me on this. I am new to RMAN and would greatly benefit from your experience.

    Thanks

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    To get a clear knowledge, I would suggest you to go through the sample backup scripts available at $ORACLE_HOME/rdbms/demo/*.rcv

    That has scripts for both backup and recovery and for different levels of backups.

    Good luck,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jan 2001
    Posts
    216
    Thats where I got the above script from.

    But in there, there are also scripts to backup system table space, control file etc. They are not being called by the incremental backup script.

    so, my question was, should I execute them separately in addition to the incremental backups, or will incremental backup by itself be sufficient ?

    Thanks
    Neelima

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Incremental backups are good enough. But would suggest that you put them in script form and store it and you would be able to call when ever you need.

    Make sure that your archive backup script deletes the logs after it has done the archive log backup.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Jan 2001
    Posts
    216
    Thanks sambavan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width