ORA-00283: recovery session canceled due to errors

[Former Member]

Dear All,

I have faceing issue to apply archive log in DR server after restore Production server offline backup.

Following is error :

SQL> startup

ORACLE instance started.

Total System Global Area 1526726656 bytes

Fixed Size 2029112 bytes

Variable Size 771754440 bytes

Database Buffers 738197504 bytes

Redo Buffers 14745600 bytes

Database mounted.

Database opened.

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01110: data file 1: '/oracle/P01/sapdata1/system_1/system.data1'

Pls. guide me

Thanks in advance,

Regards,

Sweetdiya

[sunny_pahuja2 · Accepted solution]

Hi,

As i can see that you have opened your DR server and after that you are trying to perform recovery. This is wrong.

Correct method is restore your production db on your DR server and once restore finished then perform the recovery without opening the database.

You need to again restore db and then perform the recovery.

Thanks

Sunny

[Former Member · Accepted solution]

Dear Sunny,

I have restore DB and try to apply next arcive log as per bellow:

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

ORA-01034: ORACLE not available

SQL> startup;

ORACLE instance started.

Total System Global Area 1526726656 bytes

Fixed Size 2029112 bytes

Variable Size 771754440 bytes

Database Buffers 738197504 bytes

Redo Buffers 14745600 bytes

Database mounted.

Database opened.

SQL>recover database until cancel using backup controlfile;

ORA-00283: recovery session canceled due to errors

ORA-00600: internal error code, arguments: [2141], [1475563215], [1478279742],

then i have restart server and Try to apply log as per bellow :

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01110: data file 1: '/oracle/P01/sapdata1/system_1/system.data1'

can you tell me how can i resolve this .

Pls.

Thanks & Regards,

Sweetdiya

[Former Member · Accepted solution]

> SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
> ORA-01034: ORACLE not available
> SQL> startup;
> ORACLE instance started.
> 
> Total System Global Area 1526726656 bytes
> Fixed Size		    2029112 bytes
> Variable Size		  771754440 bytes
> Database Buffers	  738197504 bytes
> Redo Buffers		   14745600 bytes
> Database mounted.
> Database opened.
> 
> SQL>recover database until cancel using backup controlfile;
> ORA-00283: recovery session canceled due to errors
> ORA-00600: internal error code, arguments: [2141], [1475563215], [1478279742],

Hello,

Do not execute 'startup' i.e. do not 'open' the database before applying the redo-logs.

Start the database in 'nomount' state.

Please execute -

sql> startup nomount

Thanks

[sunny_pahuja2 · Accepted solution]

Hi,

If after restore you give startup command, then database will not start it will ask you to perform recovery but in your case database is getting open after restore it means someone has cancelled recovery. You need to restore it again and start the db in nomount state and then perform recovery.

Thanks

Sunny

[Former Member · Accepted solution]

Dear All,

Thanks for reply...and guide me my previous issue is resolve and i am on next step but i have fece bellow issue:-

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

ORA-00279: change 216416820 generated at 10/24/2011 13:33:13 needed for thread

1

ORA-00289: suggestion : /oracle/P01/oraarch/P01arch1_22220_679453534.dbf

ORA-00280: change 216416820 for thread 1 is in sequence #22220

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

AUTO

ORA-00328: archived log ends at change 216396573, need later change 216416820

ORA-00334: archived log: '/oracle/P01/oraarch/P01arch1_22220_679453534.dbf'

SQL>

I have copy all concern log from PRDn server,

Pls. guide me to move forward

Thanks once again ,

Regards,

Sweetdiya

[Former Member · Accepted solution]

Hi

Please know that you can not recover your DR database again if you have opened your database once.

So you can not use the PRD's archived log to apply into DR system.

May be help you!

wuyan

[Former Member · Accepted solution]

Dear Sunny,

Thanks lot..

My problem is resolved ....i have restore DB and apply log to production server.

Thanks once again.

Regards,

Seewtdiya

[blanca_serrano]

Hello Sweetdiya,

From Oracle the '/oracle/P01/sapdata1/system_1/system.data1' is either still online and the database is open in some instance, or another process is currently doing a media recovery on this file. If you run the following statement

SQL>select name,status from v$datafile;

Then check the status of the system datafile.

If the database is open, you need to issue a shutdown

SQL> shutdown;

let the database shutdown normally, then try to restore the datafile from a consistent backup.

SQL>startup mount

SQL>recover datafile ' '/oracle/P01/sapdata1/system_1/system.data1';

I hope this helps you.

Regards,

Blanca