Database Backup and Recovery (MOSC)

MOSC Banner

rman disaster recovery testing

edited May 18, 2011 12:33AM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓
 Hi,

I did hot backup on my server (27th March). I want to test it on other server by recovering whole database. I copied the archives,datafiles copies and controlfile to other machine. Location is same on both servers and database name is same. I am not using rman catalog. On the other server, i started the database in mount stage and found the latest scn. then using rman i ran the following script.

rman>run {

rman> set until scn 456345;

rman>allocate channel d1 type disk;

rman>restore database;

rman>recover database;

rman> sql 'alter database open resetlogs';

rman>}

The database was recovered properly.

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