Oracle数据库rman的基于序列号和SCN号不完全恢复.doc

Oracle数据库rman的基于序列号和SCN号不完全恢复 先创建个简单的表 SQL create table students 2 (name varchar2(20),student_id number(10),grade varchar2(8)); 再向表中插入数据 SQL insert into students (name,student_id,grade) 2 values (ZhangMing,01,1); 1 row created. SQL insert into students (name,student_id,grade) 2 values (wangxue,02,1); 1 row created. SQL commit; Commit complete. SQL select * from students; NAME STUDENT_ID GRADE -------------------- ---------- ---------- ZhangMing 1 1 wangxue 2 1 SQL select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS ---------- ---------- ---------- ---------- ---------- --- ---------------- FIRST_CHANGE# FIRST_TIM ------------- --------- 1 1 1 1 YES INACTIVE 729700 25-NOV-12 2 1 2 1 YES ACTIVE 750090 25-NOV-12 3 1 3 1 NO CURRENT 755397 26-NOV-12 SQL archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 2 Next log sequence to archive 4 Current log sequence 4 RMAN run{ 2 backup archivelog all format /u01/oradata/arch/ar_%s_%t_%p.dbf; 3 backup current controlfile format /u01/oradata/backup/ctl_%s_%t_%p.dbf; 4 } Starting backup at 26-NOV-12 current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=149 devtype=DISK channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=14 recid=36 stamp=800291481 input archive log thread=1 sequence=15 recid=38 stamp=800291482 input archive log thread=1 sequence=16 recid=41 stamp=800296089 input archive log thread=1 sequence=17 recid=43 stamp