Home » RDBMS Server » Backup & Recovery » Datafile OFFLINE...........
Datafile OFFLINE........... [message #261819] Thu, 23 August 2007 12:42 Go to next message
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:-

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:-

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
Re: Datafile OFFLINE........... [message #261852 is a reply to message #261819] Thu, 23 August 2007 15:39 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
1) Before taking Datafile or tablespace offline whether i need to take backup of all the files?


No
but keep in mind dont shutdown database when tablespaces/datafiles or offline.

Quote:
2) Why i am getting this error? Just i took datafile from offline to online?


use
recover datafile number(#) or recover tablespace name;
Previous Topic: Increase log Files
Next Topic: Truncate and a complete recovery?
Goto Forum:
  


Current Time: Tue Dec 06 10:24:45 CST 2016

Total time taken to generate the page: 0.21977 seconds