cancel
Showing results for 
Search instead for 
Did you mean: 

restore the database

Nirmalkumar
Frequent Advisor

restore the database

Hi,

my requirement is to restore and recover prod database in test box as of 4/26 9pm.

i did the following steps

1.created pfile and pwd file
2.started database in test box in nomount mode
3.restored the control file

RUN{set until time "to_date('2008-APR-26:21:00:00','yyyy-MON-dd:hh24:mi:ss')";
allocate channel c1 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=bsdwh01)';
restore controlfile to '/oracle/redo1/oradata/fdwp1/control01.ctl';
release channel c1;
}

4.copy the control file to the control file locations as defined in the pfile.

5.alter database mount-->database mounted fine.

6 while trying to restore the database with the below commands

RUN{set until time "to_date('2008-APR-26:21:00:00','yyyy-MON-dd:hh24:mi:ss')";
allocate channel c1 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=bsdwh01)';
restore database;
release channel c1;
}

rman searching for 19th full backup media.

Note:26th full backup media is loaded in the backup server.

my question is y rman searching for 19th full backup media instead of 26th full backup media.

Thanks,
Nirmal.
7 REPLIES
Nirmalkumar
Frequent Advisor

Re: restore the database

Hi all,

i forgot to mention 2 points in my original post

1.i have restored control file by using recovery catalog

2.iam restoring the database without recovery catalog .


Thanks,
Nirmal.

Duncan Edmonstone
Honored Contributor

Re: restore the database

is 21:00 on 26 Apr a time after the backup *finished*, or the time the backup for that night *started*

Cos if its the time the backup started it would make sense that rman wants to select the last full backup (presumably the one done 7 days previous on 19 Apr) and then roll forward from that point...

just a guess

Duncan

HTH

Duncan
Nirmalkumar
Frequent Advisor

Re: restore the database

Hi Duncan,

Thanks for the response.

The full backup completed on 26th Apr 2008 15:00 pm.iam trying restore this full backup only.But Rman searching for 19th backup.


Thanks,
Nirmal.
Volker Borowski
Honored Contributor

Re: restore the database

Duncan may be close to it.
I'd have assumed something similar.

What Timezone are you in, so what is your UTC offset? What is you NLS Environment for backup shell and restore shell?

In case the backup is taken via cron, the timezone or NLS environment might not be set or missing in the environment and this would cause some offset to a recovery from a shell that has a timezone (or NLS) set.

So try to recover the 27th (28th), just to see, if it loads the 26th tape. If it takes the 26th you'll have a system-time/wrist watch missmatch, and most likely you'll need either to adjust TZ or choose another timestamp.

If it still loads the 19th (to recover the 27th) something else is wrong, may be related to then catalog/controlfile stuff,
or the backup taken on 26th was bad.

Anyway, if everything else goes wrong, restore the 19th and recover the logs ...

Good hunting
Volker
Yogeeraj_1
Honored Contributor

Re: restore the database

hi Nirmal,

Duncan and Volker above explained to you what might be happening.

Is your problem solved already?

revert!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Nirmalkumar
Frequent Advisor

Re: restore the database

Hi Volker,

Thanks for the response.

please find answers for ur questions:

Timezone of the restore server is PST(GMT-8:00) and backup server is CST(GMT-6:00).

Backups are not scheduled in cron ,it is scheduled in the backup server.

i have tried to restore by setting until time to 27/28th april 2008 in Rman.But still Rman searching for 19th backup not 26th backup.

26th backup is gud backup.

Hi yogeeraj,

Thanks for the response.

Issue is not resolved..

Thanks,
Nirmal
Volker Borowski
Honored Contributor

Re: restore the database

Well, sounds strange.

concerning the Controlfile stuff:

To recover the 26th backup with the restored controlfile, the backup needs to be registered in that very special resotered controlfile (when trying to recover without a cataog). If that did not happen upon backup, the 26th backup is simply not seen as a recovery option.
Since I rarely do native rman stuff, I do not have the V$BACK... Table names ready, that you should query, to confirm,
that that backup is regisiterd in that controlfile.

Did you try to restore 26th with catalog ?

Volker