OraFAQ Forum: Backup & Recovery » Datafile OFFLINE...........

Home » RDBMS Server » Backup & Recovery » Datafile OFFLINE...........

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

Datafile OFFLINE........... [message #261819]

Thu, 23 August 2007 12:42

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Tim,

I started the database in ArchiveLog mode and i took a datafile offline after that when i tried to take datafile online it gave following error:-

Code: [Select all] [Show/ hide]

SQL> alter database datafile 'C:\oracle\oradata\Venkat\navdbf.dbf' online;
alter database datafile 'C:\oracle\oradata\Venkat\navdbf.dbf' online
*
ERROR at line 1:
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\VENKAT\NAVDBF.DBF'

After that when i gave "recover database" command i got the following error:-

Code: [Select all] [Show/ hide]

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF'

Before taking datafile offline i dint took any backup and when it asked for media recover i dint had any backup to restore just i gave
"RECOVER DATABASE"

1) Before taking Datafile or tablespace offline whether i need to take backup of all the files?
2) Why i am getting this error? Just i took datafile from offline to online?

Please guide me.

Regards,
Naveen

Report message to a moderator