OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » recover datafile

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

recover datafile [message #161961]

Wed, 08 March 2006 00:55

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

SQL> recover datafile 'C:\ORACLE\ORADATA\TESTDB1\EXTRA1.DBF';
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

what is the error ? how can i overcome this problem ??

Laughing

[Updated on: Wed, 08 March 2006 00:55]

Report message to a moderator

Re: recover datafile [message #162003 is a reply to message #161961]

Wed, 08 March 2006 03:04

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

ORA-00264
ORA-00264: no recovery required
Cause: An attempt was made to perform media recovery on files that do not need any type of recovery.
Action: Do not attempt to perform media recovery on the selected files. Check to see that the file names were entered properly. If not, retry the command with the proper file names.

Report message to a moderator

Re: recover datafile [message #162004 is a reply to message #162003]

Wed, 08 March 2006 03:09

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

the file names were entered properly..

Report message to a moderator

Re: recover datafile [message #162013 is a reply to message #162004]

Wed, 08 March 2006 03:54

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

It seems this data file is all right.
Why do you recover it? Are you sure it is bad?

Alex zeng | Skype me: hans9zeng

Report message to a moderator

Re: recover datafile [message #162016 is a reply to message #162013]

Wed, 08 March 2006 04:08

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

using following statement, i checked whether any datafile is correpted

SQL> select b.name, a.error from v$recover_file a, v$datafile b where a.file# = b.file#;

no rows selected

none of the datafile is correpted.. can we try to recover uncorrepted file ??

i did this mistake only.

Report message to a moderator

Re: recover datafile [message #162028 is a reply to message #162016]

Wed, 08 March 2006 04:47

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

NO.

Report message to a moderator

Re: recover datafile [message #162045 is a reply to message #162028]

Wed, 08 March 2006 06:45

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

thanks for your help

Report message to a moderator

Re: recover datafile [message #162556 is a reply to message #161961]

Sat, 11 March 2006 04:18

dhruvang
Messages: 1
Registered: March 2006
Location: ahmedbad

Junior Member

cause:One of the reason is u have not changed in that perticular
file i mean u don't have any changed in datafile from last backup, u are restored same data with same header information in
control file so u are not recover any data from your datafile
ok
so u have to need d

alter database open so this way u up your database

Report message to a moderator

Previous Topic:	restore subset of database
Next Topic:	oracle errors...need help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 09 05:11:15 CDT 2025