Applying log after database restore

[snehal_patel]

Dear Frinds ,

I have restore offiline database using

brrestore -b begppivi.fft -m full

Now I am applying logfiles which are created after backup up. Started database in mount in oracle. and applied

recover database until cancel using backup controlfile But log could not applied...Please help me..

SQL> startup mount

ORACLE instance started.

Total System Global Area 563682868 bytes

Fixed Size 454196 bytes

Variable Size 301989888 bytes

Database Buffers 260046848 bytes

Redo Buffers 1191936 bytes

Database mounted.

SQL> recover database until cancel using backup controlfile

ORA-00279: change 204691271 generated at 11/03/2011 01:01:27 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04008.001

ORA-00280: change 204691271 for thread 1 is in sequence #4008

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 204694501 generated at 11/03/2011 03:15:12 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04009.001

ORA-00280: change 204694501 for thread 1 is in sequence #4009

ORA-00278: log file 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04008.001' no longer

needed for this recovery

ORA-00279: change 204707054 generated at 11/03/2011 08:38:09 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04010.001

ORA-00280: change 204707054 for thread 1 is in sequence #4010

ORA-00278: log file 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04009.001' no longer

needed for this recovery

ORA-00279: change 204714900 generated at 11/03/2011 10:00:14 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001

ORA-00280: change 204714900 for thread 1 is in sequence #4011

ORA-00278: log file 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04010.001' no longer

needed for this recovery

ORA-00308: cannot open archived log 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

[Former Member · Accepted solution]

Hello,

Does this file exist 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001' ?

Thanks

[snehal_patel · Accepted solution]

Dear Sir,

when applying command 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001' ?

was not exist but it could not applied 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04009.001, 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04010.001

Current log sequence is 4008.. It could not apply from 4009,4010,...

How to create ARCH<SID>.log file..I didnt copy that file to destination file...

[former_member188883 · Accepted solution]

Hi,

Log files 9 and 10 have been applied successfully. It is looking for Archive log file 11.

You need to copy the same from source system and apply it.

Regards,

Deepak Kori

[snehal_patel · Accepted solution]

it could not applied..it was terminated with errors; still it show current log sequence is 4008

Oldest online log sequence 4005

Next log sequence to archive 4008

Current log sequence 4008

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination L:\oracle\PRD\oraarch\PRDarch

Oldest online log sequence 4005

Next log sequence to archive 4008

Current log sequence 4008

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination L:\oracle\PRD\oraarch\PRDarch

Oldest online log sequence 4005

Next log sequence to archive 4008

Current log sequence 4008

log destination path is L:\oracle\PRD\oraarch

[volker_borowski2 · Accepted solution]

Check the alertlog.

There should be better message than in dialog that the logs are applied.

Usually, when sqlplus says, log no longer needed, it is applied succesfully.

Which log is it asking for when you repeat the recover command?

Volker

[snehal_patel · Accepted solution]

Dear Sir ,

Thanks a lot.. log were applied successfully.............

[Former Member · Accepted solution]

So at what archive sequence did you stop/finish the recovery ?

Thanks