-
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
-
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
-
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
-
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
-
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
-