Databases Reference
In-Depth Information
it is only during the test restore/recovery that you'll know the duration of a restore/recovery and, therefore, how fast
you can perform the actual restore/recovery.
It's much better to get acquainted with the recovery techniques this way than to try them for the first time after a
production database runs into problems and you're under the gun to recover it fast.
■
you can configure the
nls_date_format
environment variable to include the date and time format, such as
dd-Mon-rrrr hh24:MI:SS (in the korn shell, use the command
export nls_date_format = YYYY-MM-DD:HH24:MI:SS
)
because by default only the date is displayed in the rMan log. this is helpful when troubleshooting, because most often
you want to know the exact date and time a specific problem or error occurred. Furthermore, this will also display the
date/time of the rMan backup completion and data file checkpoints.
Note
Record Accurate Software and Hardware Configuration
Always keep handy vital information that you might have to send to the Oracle Support personnel, such as the following:
•
Server model and make
•
Operating system version and patch number
•
Oracle database version number and patch release
•
Database identifier (DBID)
•
Names and location of all your data files
•
Version of the recovery catalog database and the recovery catalog schema, if you're using one
•
Version of the media management software you are using
Of course, it's always a good idea to keep the complete RMAN log file generated during the RMAN backup (even
though this is already captured in the V$RMAN_OUTPUT), which is useful when you lose the control file or recovery
catalog that has information about the RMAN backups you want to restore from.
In this introductory chapter, we have provided a quick review of the essentials of Oracle backup and recovery
concepts and have defined key terms. We also introduced the Recovery Manager tool and explained its basic
architecture and an overview of its important features. Later chapters, of course, delve into the intricacies of using
RMAN to perform backup and recovery.
