| Media recovery [message #160679] |
Tue, 28 February 2006 00:52  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
In my database USERS tablespace is in OFFLINE,
SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
CWMLITE ONLINE
DRSYS ONLINE
EXAMPLE ONLINE
INDX ONLINE
ODM ONLINE
TOOLS ONLINE
USERS OFFLINE
XDB ONLINE
When i tried to make it ONLINE,it shows the following error,
SQL> alter tablespace users online;
alter tablespace users online
*
ERROR at line 1:
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\TESTDB1\USERS01.DBF'
I'm new to DBA,i don't know much about Backup & Recovery,so anyway help me how to trobleshoot this problem.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
