I just took over one database and I have quick questions:
1. How can I take the datafiles out of the recovery mode and put it online ???
2. why some of the datafiles are in recovery mode at the first place ??? I don't think the previous DBA do any kind of recovery to this database.
if you have the archive logs then issue
alter tablespace/datafile recover command . Once all archive logs are generated, then alter them as online.
What view are u looking at ? v$recovery_file_status ?
Query v$recovery_status to get overall database recovery information.
The only way to get the files off recovery mode is to perform recovery. ALTER DATABASE RECOVER.
Thanks for your reply,
could someone explain to me why only about 3 datafiles out of 60 datafiles in recovery mode ???
Click Here to Expand Forum to Full Width