OraFAQ Forum: Backup & Recovery » Recover datafile

Home » RDBMS Server » Backup & Recovery » Recover datafile

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

Recover datafile [message #230693]

Thu, 12 April 2007 10:44

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

Report message to a moderator

Re: Recover datafile [message #230703 is a reply to message #230693]

Thu, 12 April 2007 11:04

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you have a RMAN backup (inluding the archived logs), repeat the recover statement from RMAN.

Regards
Michel

Report message to a moderator

Re: Recover datafile [message #230712 is a reply to message #230703]

Thu, 12 April 2007 11:14

emind
Messages: 49
Registered: April 2007
Location: Islamabad

Member

i have the backup but without Archivelogs

Report message to a moderator

Re: Recover datafile [message #230724 is a reply to message #230712]

Thu, 12 April 2007 11:45

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Recover datafile [message #230731 is a reply to message #230724]

Thu, 12 April 2007 12:25

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

Report message to a moderator

Re: Recover datafile [message #230734 is a reply to message #230731]

Thu, 12 April 2007 12:35

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Recover datafile [message #230739 is a reply to message #230734]

Thu, 12 April 2007 12:41

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

Report message to a moderator

Re: Recover datafile [message #230744 is a reply to message #230739]

Thu, 12 April 2007 12:44

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

next line it offers you several options, choose one (most likely accept the file it propose).

Regards
Michel

Report message to a moderator

Re: Recover datafile [message #230747 is a reply to message #230739]

Thu, 12 April 2007 12:46

emind
Messages: 49
Registered: April 2007
Location: Islamabad

Member

like what offer?
please help

Report message to a moderator

Re: Recover datafile [message #230749 is a reply to message #230744]

Thu, 12 April 2007 12:49

emind
Messages: 49
Registered: April 2007
Location: Islamabad

Member

SQL> recover datafile 24;
ORA-00275: media recovery has already been started

Report message to a moderator

Re: Recover datafile [message #230752 is a reply to message #230749]

Thu, 12 April 2007 12:58

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Recover datafile [message #230754 is a reply to message #230752]

Thu, 12 April 2007 13:06

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'

Report message to a moderator

Re: Recover datafile [message #230755 is a reply to message #230754]

Thu, 12 April 2007 13:12

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"recover automatic" not "automatic recover".

Report message to a moderator

Re: Recover datafile [message #230757 is a reply to message #230755]

Thu, 12 April 2007 13:27

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

Report message to a moderator

Re: Recover datafile [message #230761 is a reply to message #230757]

Thu, 12 April 2007 13:43

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I've done nothing but read what is in SQL Reference section "ALTER DATABASE RECOVER".

Regards
Michel

Report message to a moderator

Re: Recover datafile [message #230805 is a reply to message #230761]

Thu, 12 April 2007 23:04

tumaradasrinivas
Messages: 1
Registered: April 2007
Location: HYDERABAD

Junior Member

can anybody help me. where could i post my queries.

Report message to a moderator

Re: Recover datafile [message #230807 is a reply to message #230805]

Thu, 12 April 2007 23:16

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Choose your forum and post your question in it.

Rehards
Michel

Report message to a moderator

Re: Recover datafile [message #231012 is a reply to message #230807]

Fri, 13 April 2007 12:42

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

Report message to a moderator

Previous Topic:	Questionable Statistics
Next Topic:	how to get increment data from oracle to sqlserver2005?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 12:14:05 CST 2024