03 October, 2011
RMAN Tips -- 3
ALWAYS mention the actual Start and End Times and Contents of all backups.
a. Post a query on forums / email lists
b. Talk to a colleague
c. Report to your manager
*always* mention the Start and End times and contents of your backups.
"Weekly Full Backup and Daily Incremental Backup" is empty of meaning when attempting to resolve a Backup-Restore issue.
There are very noticeable differences between
a) "Backup of 11pm on Sunday"
b) "Database Backup that began at 11pm on Sunday and completed at 1am on Monday"
c) "'BACKUP DATABASE PLUS ARCHIVELOG' that began at 11pm on Sunday and completed at 9am on Monday"
d) "'BACKUP DATABASE INCREMENTAL LEVEL 0 PLUS ARCHIVELOG DELETE INPUT' that began at 11pm on Sunday and completed at 9am on Monday"
Any DBA who thinks he's a DBA should know this and should understand why it is important to know the Start and End times and what was actually backed-up.
Featured Post :
Here's an "Awesome" List of Resources https://github.com/sindresorhus/awesome . . .
Preview Popular Posts
I've seen some DBAs confused about these two "privileges" or "roles". SELECT ANY DICTIONARY is a System Privilege...
Most Internet references about defining the ArchiveLog Deletion Policy relate to the necessity to preserve ArchiveLogs for Standby database...
A recent forums thread was about a Datafile that had been taken OFFLINE by the DBA and was in RECOVER mode. When a DBA sees a datafile in ...