SQL> select file_id,tablespace_name,file_name,status from dba_data_files; FILE_ID TABLESPACE FILE_NAME STATUS ---------- ---------- -------------------------------------- --------- 4 USERS /oradata/orcl2/users01.dbf AVAILABLE 3 UNDOTBS1 /oradata/orcl2/undotbs01.dbf AVAILABLE 2 SYSAUX /oradata/orcl2/sysaux01.dbf AVAILABLE 1 SYSTEM /oradata/orcl2/system01.dbf AVAILABLE 6 BOOK /oradata/orcl2/book.dbf AVAILABLE 5 SG /oradata/orcl2/SG01.dbf AVAILABLE SQL> select file#,status,name from v$datafile; FILE# STATUS NAME ---------- ------- ---------------------------------------- 1 SYSTEM /oradata/orcl2/system01.dbf 2 ONLINE /oradata/orcl2/sysaux01.dbf 3 ONLINE /oradata/orcl2/undotbs01.dbf 4 ONLINE /oradata/orcl2/users01.dbf 5 ONLINE /oradata/orcl2/SG01.dbf 6 ONLINE /oradata/orcl2/book.dbf
[oracle@DBA2 orcl2]$ rm SG01.dbf [oracle@DBA2 orcl2]$
[oracle@DBA2 orcl2]$ ps -ef|grep dbw|grep -v grep|awk '{print $2}' 3140
[oracle@DBA2 orcl2]$ cd /proc/3140/fd [oracle@DBA2 fd]$ ls -al total 0 dr-x------ 2 oracle oinstall 0 Sep 4 09:28 . dr-xr-xr-x 7 oracle oinstall 0 Sep 4 09:28 .. lr-x------ 1 oracle oinstall 64 Sep 4 09:41 0 -> /dev/null l-wx------ 1 oracle oinstall 64 Sep 4 09:41 1 -> /dev/null l-wx------ 1 oracle oinstall 64 Sep 4 09:41 10 -> /u/oracle/diag/rdbms/orcl2/orcl2/trace/orcl2_ora_3056.trc l-wx------ 1 oracle oinstall 64 Sep 4 09:41 11 -> /u/oracle/diag/rdbms/orcl2/orcl2/trace/orcl2_ora_3056.trm lr-x------ 1 oracle oinstall 64 Sep 4 09:41 12 -> /u/oracle/product/11.2/rdbms/mesg/oraus.msb lr-x------ 1 oracle oinstall 64 Sep 4 09:41 13 -> /dev/zero lr-x------ 1 oracle oinstall 64 Sep 4 09:41 14 -> /proc/3140/fd lr-x------ 1 oracle oinstall 64 Sep 4 09:41 15 -> /dev/zero lrwx------ 1 oracle oinstall 64 Sep 4 09:41 16 -> /u/oracle/product/11.2/dbs/hc_orcl2.dat lrwx------ 1 oracle oinstall 64 Sep 4 09:41 17 -> /u/oracle/product/11.2/dbs/lkORCL2 lrwx------ 1 oracle oinstall 64 Sep 4 09:41 18 -> /oradata/orcl2/control01.ctl lrwx------ 1 oracle oinstall 64 Sep 4 09:41 19 -> /u/oracle/flash_recovery_area/orcl2/control02.ctl l-wx------ 1 oracle oinstall 64 Sep 4 09:41 2 -> /dev/null lrwx------ 1 oracle oinstall 64 Sep 4 09:41 20 -> /oradata/orcl2/system01.dbf lrwx------ 1 oracle oinstall 64 Sep 4 09:41 21 -> /oradata/orcl2/sysaux01.dbf lrwx------ 1 oracle oinstall 64 Sep 4 09:41 22 -> /oradata/orcl2/undotbs01.dbf lrwx------ 1 oracle oinstall 64 Sep 4 09:41 23 -> /oradata/orcl2/users01.dbf lrwx------ 1 oracle oinstall 64 Sep 4 09:41 24 -> /oradata/orcl2/SG01.dbf (deleted) lrwx------ 1 oracle oinstall 64 Sep 4 09:41 25 -> /oradata/orcl2/book.dbf lrwx------ 1 oracle oinstall 64 Sep 4 09:41 26 -> /oradata/orcl2/temp01.dbf lrwx------ 1 oracle oinstall 64 Sep 4 09:41 27 -> /oradata/orcl2/temp02.dbf lrwx------ 1 oracle oinstall 64 Sep 4 09:41 28 -> /oradata/orcl2/temo01.dbf lr-x------ 1 oracle oinstall 64 Sep 4 09:41 29 -> /u/oracle/product/11.2/rdbms/mesg/oraus.msb l-wx------ 1 oracle oinstall 64 Sep 4 09:41 3 -> /u/oracle/product/11.2/rdbms/log/orcl2_ora_3056.trc lr-x------ 1 oracle oinstall 64 Sep 4 09:41 4 -> /dev/null lr-x------ 1 oracle oinstall 64 Sep 4 09:41 5 -> /dev/null lr-x------ 1 oracle oinstall 64 Sep 4 09:41 6 -> /dev/null lrwx------ 1 oracle oinstall 64 Sep 4 09:41 7 -> /u/oracle/product/11.2/dbs/hc_orcl2.dat lrwx------ 1 oracle oinstall 64 Sep 4 09:41 8 -> /u/oracle/product/11.2/dbs/lkinstorcl2 (deleted) lr-x------ 1 oracle oinstall 64 Sep 4 09:41 9 -> /proc/3140/fd
[oracle@DBA2 fd]$ cp 24 /oradata/SG.dbf
SQL> select file#,status,name from v$datafile; FILE# STATUS NAME ---------- ------- -------------------------------------- 1 SYSTEM /oradata/orcl2/system01.dbf 2 ONLINE /oradata/orcl2/sysaux01.dbf 3 ONLINE /oradata/orcl2/undotbs01.dbf 4 ONLINE /oradata/orcl2/users01.dbf 5 ONLINE /oradata/orcl2/SG01.dbf 6 ONLINE /oradata/orcl2/book.dbf
SQL> alter database datafile 5 offline; Database altered. SQL> select file#,status,name from v$datafile; FILE# STATUS NAME ---------- ------- -------------------------------------- 1 SYSTEM /oradata/orcl2/system01.dbf 2 ONLINE /oradata/orcl2/sysaux01.dbf 3 ONLINE /oradata/orcl2/undotbs01.dbf 4 ONLINE /oradata/orcl2/users01.dbf 5 RECOVER /oradata/orcl2/SG01.dbf 6 ONLINE /oradata/orcl2/book.dbf
SQL> alter database rename file '/oradata/orcl2/SG01.dbf' to '/oradata/SG.dbf'; Database altered.
SQL> recover datafile 5; Media recovery complete. SQL> select file#,status,name from v$datafile; FILE# STATUS NAME ---------- ------- -------------------------------------- 1 SYSTEM /oradata/orcl2/system01.dbf 2 ONLINE /oradata/orcl2/sysaux01.dbf 3 ONLINE /oradata/orcl2/undotbs01.dbf 4 ONLINE /oradata/orcl2/users01.dbf 5 OFFLINE /oradata/SG.dbf 6 ONLINE /oradata/orcl2/book.dbf
SQL> alter database datafile 5 online; Database altered. SQL> select file#,status,name from v$datafile; FILE# STATUS NAME ---------- ------- -------------------------------------- 1 SYSTEM /oradata/orcl2/system01.dbf 2 ONLINE /oradata/orcl2/sysaux01.dbf 3 ONLINE /oradata/orcl2/undotbs01.dbf 4 ONLINE /oradata/orcl2/users01.dbf 5 ONLINE /oradata/SG.dbf 6 ONLINE /oradata/orcl2/book.dbf