国产成人精品久久免费动漫-国产成人精品天堂-国产成人精品区在线观看-国产成人精品日本-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ù)。
主站蜘蛛池模板: 国产精品久久在线观看 | 三级美国| 免费在线观看的毛片 | 国产成人一区二区视频在线观看 | 精品国产精品久久一区免费式 | 成年男女免费视频网站 | 亚洲精品一区二区三区网址 | 成人软件18免费网站 | 在线观看视频99 | 99九九国产精品免费视频 | 最新国产午夜精品视频不卡 | 美女很黄很黄 | 久久久久久精 | 国产综合成人亚洲区 | 久久不见久久见免费影院www日本 | 草草视频在线免费观看 | 大视频在线爱爱爱爱 | 国产成人麻豆精品 | 色一欲一性一乱一区二区三区 | 99视频免费在线 | 国产成人爱片免费观看视频 | 日本aaa成人毛片 | 久久久久久综合成人精品 | 精品在线播放 | 久久夜视频 | 色偷偷亚洲偷自拍 | 日本人一级毛片免费视频 | 国产一区二区三区亚洲欧美 | 国产小网站 | 欧美成人老熟妇暴潮毛片 | 一级黄色片aaa | 欧美一级特黄一片免费 | 99爱在线观看精品视频 | 韩日精品 | 欧美大片aaaa一级毛片 | 欧美另类videosbestsex久久 | 国产成人亚洲精品一区二区在线看 | 高清一级淫片a级中文字幕 高清一区二区 | 女人夜色黄网在线观看 | 精品久久久久久中文字幕网 | 日韩一级在线视频 |