Q
Problem solve Get help with specific problems with your technologies, process and projects.

Performing full backup without all archivelogs

I support an Oracle 10g database on an AIX server and some of the older archivelogs were mistakenly deleted before they were backed up. I want to take a full backup that I can restore the database to this point if there's a failure of some sort. What are some way(s) to perform a full backup and to eliminate the need for the previously created archivelogs?

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close