二、进行数据的更改 $ sqlplus "/ as sysdba" SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 5 16:32:23 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SYS AS SYSDBA on 2005-04-05 16:32:23 >alter system switch logfile; System altered. SYS AS SYSDBA on 2005-04-05 16:32:30 >select count(*) from t; COUNT(*) ---------- 18956 SYS AS SYSDBA on 2005-04-05 16:33:03 >insert into t select * from t; 18956 rows created. SYS AS SYSDBA on 2005-04-05 16:33:17 >commit; Commit complete. SYS AS SYSDBA on 2005-04-05 16:33:19 >alter system switch logfile; System altered. SYS AS SYSDBA on 2005-04-05 16:33:45 >truncate table t; Table truncated. SYS AS SYSDBA on 2005-04-05 16:34:58 >alter system switch logfile; System altered. 日志序列的情况如下: SYS AS SYSDBA on 2005-04-05 16:35:00 > select * from v$log_history where recid >1811; RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# RESETLOGS_CHANGE# RESETLOGS_TIME ---------- ---------- ---------- ---------- ------------- 1812 554813757 1 1 10923677 2005-04-05 09:54:53 10925720 10923677 2005-04-05 09:54:53 1813 554813974 1 2 10925720 2005-04-05 10:55:57 10925827 10923677 2005-04-05 09:54:53 1814 554823464 1 3 10925827 2005-04-05 10:59:34 10947409 10923677 2005-04-05 09:54:53 1815 554828646 1 4 10947409 2005-04-05 13:37:44 10950318 10923677 2005-04-05 09:54:53 1816 554833748 1 5 10950318 2005-04-05 15:04:06 10953123 10923677 2005-04-05 09:54:53 1817 554833901 1 6 10953123 2005-04-05 16:29:08 10953187 10923677 2005-04-05 09:54:53 1818 554833950 1 7 10953187 2005-04-05 16:31:41 10953213 10923677 2005-04-05 09:54:53 1819 554834005 1 8 10953213 2005-04-05 16:32:30 10953633 10923677 2005-04-05 09:54:53 1820 554834118 1 9 10953633 2005-04-05 16:33:25 10953726 10923677 2005-04-05 09:54:53 9 rows selected. 关闭数据库: SYS AS SYSDBA on 2005-04-05 16:35:18 >shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SYS AS SYSDBA on 2005-04-05 16:37:30 >exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options 三、执行不完全恢复 $ rman target / Recovery Manager: Release 10.1.0.2.0 - 64bit Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database (not started) RMAN> startup mount; Oracle instance started database mounted Total System Global Area 314572800 bytes Fixed Size 1301704 bytes Variable Size 261890872 bytes Database Buffers 50331648 bytes Redo Buffers 1048576 bytes RMAN> run { 2> set until sequence 8 thread 1; 3> restore database; 4> recover database; 5> } executing command: SET until clause using target database controlfile instead of recovery catalog Starting restore at 2005-04-05 16:39:17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=160 devtype=DISK datafile 8 not processed because file is read-only channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /opt/oracle/oradata/eygle/system01.dbf restoring datafile 00002 to /opt/oracle/oradata/eygle/undotbs01.dbf restoring datafile 00003 to /opt/oracle/oradata/eygle/sysaux01.dbf restoring datafile 00006 to /opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_test_03xv34ny_.dbf restoring datafile 00009 to /data1/oradata/systemfile/bigtbs.dbf restoring datafile 00010 to /opt/oracle/oradata/eygle/dfmbrc.dbf channel ORA_DISK_1: restored backup piece 1 piece handle=/data5/flash_recovery_area/EYGLE/backupset /2005_04_05/o1_mf_nnndf_TAG20050405T162921_154m33kf_.bkp tag=TAG20050405T162921 channel ORA_DISK_1: restore complete channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00004 to /opt/oracle/oradata/eygle/users01.dbf restoring datafile 00005 to /data1/oradata/systemfile/eygle01.dbf restoring datafile 00007 to /opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_itpub_03xv5g66_.dbf channel ORA_DISK_1: restored backup piece 1 piece handle=/data5/flash_recovery_area/EYGLE/backupset /2005_04_05/o1_mf_nnndf_TAG20050405T162921_154m6dxm_.bkp tag=TAG20050405T162921 channel ORA_DISK_1: restore complete channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00011 to /opt/oracle/oradata/eygle/t2k01.dbf channel ORA_DISK_1: restored backup piece 1 piece handle=/data5/flash_recovery_area/EYGLE/backupset /2005_04_05/o1_mf_nnndf_TAG20050405T162921_154m76kz_.bkp tag=TAG20050405T162921 channel ORA_DISK_1: restore complete Finished restore at 2005-04-05 16:41:45 Starting recover at 2005-04-05 16:41:46 using channel ORA_DISK_1 datafile 8 not processed because file is offline starting media recovery archive log thread 1 sequence 7 is already on disk as file /data5/flash_recovery_area/EYGLE/archivelog /2005_04_05/o1_mf_1_7_154m8z7k_.arc channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=6 channel ORA_DISK_1: restored backup piece 1 piece handle=/data5/flash_recovery_area/EYGLE/backupset /2005_04_05/o1_mf_annnn_TAG20050405T163142_154m7jpo_.bkp tag=TAG20050405T163142 channel ORA_DISK_1: restore complete archive log filename=/data5/flash_recovery_area/EYGLE/archivelog /2005_04_05/o1_mf_1_6_154mtkfk_.arc thread=1 sequence=6 channel default: deleting archive log(s) archive log filename=/data5/flash_recovery_area/EYGLE/archivelog /2005_04_05/o1_mf_1_6_154mtkfk_.arc recid=302 stamp=554834513 archive log filename=/data5/flash_recovery_area/EYGLE/archivelog /2005_04_05/o1_mf_1_7_154m8z7k_.arc thread=1 sequence=7 media recovery complete Finished recover at 2005-04-05 16:41:57 RMAN> alter database open resetlogs; database opened RMAN> exit Recovery Manager complete.
