03 October, 2011

RMAN Tips -- 3

ALWAYS mention the actual Start and End Times and Contents of all backups.

Whenever you
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"
and
b) "Database Backup that began at 11pm on Sunday and completed at 1am on Monday"
and
c) "'BACKUP DATABASE PLUS ARCHIVELOG' that began at 11pm on Sunday and completed at 9am on Monday"
and
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.

.
.
.

No comments: