Database Backup and Recovery (MOSC)

MOSC Banner

Duplicate target database to test, unable to find archiveed log

edited Aug 22, 2011 2:57AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center