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
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.
03-29-2001, 12:40 PM
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.
03-29-2001, 01:50 PM
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 ?
03-29-2001, 03:12 PM
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.