---------- ---------------------------------------- ------- ------------------
1 C:\ORACLE\ORADATA\RC\SYSTEM01.DBF SYSTEM 493334
2 C:\ORACLE\ORADATA\RC\UNDOTBS01.DBF ONLINE 493334
3 C:\ORACLE\ORADATA\RC\SYSAUX01.DBF ONLINE 493334
4 C:\ORACLE\ORADATA\RC\USERS01.DBF ONLINE 493334
5 C:\ORACLE\ORADATA\RC\CQF01.DBF RECOVER 493623
6 C:\ORACLE\ORADATA\RC\CQF02.DBF RECOVER 493623
6 rows selected.
SQL> alter tablespace cqf online;
alter tablespace cqf online
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'C:\ORACLE\ORADATA\RC\CQF01.DBF'
SQL> recover tablespace cqf;
Media recovery complete.
SQL> alter tablespace cqf online;
Tablespace altered.
SQL> select FILE#,NAME,STATUS,CHECKPOINT_CHANGE# from v$datafile;
FILE# NAME STATUS CHECKPOINT_CHANGE#
---------- ---------------------------------------- ------- ------------------
1 C:\ORACLE\ORADATA\RC\SYSTEM01.DBF SYSTEM 493334
2 C:\ORACLE\ORADATA\RC\UNDOTBS01.DBF ONLINE 493334
3 C:\ORACLE\ORADATA\RC\SYSAUX01.DBF ONLINE 493334
4 C:\ORACLE\ORADATA\RC\USERS01.DBF ONLINE 493334
5 C:\ORACLE\ORADATA\RC\CQF01.DBF ONLINE 493752
6 C:\ORACLE\ORADATA\RC\CQF02.DBF ONLINE 493752
6 rows selected.
3. Datafile offline
SQL> alter database datafile 5 offline;
Database altered.
SQL> select FILE#,NAME,STATUS,CHECKPOINT_CHANGE# from v$datafile;
FILE# NAME STATUS CHECKPOINT_CHANGE#
---------- ---------------------------------------- ------- ------------------
1 C:\ORACLE\ORADATA\RC\SYSTEM01.DBF SYSTEM 493334
2 C:\ORACLE\ORADATA\RC\UNDOTBS01.DBF ONLINE 493334
3 C:\ORACLE\ORADATA\RC\SYSAUX01.DBF ONLINE 493334
4 C:\ORACLE\ORADATA\RC\USERS01.DBF ONLINE 493334
5 C:\ORACLE\ORADATA\RC\CQF01.DBF RECOVER 493752
6 C:\ORACLE\ORADATA\RC\CQF02.DBF ONLINE 493752
6 rows selected.
SQL> alter database datafile 5 online;
alter database datafile 5 online
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'C:\ORACLE\ORADATA\RC\CQF01.DBF'
SQL> recover datafile 5;
Media recovery complete.
SQL> alter database datafile 5 online;
Database altered.
SQL> select FILE#,NAME,STATUS,CHECKPOINT_CHANGE# from v$datafile;
FILE# NAME STATUS CHECKPOINT_CHANGE#
---------- ---------------------------------------- ------- ------------------
1 C:\ORACLE\ORADATA\RC\SYSTEM01.DBF SYSTEM 493334
2 C:\ORACLE\ORADATA\RC\UNDOTBS01.DBF ONLINE 493334
3 C:\ORACLE\ORADATA\RC\SYSAUX01.DBF ONLINE 493334
4 C:\ORACLE\ORADATA\RC\USERS01.DBF ONLINE 493334