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
03-29-2001, 09:48 AM
chikkodi
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
03-29-2001, 12:40 PM
sambavan
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
03-29-2001, 01:50 PM
chikkodi
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
03-29-2001, 03:12 PM
sambavan
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.