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

Using V$ views to determine if backup was successful

We are hosting 40+ databases which are backed up using archive_logs via RMAN without a catalogue. These files are copied to a hard drive and then backed up to tape. We would like to interrogate each databases's V$ views to determine whether a backup was successful or not. Could you please explain what the interdependancy is between the different views?

We are hosting 40+ databases which are backed up using archive_logs via RMAN without a catalogue. These files are copied to a hard drive and then backed up to tape. We would like to interrogate each databases's V$ views to determine whether a backup was successful or not. Could you please explain what the interdependancy is between the different views? Thanks.
Without a recovery catalog, you cannot obtain this information from the database directly. Without a recovery catalog, any RMAN backup information is stored in the control file. Parts of the control file are accessible through various V$ views. But the parts that pertain to RMAN backups can only be seen if you dump the control file's contents.

I make it a practice to dump my RMAN session's information to a log file and then I email that log file to my email...

account. Every morning, I check my email to see if my backups ran successfully. This is just part of my daily DBA routine.

With 40+ databases, I would definitely create a recovery catalog and use it for all of my RMAN backups. There are a number of benefits to a recovery catalog.

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