Incomplete recovery

[gandhi]

Dear Friends,

I have 24X7 database. And i have one cold backup, after creating the database. Then, i do ONLINE backup using RMAN on daily basis.
In case of failure, i should go back to POIN-IN-TIME recovery.

But, my application requires different setup.

There is a crash on Wednesday. So, i could back to Tuesday backup.Then, open the database with RESETLOGS. After some time, if i want to go back to MONDAY backup, how to do it in RMAN?

If i have a cold backp, i can restore whenver i want.Since, it is 24X7 database,i could not shutdown the database.

Could suggest some thing on this.


Thanks
gandhi

[marist89]

Huh?

Depends on what type of RMAN backup you are using. Are you doing a full backup every day? Are you doing incremental backups every day? Your backup strategy is not clear.

[gandhi]

HI,

My stratesy is

SUNDAY : FULL backup
Monday : Incremental
Tuesday : Incremental
Wednesday:Cummulative
Thursday: Incremental
Friday : Incremental
Saturday: Cumulative



Thanks
gandhi

[akhadar]

After restoring your database from Tuesday incremental and using Resetlogs options what is the fun of going back to Monday backup.

[pando]

I thought when you use incremental backup when you restore you must restore a level 0 incremental backup :-?

[gandhi]

Hi,

By mistake, instead of recovering Monday backup, i recoverd Wednesday backup and opened the DB with RESETLOGS. Now, i want to go to MONDAY backup using RMAN.


Thanks
gandhi

[akhadar]

I think u can't go back to Monday backup as u already resetted the controlfile SCN with Resetlogs options.

[marist89]

Originally posted by gandhi
Hi,

By mistake, instead of recovering Monday backup, i recoverd Wednesday backup and opened the DB with RESETLOGS. Now, i want to go to MONDAY backup using RMAN.


Thanks
gandhi

You have to use the previous incarnation. Get the previous incarnation and the reset SCN from the "list incarnation" rman command. Then:

startup nomount;
reset database to incarnation 6;
restore controlfile;
restore database until scn 666; -- one less than the "reset scn" of the current incarnation
alter database open resetlogs;