Re: How to make offline datafile onlne again?

Peter wrote:
>
> I took a datafile offline but when I tried to take it online again, I
> got the following error. Why is that? I have the archivelog mode
> turned on already.
>
> SQL> alter database datafile 'c:\oracle\oradata\db\usr.dbf' online;
> alter database datafile 'c:\oracle\oradata\db\usr.dbf' online
> *
> ERROR at line 1:
> ORA-01113: file 8 needs media recovery
> ORA-01110: data file 8: 'c:\oracle\oradata\db\usr.dbf'

Because whilst it was offline it 'fell behind' the rest of the database. To bring it in sync it needs to be recovered (since obviously no changes were done to it the recovery will be pretty quick)

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"