-
I have a hot backup from yesterday. Try to do point-in-time recovery and get the following:
RMAN-08031: released channel: d2
RMAN-08031: released channel: d3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME is
before RESETLOGS time
I do confirm that backupsets are in the catalog database. Here is my recovery script.
run {
allocate channel d1 type 'SBT_TAPE';
allocate channel d2 type 'SBT_TAPE';
allocate channel d3 type 'SBT_TAPE';
restore database
until time "to_date('Aug 27 2001 02:00:00','Mon DD YYYY HH24:MI:SS')";
recover database
until time "to_date('Aug 27 2001 1:25:00','Mon DD YYYY HH24:MI:SS')";
sql "alter database open resetlogs";
release channel d1;
release channel d2;
release channel d3;
}
## If successful, need to run reset database below
##reset database
goodhealth
-
What is your oracle version, backup client that you use and etc?
Need more information...
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Oracle 8.1.7 running on HP-UX 11.
goodhealth
-
remove until time after recover
Hi,
This is because your restore is till 2. Try to give a restore till the point-in-time.
Your script should b something like -
restore until time 1.25
recover database
RMAn will take the backups taken before 1.25 and apply the logs so as to make it recover till 1.25. Hope you do have all the logs since then.
Cheers
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|