recover database using backup controlfile fails

[Printaporn_1]

Hi Diego,
you procedure is right but now you have 2 options:

1. restore from more older backup.
2. check v$log look for the change number
ex.
change 2421744526 for thread 1 is in sequence #86150
then "select member from v$logfile" and apply the redolog that is same as sequence the recovery ask for.
just put in full path name of that log.

HTH.

[Donald Dzmelyk]

Diego,

I have just worked through is exact scenario. Since I was moving a complete copy of the database to a new location there are no redo logs.

So when you get to that question:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 356238 generated at 06/23/2004 14:10:04 needed for thread 1
ORA-00289: suggestion : /sw/oracle/product/8.1.7.4/dbs/arch1_24.dbf
ORA-00280: change 356238 for thread 1 is in sequence #24


Specify log: {=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL> exit

And your database is open for business.
drd.

[Indira Aramandla]

Hi Diego,

What you had done is correct. May be try to recover to the lime just before the last archive log by using the unitl time option.

1. Restore from the backup

2. Recover database using backup controlfile unitl time 'CCYY-MM-DD:MM:MI:SS';
the system will prompt as

ORA-00279: Change ?????? generated at dd/mm/yy hh:mi:ss needed for thread 1

ORA-00289: Suggest :path_name for arch log.
ORA-00280: Change ?????? for thread 1 is in sequence # ??????
specify log: {RET>=suggest |filename|AUTO|CANCEL}
and when you press enter
Log applied.

and when the last archivelog is applied, it should as

Lof applied
Media recovery complete.

Then

3. alter database open resetlogs;

If you instance still asks for recovery for system datafile, then

first verify the datafiles to be recovered by quering the views v$recover_file to see the file# and change# and v$recovery_log.

Then try this,

recover datafile 'full_path_datafile_name';

and then it may ask the same recover for the rest of the datafiles. Do the same for all datafiles in question. Then

do alter database open resetlogs.

I hope this helps.


Indira A