OraFAQ Forum: Backup & Recovery » ORA-00283: recovery session canceled due to errors

Home » RDBMS Server » Backup & Recovery » ORA-00283: recovery session canceled due to errors (oracle, 11g. (11.2.0.1.0) , Linux (Red Hat 5.0))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00283: recovery session canceled due to errors [message #533688]

Thu, 01 December 2011 02:30

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

hi all,

I have problem when i am trying to recover database

i am getting above error.

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533689 is a reply to message #533688]

Thu, 01 December 2011 02:31

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Plese, post the whole message you got

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533690 is a reply to message #533688]

Thu, 01 December 2011 02:31

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

i have done this

SQL>Startup Mount

SQL>recover database

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533692 is a reply to message #533688]

Thu, 01 December 2011 02:35

Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00283: recovery session canceled due to errors
 *Cause: An error during recovery was determined to be fatal enough to end
         the current recovery session.
 *Action: More specific messages will accompany this message. Refer to
          the other messages for the appropriate action.

Regards
Michel

[Updated on: Thu, 01 December 2011 02:36]

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533693 is a reply to message #533690]

Thu, 01 December 2011 02:35

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

i am getting this error:

ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533694 is a reply to message #533693]

Thu, 01 December 2011 02:36

Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Why do you a backup control file, do you lose the current one?
2/ If so, do what the message says.

Regards
Michel

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533727 is a reply to message #533693]

Thu, 01 December 2011 03:46

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

actully what happend was i am not able to open database,

so i tried to

SQL> startup mount;
SQL> recover database until cancel;
SQL> alter database open resetlogs;

still its not working!!!

now i wanted to take backup of my one tablespace!!!
and i am unable to do that!!
can u please guide me Step by step???

Thank You.

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533736 is a reply to message #533727]

Thu, 01 December 2011 03:59

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

In order to get step by step avise, please post "the whole output" you have

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533738 is a reply to message #533727]

Thu, 01 December 2011 04:02

Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

still its not working!!!

And this gives us no clue about why "its not working".

Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533739 is a reply to message #533736]

Thu, 01 December 2011 04:03

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

SQL> startup mount
ORACLE instance started.

Total System Global Area 497995776 bytes
Fixed Size 1337464 bytes
Variable Size 381683592 bytes
Database Buffers 109051904 bytes
Redo Buffers 5922816 bytes
Database mounted.
SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533741 is a reply to message #533739]

Thu, 01 December 2011 04:04

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Run

SQL>recover database using backup controlfile;
SQL>alter database open resetlogs;

And post "whole" output you got

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533766 is a reply to message #533741]

Thu, 01 December 2011 04:52

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

sorry for late reply,

i had done your suggestion as

SQL> recover database using backup controlfile;
ORA-00279: change 10539338 generated at 11/30/2011 11:02:10 needed for thread 1
ORA-00289: suggestion :
/eagledatabase/oracle/flash_recovery_area/EAGLE/archivelog/2011_11_30/o1_mf_1_20
7_%u_.arc
ORA-00280: change 10539338 for thread 1 is in sequence #207

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/eagledatabase/oracle/oradata/Eagle/system01.dbf'

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533769 is a reply to message #533766]

Thu, 01 December 2011 04:54

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

If you have available archived redo log files, type "AUTO" instead of "cancel" and make it recover and make database to be consistent.

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533773 is a reply to message #533769]

Thu, 01 December 2011 04:59

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

there are no archive log files

SQL> recover database using backup controlfile;
ORA-00279: change 10539338 generated at 11/30/2011 11:02:10 needed for thread 1
ORA-00289: suggestion :
/eagledatabase/oracle/flash_recovery_area/EAGLE/archivelog/2011_11_30/o1_mf_1_20
7_%u_.arc
ORA-00280: change 10539338 for thread 1 is in sequence #207

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'/eagledatabase/oracle/flash_recovery_area/EAGLE/archivelog/2011_11_30/o1_mf_1_2
07_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/eagledatabase/oracle/flash_recovery_area/EAGLE/archivelog/2011_11_30/o1_mf_1_2
07_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533774 is a reply to message #533773]

Thu, 01 December 2011 05:00

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Your database is in inconsistent state and you don't have enough archived redo log files to apply and recover it. So you have only one option, which is restoring database from backup

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533777 is a reply to message #533774]

Thu, 01 December 2011 05:04

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

I dont have the backup

i am trying to take backup of whole tablespace

but for that database should be open and the database is not opening

is there any another option to get the backup of whole tablespace?

Thank you.

Report message to a moderator

Re: ORA-00283: recovery session canceled due to errors [message #533783 is a reply to message #533773]

Thu, 01 December 2011 05:13

Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

there are no archive log files

Try to apply the online redo logs.

Regards
Michel

Report message to a moderator

Previous Topic:	How can i make rman backupset expired
Next Topic:	Recovery fails on archived log, which is in the backup set.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 22:12:42 CDT 2023