(篇幅原因,有省略……)
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原则创建的数据库目录大都被删除。相关文件也被删除。
下面就可以进行恢复过程。