Duplicate target database to test, unable to find archiveed log
Trying to clone my production 11i E-Business suite database to a test server.
The test database is on a different solaris server.
The sets I take are as follows
on the test server,
1. set up the password file
2. create the spfile with the following lines
*.db_file_name_convert='/app/oracle/oradata/PROD','/app/oracle/oradata/UAT'
*.log_file_name_convert='/app/oracle/oradata/PROD','/app/oracle/oradata/UAT'
startup nomount the UAT database.
Then move onto the production server.
RMAN> connect target /
RMAN> connect catalog rman@catalog
RMAN> connect auxiliary sys@UAT
RMAN> run {
2> set until time '22-AUG-2011 00:20:00';
The test database is on a different solaris server.
The sets I take are as follows
on the test server,
1. set up the password file
2. create the spfile with the following lines
*.db_file_name_convert='/app/oracle/oradata/PROD','/app/oracle/oradata/UAT'
*.log_file_name_convert='/app/oracle/oradata/PROD','/app/oracle/oradata/UAT'
startup nomount the UAT database.
Then move onto the production server.
RMAN> connect target /
RMAN> connect catalog rman@catalog
RMAN> connect auxiliary sys@UAT
RMAN> run {
2> set until time '22-AUG-2011 00:20:00';
0