Point-in-Time Duplication - 9i

Posted at Wednesday, June 01, 2005
Every so often, I find myself in a situation in which a user loses data, I need to recover it - from an RMAN tape backup - and only the production host has access to the tape device. In situations such as these, I opt for a Point-In-Time Duplication of the database in question:

Here are the basics:

  • You need to build an instance with a new name for the database you are about to duplicate, including: copy & edit init.ora file (make sure to set db_filename_convert and log_file_name_convert parameters and make sure remote_login_passwordfile is set to something other than 'NONE'!); create necessary file systems; modify listener.ora and tnsnames.ora to include this new instance; create passwordfile, etc.

  • Next modify and execute this script. Be sure to configure any of the necessary RMAN channels, etc.

For additional information you can refer to: Metalink article 228257.1 and/or Oracle 9i RMAN Backup and Recovery by Robert G. Freeman (ISBN# 0072226625).

Feel free to contact me with and questions, comments, experiences, etc.....

Labels: ,