国产成人精品久久免费动漫-国产成人精品天堂-国产成人精品区在线观看-国产成人精品日本-a级毛片无码免费真人-a级毛片毛片免费观看久潮喷

您的位置:首頁技術(shù)文章
文章詳情頁

Oracle數(shù)據(jù)庫不完全恢復(fù)實例

瀏覽:65日期:2023-11-19 19:50:26
1、; 環(huán)境:操作系統(tǒng)aix5.2,數(shù)據(jù)庫Oracle9.22、; 模擬環(huán)境:1)首先使用rman作整個數(shù)據(jù)庫備份2)時間:# dateTue Aug 23 17:35:19 BEIDT 20053)操作:sql>truncate table scott.emp3、; 恢復(fù)數(shù)據(jù)庫到2005年8月23日17點35分19秒4、; 數(shù)據(jù)庫到mount狀態(tài)5、; 設(shè)置變量$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 clauseStarting restore at 23-AUG-05allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=14 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=15 devtype=DISKallocated channel: ORA_DISK_3channel ORA_DISK_3: sid=16 devtype=DISKallocated channel: ORA_DISK_4channel ORA_DISK_4: sid=17 devtype=DISKchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00003 to /oradata/hb130000/cwmlite01.dbfrestoring datafile 00010 to /oradata/hb130000/xdb01.dbfrestoring datafile 00012 to /oradata/hb130000/GFB.DBFrestoring datafile 00013 to /oradata/hb130000/CA.dbfrestoring datafile 00017 to /oradata/hb130000/GDSS.dbfchannel ORA_DISK_2: starting datafile backupset restorechannel ORA_DISK_2: specifying datafile(s) to restore from backup setrestoring datafile 00004 to /oradata/hb130000/drsys01.dbfrestoring datafile 00005 to /oradata/hb130000/example01.dbfrestoring datafile 00006 to /oradata/hb130000/indx01.dbfrestoring datafile 00014 to /oradata/hb130000/QUEST.dbfrestoring datafile 00018 to /oradata/hb130000/FPJKDB.dbfchannel ORA_DISK_3: starting datafile backupset restorechannel ORA_DISK_3: specifying datafile(s) to restore from backup setrestoring datafile 00002 to /oradata/hb130000/undotbs01.dbfrestoring datafile 00007 to /oradata/hb130000/odm01.dbfrestoring datafile 00009 to /oradata/hb130000/users01.dbfrestoring datafile 00011 to /oradata/hb130000/YSZX130000002005.DBFrestoring datafile 00015 to /oradata/hb130000/FOGLIGHT.dbfchannel ORA_DISK_4: starting datafile backupset restorechannel ORA_DISK_4: specifying datafile(s) to restore from backup setrestoring datafile 00001 to /oradata/hb130000/system01.dbfrestoring datafile 00008 to /oradata/hb130000/tools01.dbfrestoring datafile 00016 to /oradata/hb130000/gwd.dbfrestoring datafile 00019 to /oradata/hb130000/tgggg.dbfchannel ORA_DISK_2: restored backup piece 1piece handle=/oradata/rmanbackup/df_HB130000_567080235_66_1.bak tag=TAG20050823T 101715 params=NULLchannel ORA_DISK_2: restore completechannel ORA_DISK_3: restored backup piece 1piece handle=/oradata/rmanbackup/df_HB130000_567080235_67_1.bak tag=TAG20050823T101715 params=NULLchannel ORA_DISK_3: restore completechannel ORA_DISK_1: restored backup piece 1piece handle=/oradata/rmanbackup/df_HB130000_567080236_68_1.bak tag=TAG20050823T101715 params=NULLchannel ORA_DISK_1: restore completechannel ORA_DISK_4: restored backup piece 1piece handle=/oradata/rmanbackup/df_HB130000_567080237_69_1.bak tag=TAG20050823T101715 params=NULLchannel ORA_DISK_4: restore completeFinished restore at 23-AUG-05Starting recover at 23-AUG-05using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3using channel ORA_DISK_4starting media recoveryarchive log thread 1 sequence 4 is already on disk as file /oradata/rmanbackup/archive/hb130000_1_4.dbfchannel ORA_DISK_1: starting archive log restore to default destinationchannel ORA_DISK_1: restoring archive logarchive log thread=1 sequence=3channel ORA_DISK_1: restored backup piece 1piece handle=/oradata/rmanbackup/df_HB130000_567080296_72_1.bak tag=TAG20050823T101815 params=NULLchannel ORA_DISK_1: restore completearchive log filename=/oradata/rmanbackup/archive/hb130000_1_3.dbf thread=1 sequence=3media recovery completeFinished recover at 23-AUG-05RMAN>7、; 連接到數(shù)據(jù)庫$sqlplus nologsql>conn / as sysdbaconnectedsql>alter database open resetlogsdatabase altered.8、查詢表scott.emp數(shù)據(jù)得到恢復(fù)。
主站蜘蛛池模板: 久久99精品久久久久久久不卡 | aaaaaa精品视频在线观看 | 在线免费黄色网址 | 最新欧美一级视频 | 久久久久久国产精品免费 | 国产高清成人mv在线观看 | 2021国产精品系列一区二区 | 国产自在自线午夜精品视频在 | 久久亚洲精品一区成人 | 国产成人麻豆tv在线观看 | 国产午夜精品久久理论片小说 | 三级毛片在线播放 | 国产精品久久久久久影视 | 亚洲日本在线观看视频 | 成人三级精品视频在线观看 | 男人和女人在床做黄的网站 | 欧美中文一区 | 国产男女爽爽爽爽爽免费视频 | aaaaaa精品视频在线观看 | 亚洲欧洲日韩在线 | 日韩三级在线观看视频 | 一 级 黄 色 片生活片 | 私人玩物福利 | 国内精品久久久久久久aa护士 | 日韩国产成人精品视频人 | 成人黄网18免费观看的网站 | 毛片免费全部免费播放 | 香蕉超级碰碰碰97视频蜜芽 | 日本三片在在线播放 | 国产精品女上位在线观看 | 欧美毛片在线 | 91精品一区二区三区在线观看 | 久久草在线视频免费 | 免费特黄级夫费生活片 | 欧美xx在线观看 | 国产高清在线精品一区二区 | 黄色美女视频免费 | 欧美三级真做在线观看 | 国产在线一区观看 | 久久国产精品久久久久久久久久 | 国产中文字幕免费观看 |