Oracle10g恢复测试报告.doc

第一部分 Oracle10g全库恢复测试报告 一．检查数据库启动状态 [oracle@X3610_1 orcl]$ ps -ef | grep oracle 二．连接数据库 [oracle@X3610_1 orcl]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 3 13:01:47 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL conn sys/oracle as sysdba; Connected. 三．检查归档方式 SQL archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/10g/arch Oldest online log sequence 1 Next log sequence to archive 17 Current log sequence 17 四．关闭数据库 SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 五．查看orcl实例下的文件 [oracle@X3610_1 orcl]$ ls control01.ctl control03.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbf control02.ctl redo01.log redo03.log system01.dbf undotbs01.dbf 六．删除日志及数据库文件 [oracle@X3610_1 orcl]$ rm -rf *.log *.dbf [oracle@X3610_1 orcl]$ ls control01.ctl control02.ctl control03.ctl 七．mount数据库 SQL startup mount; ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started. Total System Global Area 1124073472 bytes Fixed Size 1218968 bytes Variable Size 301991528 bytes Database Buffers 805306368 bytes Redo Buffers bytes Database mounted. 八．进入rman运行恢复 [oracle@X3610_1 orcl]$ rman target sys/oracle@orcl nocatalog Recovery Manager: Release 10.2.0.1.0 - Production on Tue Nov 3 13:04:30 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: ORCL (DBID=1229312341, not open) using target database control file instead of recovery catalog ### 恢复命令 ### RMAN run 2 { 3 allocate channel c1 type SBT_TAPE; 4 restore database; 5 recover database; 6 release channel c1; 7 } allocated channel: c1 channel c1: sid=155 devtype=SBT_TAPE channel c1: Veritas NetBackup for Oracle - Release 6.5 (2007072323) Starting restore at 03-NOV-09 channel c1: starting datafile backupset restore channel c1: s