Recover until time: multiple times to the same restore point
727478Oct 12 2009 — edited Oct 14 2009Hi,
I encounter the following problem and i was wondering if someone can help me out:
My goal: I like to restore my database on a weekly base (so every Monday we always start with the same database)
Therefore i start every Sunday a restore until a master-point.
After restoring the database to a specific master-time-point i need to rest the resetlogs.
Once i have reset the restlogs i cannot recover back to the master piont since this is before the RESETLOGS time.
let me clarify myself a bit with an example:
RMAN > shutdown abort;
RMAN > startup mount;
RMAN > restore database until time "to_date('2009-10-12 9:00:52', 'YYYY-MM-DD HH24:MI:SS')";
RMAN > recover database until time "to_date('2009-10-12 9:00:52', 'YYYY-MM-DD HH24:MI:SS')";
RMAN > alter database open resetlogs;
RMAN > shutdown abort;
RMAN > startup mount;
RMAN > restore database until time "to_date('2009-10-12 9:00:52', 'YYYY-MM-DD HH24:MI:SS')";
If i try to so this i receive the following error:
Starting restore at 09-10-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=758 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/12/2009 17:48:36
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
So is there anyone who has a solution for my problem?
Kind regards,