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 ??
[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.
|
|
|
|
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
|
|
|
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.
|
|
|
|
|
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
|
|
|