Home » RDBMS Server » Backup & Recovery » Recover datafile
Recover datafile [message #230693] Thu, 12 April 2007 10:44 Go to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
Hi,
i am using the Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
1 of datafile is showing it's status RECOVER.
when i try to recover that datafile it's show me that error.

SQL> alter database recover datafile 24;
alter database recover datafile 24
*
ERROR at line 1:
ORA-00279: change 818332336 generated at 04/05/2007 05:15:16 needed for thread
1
ORA-00289: suggestion : J:\ARCHIVE_DEST2\ARCRECON_S358351594984777.ARC
ORA-00280: change 818332336 for thread 1 is in sequence #35835

unfortunately i deleted the archive files but i have the backup of RMAN for today so can any body help me in this.

thanks
Re: Recover datafile [message #230703 is a reply to message #230693] Thu, 12 April 2007 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have a RMAN backup (inluding the archived logs), repeat the recover statement from RMAN.

Regards
Michel
Re: Recover datafile [message #230712 is a reply to message #230703] Thu, 12 April 2007 11:14 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
i have the backup but without Archivelogs
Re: Recover datafile [message #230724 is a reply to message #230712] Thu, 12 April 2007 11:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't have archived logs you can't recover in the current database.
All you can do is create a new database with your backup, export the content of the files and reimport it in the original database.
Of course, you lose all modifications since the backup.

If your file 24 is empty then move all objects from the current tablespace into another one and then drop the current tablespace.

Regards
Michel
Re: Recover datafile [message #230731 is a reply to message #230724] Thu, 12 April 2007 12:25 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
now database is open and i found the archivelog file from other Dest but when i try to recover the file it's show me

SQL> recover database;
ORA-00275: media recovery has already been started
Re: Recover datafile [message #230734 is a reply to message #230731] Thu, 12 April 2007 12:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora-00275: media recovery has already been started
 *Cause: An attempt was made to start a second media recovery operation
         in the same session.
 *Action: Complete or cancel the first media recovery session or
          start another session to perform media recovery.

First exit from SQL*Plus and retry.

Regards
Michel
Re: Recover datafile [message #230739 is a reply to message #230734] Thu, 12 April 2007 12:41 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
after open the new session in sqlplus

SQL> alter database recover datafile 24;
alter database recover datafile 24
*
ERROR at line 1:
ORA-00279: change 818332336 generated at 04/05/2007 05:15:16 needed for thread
1
ORA-00289: suggestion : J:\ARCHIVE_DEST2\ARCRECON_S358351594984777.ARC
ORA-00280: change 818332336 for thread 1 is in sequence #35835

Re: Recover datafile [message #230744 is a reply to message #230739] Thu, 12 April 2007 12:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
next line it offers you several options, choose one (most likely accept the file it propose).

Regards
Michel

Re: Recover datafile [message #230747 is a reply to message #230739] Thu, 12 April 2007 12:46 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
like what offer?
please help
Re: Recover datafile [message #230749 is a reply to message #230744] Thu, 12 April 2007 12:49 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
SQL> recover datafile 24;
ORA-00275: media recovery has already been started

Re: Recover datafile [message #230752 is a reply to message #230749] Thu, 12 April 2007 12:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
After it proposes you an archived log either:
1/ accept it with: alter database recover continue;
2/ change the name with: alter database recover logfile '<name>';
3/ stop with: alter database recover cancel;

You can also say it continues automatically without asking you for each log file, answer:
alter database recover continue default;

Or start with: alter database recover automatic datafile 24;

Regards
Michel
Re: Recover datafile [message #230754 is a reply to message #230752] Thu, 12 April 2007 13:06 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
SQL> alter database automatic recover datafile 24;
alter database automatic recover datafile 24
*
ERROR at line 1:
ORA-01509: specified name 'AUTOMATIC' does not match actual 'RECON'

Re: Recover datafile [message #230755 is a reply to message #230754] Thu, 12 April 2007 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"recover automatic" not "automatic recover".
icon14.gif  Re: Recover datafile [message #230757 is a reply to message #230755] Thu, 12 April 2007 13:27 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
alter database recover automatic datafile 24;
alter database datafile 24 online;

now it's working fine
thanks Michel Cadot
Re: Recover datafile [message #230761 is a reply to message #230757] Thu, 12 April 2007 13:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I've done nothing but read what is in SQL Reference section "ALTER DATABASE RECOVER".

Regards
Michel
Re: Recover datafile [message #230805 is a reply to message #230761] Thu, 12 April 2007 23:04 Go to previous messageGo to next message
tumaradasrinivas
Messages: 1
Registered: April 2007
Location: HYDERABAD
Junior Member

can anybody help me. where could i post my queries.
Re: Recover datafile [message #230807 is a reply to message #230805] Thu, 12 April 2007 23:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Choose your forum and post your question in it.

Rehards
Michel
Re: Recover datafile [message #231012 is a reply to message #230807] Fri, 13 April 2007 12:42 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
http://www.orafaq.com/forum/h/93410/

And, also take a look for any other future question.

Regards
Taj
Previous Topic: Questionable Statistics
Next Topic: how to get increment data from oracle to sqlserver2005?
Goto Forum:
  


Current Time: Fri Dec 09 17:31:33 CST 2016

Total time taken to generate the page: 0.23701 seconds