使用RMAN进行同名数据库异地环境搭建实验(二)

2014-11-24 17:24:22 · 作者: · 浏览: 1
located channel: ORA_DISK_1


(篇幅原因,有省略……)


piece handle=/oflinebk/09p28ukd_1_1 tag=TAG20140303T165713 comment=NONE


channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02


Finished backup at 03-MAR-14


RMAN> backup current controlfile format '/oflinebk/control.bks';


Starting backup at 03-MAR-14


using channel ORA_DISK_1


channel ORA_DISK_1: starting full datafile backupset


(篇幅原因,有省略……)


piece handle=/oflinebk/control.bks tag=TAG20140303T165824 comment=NONE


channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01


Finished backup at 03-MAR-14


RMAN> backup spfile format '/oflinebk/spfile.bks';


Starting backup at 03-MAR-14


using channel ORA_DISK_1


(篇幅原因,有省略……)


piece handle=/oflinebk/spfile.bks tag=TAG20140303T165841 comment=NONE


channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01


Finished backup at 03-MAR-14


必要的备份元素已经具备。注意:如果从完善的角度,对TNS网络参数三文件:tnsnames.ora、listener.ora和sqlnet.ora最好也进行备份。


3、数据库删除


配置XWindows工具调用dbca将原数据库删除。


[oracle@SimpleLinuxUp oflinebk]$ export DISPLAY=192.168.0.1:0.0


[oracle@SimpleLinuxUp oflinebk]$ xclock


Warning: Missing charsets in String to FontSet conversion


调用dbca删除数据库。




删除数据库确认。


SQL> conn / as sysdba


Connected to an idle instance.


SQL> startup


ORA-01078: failure in processing system parameters


LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initoratest.ora'


注意:使用dbca删除数据库后,根据OFA原则创建的数据库目录大都被删除。相关文件也被删除。


下面就可以进行恢复过程。