Database Backup and Recovery (MOSC)

MOSC Banner

Undo recover database to Level 0 after recover new archive log

Dear Oracle Fan,

I have restored database L0 on UAT on Monday and from Tuesday until Friday I copy all archive log to refresh on the UAT server. I stuck at how I can remove all archive log and undo my db to original L0 point.

run { catalog start with '/data01/arch_recovery';

recover database;}

Alter database open read only;

I find that database has effected by new archive log. I want change it to original state.

I can uncatalog these archive log from control file.

Change Archivelog all Uncatalog;

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