Oracle數據庫不完全恢復實例
2024-08-29 13:49:46
供稿：網友
1、 環境：操作系統aix5.2，數據庫Oracle9.22、 模擬環境：1）首先使用rman作整個數據庫備份2）時間：# dateTue Aug 23 17:35:19 BEIDT 20053）操作：sql>truncate table scott.emp3、 恢復數據庫到2005年8月23日17點35分19秒4、 數據庫到mount狀態5、 設置變量$set nls_date_format=yyyy-mm-dd:hh24:mi:ss6、 連接到rman$rman target / catalog rman/rman@omsora9RMAN> run {
2> set until time="to_date('2005-08-23:17:35:19','yyyy-mm-dd:hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
executing command: SET until clause
Starting restore at 23-AUG-05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=15 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=16 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=17 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /oradata/hb130000/cwmlite01.dbf
restoring datafile 00010 to /oradata/hb130000/xdb01.dbf
restoring datafile 00012 to /oradata/hb130000/GFB.DBF
restoring datafile 00013 to /oradata/hb130000/CA.dbf
restoring datafile 00017 to /oradata/hb130000/GDSS.dbf
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /oradata/hb130000/drsys01.dbf
restoring datafile 00005 to /oradata/hb130000/example01.dbf
restoring datafile 00006 to /oradata/hb130000/indx01.dbf
restoring datafile 00014 to /oradata/hb130000/QUEST.dbf
restoring datafile 00018 to /oradata/hb130000/FPJKDB.dbf
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /oradata/hb130000/undotbs01.dbf
restoring datafile 00007 to /oradata/hb130000/odm01.dbf
restoring datafile 00009 to /oradata/hb130000/users01.dbf
restoring datafile 00011 to /oradata/hb130000/YSZX130000002005.DBF
restoring datafile 00015 to /oradata/hb130000/FOGLIGHT.dbf
channel ORA_DISK_4: starting datafile backupset restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata/hb130000/system01.dbf
restoring datafile 00008 to /oradata/hb130000/tools01.dbf
restoring datafile 00016 to /oradata/hb130000/gwd.dbf
restoring datafile 00019 to /oradata/hb130000/tgggg.dbf
channel ORA_DISK_2: restored backup piece 1
piece handle=/oradata/rmanbackup/df_HB130000_567080235_66_1.bak tag=TAG20050823T
101715 params=NULL
channel ORA_DISK_2: restore complete
channel ORA_DISK_3: restored backup piece 1
piece handle=/oradata/rmanbackup/df_HB130000_567080235_67_1.bak tag=TAG20050823T
101715 params=NULL
channel ORA_DISK_3: restore complete
channel ORA_DISK_1: restored backup piece 1
piece handle=/oradata/rmanbackup/df_HB130000_567080236_68_1.bak tag=TAG20050823T
101715 params=NULL
channel ORA_DISK_1: restore complete
channel ORA_DISK_4: restored backup piece 1
piece handle=/oradata/rmanbackup/df_HB130000_567080237_69_1.bak tag=TAG20050823T
101715 params=NULL
channel ORA_DISK_4: restore complete
Finished restore at 23-AUG-05
Starting recover at 23-AUG-05
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
starting media recovery
archive log thread 1 sequence 4 is already on disk as file /oradata/rmanbackup/a
rchive/hb130000_1_4.dbf
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=3
channel ORA_DISK_1: restored backup piece 1
piece handle=/oradata/rmanbackup/df_HB130000_567080296_72_1.bak tag=TAG20050823T
101815 params=NULL
channel ORA_DISK_1: restore complete
archive log filename=/oradata/rmanbackup/archive/hb130000_1_3.dbf thread=1 seque
nce=3
media recovery complete
Finished recover at 23-AUG-05
RMAN>
7、 連接到數據庫
$sqlplus nolog
sql>conn / as sysdba
connected
sql>alter database open resetlogs
database altered.
8、查詢表scott.emp數據得到恢復。
