-
Hello
I am working on Oracle8i Enterprise Edition Release 8.1.7.0.0
I have made a tablespace Offline using alter tablespace xxx ofline immediate . However when I try to make the same online I need to make media recovery but the problem is I have no hot backup of the DB only archive log backups .
Please suggest how do I make the tablespace online ..........
Thanks
Afshin
-
Can you post the full text of error message?
Sanjay
-
Hello
alter tablespace xxx online ;
ORA Message
*****************************************
ORA-01113: file 51 needs media recovery
ORA-01110: data file 51: 'xxx.DBF'
*************************************
Hope this helps
Thanks
Afshin
-
because you used immediate clause Oracle did not checkpoint the datafiles when you put them offline, AFIAK the only way is to recover the tablespace
-
Hi Pando
Thanks and the Tablespace is online again .
Cheers
Afshin
-
Try using this
ALTER DATABASE RECOVER TABLESPACE tblsp_name
This should help you out.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|