I support an Oracle 10g database on an AIX server and some of the older archivelogs were mistakenly deleted before they were backed up (100 or so out of about 750). The database has been loaded with production data but isn't being actively used (go-live date is about a month away). I want to take a full backup that I can restore the database to this point -- today -- if there's a failure of some sort. I realize it was a mistake to delete the archivelogs, but my question is, what are some way(s) to perform a full backup and to eliminate the need for the previously created archivelogs? I have RMAN setup and have run a full cold backup through RMAN (database was mounted but not opened at the time of the backup), as well as periodically backing up the archivelogs also through RMAN.
If you perform a full backup, you do not need any archived redo logs from before that backup was started. And missing those archived redo logs will not interfere with your full backup. If you are using RMAN, then you will want to skip the step where you backup the archived redo logs. RMAN will complain if some are missing.
To notify RMAN that the archived redo logs are missing, use the CHANGE UNCATALOG command as can be seen in this document.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.