| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How to test RMAN backup by restoring to a test system
It is recommended to test your backup and recovery procedures in a test environment before implementing them to the production environment. If you already use RMAN to backup the production database and want to restore backups to a test server, please try the following
1. Set up the test server
a) Create the same directories for Oracle software and database
as on the production server
b) Install Oracle Server software. Link oracle to tape devices
if required.
c) Configure listener
d) Copy init<>.ora from the production environment to the
test environment
e) Create password file using orapwd.
f) Startup the instance (nomount) and the listener
2) Setup a test recovery catalog (assuming you already used a recovery
catalog to backup the production database)
a) Export the recovery catalog and import it into a separate
account, say RMANTEST.
Make sure the recovery_catalog_owner is granted
to this RMANTEST account.
b) Add an entry into the tnsnames.ora for the test instance.
3) Test rman connections to the test catalog and the test database
Example:
$ rman catalog=rmantest/rmantest@rman target=internal/internal_password@test
where the internal_password is the password you supplied when creating
the password file for the test instance.
You can now query the catalog and restore backups to the test server.
Good luck
Cong Tang
---------------
CTBTO
Vienna, Austria
Peter S wrote:
I am thinking about using RMAN to backup my Production databaseReceived on Thu Dec 09 1999 - 08:28:30 CST
(8.0.5). The only problem is that I would like test my backups of the
Production database periodically by restoring to a separate Test
database on another box.I would like to be able to recreate the database on the test box by
using a full online backup of the production database.Can anyone point me in the right direction on how I can do this.
Thank You for your help
Peter
 |
 |