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))
ORA-00283: recovery session canceled due to errors [message #533688] Thu, 01 December 2011 02:30 Go to next message
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.
Re: ORA-00283: recovery session canceled due to errors [message #533689 is a reply to message #533688] Thu, 01 December 2011 02:31 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Plese, post the whole message you got
Re: ORA-00283: recovery session canceled due to errors [message #533690 is a reply to message #533688] Thu, 01 December 2011 02:31 Go to previous messageGo to next message
pbardale7
Messages: 28
Registered: November 2011
Location: India
Junior Member
i have done this

SQL>Startup Mount

SQL>recover database
Re: ORA-00283: recovery session canceled due to errors [message #533692 is a reply to message #533688] Thu, 01 December 2011 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous messageGo to next message
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
Re: ORA-00283: recovery session canceled due to errors [message #533694 is a reply to message #533693] Thu, 01 December 2011 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: ORA-00283: recovery session canceled due to errors [message #533727 is a reply to message #533693] Thu, 01 December 2011 03:46 Go to previous messageGo to next message
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.
Re: ORA-00283: recovery session canceled due to errors [message #533736 is a reply to message #533727] Thu, 01 December 2011 03:59 Go to previous messageGo to next message
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
Re: ORA-00283: recovery session canceled due to errors [message #533738 is a reply to message #533727] Thu, 01 December 2011 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: ORA-00283: recovery session canceled due to errors [message #533739 is a reply to message #533736] Thu, 01 December 2011 04:03 Go to previous messageGo to next message
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


Re: ORA-00283: recovery session canceled due to errors [message #533741 is a reply to message #533739] Thu, 01 December 2011 04:04 Go to previous messageGo to next message
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
Re: ORA-00283: recovery session canceled due to errors [message #533766 is a reply to message #533741] Thu, 01 December 2011 04:52 Go to previous messageGo to next message
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'

Re: ORA-00283: recovery session canceled due to errors [message #533769 is a reply to message #533766] Thu, 01 December 2011 04:54 Go to previous messageGo to next message
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.
Re: ORA-00283: recovery session canceled due to errors [message #533773 is a reply to message #533769] Thu, 01 December 2011 04:59 Go to previous messageGo to next message
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

Re: ORA-00283: recovery session canceled due to errors [message #533774 is a reply to message #533773] Thu, 01 December 2011 05:00 Go to previous messageGo to next message
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
Re: ORA-00283: recovery session canceled due to errors [message #533777 is a reply to message #533774] Thu, 01 December 2011 05:04 Go to previous messageGo to next message
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.
Re: ORA-00283: recovery session canceled due to errors [message #533783 is a reply to message #533773] Thu, 01 December 2011 05:13 Go to previous message
Michel Cadot
Messages: 68625
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
Previous Topic: How can i make rman backupset expired
Next Topic: Recovery fails on archived log, which is in the backup set.
Goto Forum:
  


Current Time: Fri Mar 29 05:38:07 CDT 2024