Database Backup and Recovery (MOSC)

MOSC Banner

Need help to recovery db

edited Aug 4, 2020 3:11AM in Database Backup and Recovery (MOSC) 13 commentsAnswered ✓

Hello!

Please help me solve the problem.
I performed a full backup of the original database including archive logs.
After that, I restored it to the target database to some SCN.

rman target / catalog rman/cat@hostname

connected to target database (not started)

connected to recovery catalog database

RMAN> set dbid=669824449

RMAN> startup nomount;

RMAN> restore controlfile from autobackup;

RMAN> alter database mount;

RMAN> run {

2> set newname for database to '+DATA';

3> restore database;

4> switch datafile all;

5> }

RMAN> run {

SET UNTIL SCN 10166849731985;

RECOVER DATABASE PARALLEL 2;

}

After that, I made a backup of archive logs on the source database

and tried to restore the target database to some SCN

Tagged:

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