|
E
/u02/app/oracle/oradata/orcl/DEV3_ias_opss.dbf? ? ? DEV3_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_oggmon.dbf? ? ? DEV3_OGGMON? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV2_ias_opss.dbf? ? ? DEV2_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_UMS.dbf? ? ? DEV3_IAS_UMS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_svctbl.dbf? ? ? DEV3_STB? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV2_oggmon.dbf? ? ? DEV2_OGGMON? ? ? AVAILABLE ONLINE
/home/oracle/tt_mv3.dbf? ? ? ? TT? ? ? AVAILABLE RECOVER
/home/oracle/undo02.dbf? ? ? ? UNDOTBS1? ? ? AVAILABLE ONLINE
19 rows selected.
sys@ORCL>alter database datafile '/home/oracle/tt_mv3.dbf' online;
alter database datafile '/home/oracle/tt_mv3.dbf' online;
alter database datafile '/home/oracle/tt_mv3.dbf' online
*
ERROR at line 1:
ORA-01113: file 18 needs media recovery
ORA-01110: data file 18: '/home/oracle/tt_mv3.dbf'
sys@ORCL>recover datafile '/home/oracle/tt_mv3.dbf';
recover datafile '/home/oracle/tt_mv3.dbf';
Media recovery complete.
sys@ORCL>alter database datafile '/home/oracle/tt_mv3.dbf' online;
alter database datafile '/home/oracle/tt_mv3.dbf' online;
Database altered.
sys@ORCL>select file_name,tablespace_name,status,online_status from dba_data_files;
select file_name,tablespace_name,status,online_status from dba_data_files;
FILE_NAME? ? ? TABLESPACE_NAME? ? ? STATUSONLINE_
---------------------------------------------------------------------- ------------------------------ --------- -------
/u02/app/oracle/oradata/orcl/users01.dbf? ? ? USERS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/undotbs01.dbf? ? ? UNDOTBS1? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/sysaux01.dbf? ? ? SYSAUX? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/system01.dbf? ? ? SYSTEM? ? ? AVAILABLE SYSTEM
/u02/app/oracle/oradata/orcl/DEV_svctbl.dbf? ? ? DEV_STB? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV_ias_opss.dbf? ? ? DEV_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV_iau.dbf? ? ? DEV_IAU? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV_veridata_user.dbf? ? ? DEV_VERIDATA_USER? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_mds.dbf? ? ? DEV3_MDS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_wlsservices.dbf? ? ? DEV3_WLS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_iau.dbf? ? ? DEV3_IAU? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_ias_opss.dbf? ? ? DEV3_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_oggmon.dbf? ? ? DEV3_OGGMON? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV2_ias_opss.dbf? ? ? DEV2_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_UMS.dbf? ? ? DEV3_IAS_UMS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_svctbl.dbf? ? ? DEV3_STB? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV2_oggmon.dbf? ? ? DEV2_OGGMON? ? ? AVAILABLE ONLINE
/home/oracle/tt_mv3.dbf? ? ? ? TT? ? ? AVAILABLE ONLINE
/home/oracle/undo02.dbf? ? ? ? UNDOTBS1? ? ? AVAILABLE ONLINE
19 rows selected.
|