OracleDataGuard_主库删除表空间 - 数据库编程

2941 RFS[4]: Identified database type as 'physical standby' Primary database is in MAXIMUM PERFORMANCE mode Primary database is in MAXIMUM PERFORMANCE mode RFS[4]: Successfully opened standby log 6: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby06.log' Sun Mar 30 10:58:12 2014 RFS[3]: Successfully opened standby log 7: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby07.log' Sun Mar 30 10:58:17 2014 Media Recovery Log /u01/app/oracle/oradata/PRODSTD/Disk2/arch/1_33_842523531.arc Recovery deleting file #5:'/u01/app/oracle/oradata/PRODSTD/Disk1/PRODSTD/datafile/o1_mf_swtich_t_9mh1rzf6_.dbf' from controlfile. Deleted Oracle managed file /u01/app/oracle/oradata/PRODSTD/Disk1/PRODSTD/datafile/o1_mf_swtich_t_9mh1rzf6_.dbf Recovery dropped tablespace 'SWTICH_TBS' Media Recovery Waiting for thread 1 sequence 34 (in transit) ----------------------------------------------------------------------------------------------------------- 6.查看备库数据文件 SYS@PRODSTD>

select file#,name from v$datafile;
FILE# NAME ---------- ------------------------------------------------------- 1 /u01/app/oracle/oradata/PRODSTD/Disk1/system01.dbf 2 /u01/app/oracle/oradata/PRODSTD/Disk1/undotbs01.dbf 3 /u01/app/oracle/oradata/PRODSTD/Disk1/sysaux01.dbf 4 /u01/app/oracle/oradata/PRODSTD/Disk1/example01.dbf 7 /u01/app/oracle/oradata/PRODSTD/Disk1/users01.dbf
此时备库的SWITCH_TBS表空间已经被删除。 ###########################################################################################################

OracleDataGuard_主库删除表空间(三)