Database Backup and Recovery (MOSC)

MOSC Banner

Restore from previous full backup of database (archivelog mode)

edited Mar 15, 2013 7:01AM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓
Hi ,

I was hoping some one could check over the logic of the following restore scenario.  I have successful full back of my database in archivelog mode timestamp='Mar 15 2013 3:45:28' . I want to restore from that backup and overwrite the current database.  Here is my script :-

startup nomount;

rman target=/ nocatalog

set DBID 99999999

run {

allocate channel ............;

set until time "to_date('Mar 15 2013 ','Mon DD YYYY HH24:MI:SS')";

restore controlfile from autobackup;

alter database mount;

restore database;

recover database noredo;

alter database open resetlogs;

}

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