時間：2015-06-28 00:00:00 來源：IT貓撲網(wǎng) 作者：網(wǎng)管聯(lián)盟 我要評論(1)
??? 備份——全庫備份。
??? 啟動數(shù)據(jù)庫到archivelog模式
??? rman target=rman/rman
??? rman>backup database plus archivelog delete input;
??? 刪除兩個用戶及相關(guān)表后。
??? 恢復(fù)部分內(nèi)容——基于時間點(diǎn)的恢復(fù)。
??? [root@ccj 2009_10_22]# ll
??? 總用量1299304
??? -rw-r-----? 1 oracle oinstall?? 39169536 10月 22 14:31 o1_mf_annnn_TAG20091022T143115_5fzz1oyv_.bkp -rw-r-----? 1 oracle oinstall????? 30208 10月 22 14:36 o1_mf_annnn_TAG20091022T143634_5fzzcmfo_.bkp -rw-r-----? 1 oracle oinstall??? 7110656 10月 22 14:27 o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp -rw-r-----? 1 oracle oinstall??? 7110656 10月 22 14:36 o1_mf_ncnnf_TAG20091022T143121_5fzzcg0l_.bkp -rw-r-----? 1 oracle oinstall 1275740160 10月 22 14:36 o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp
??? [root@ccj 2009_10_22]# pwd
??? /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22
??? [oracle@ccj ~]$ export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
??? [oracle@ccj ~]$
??? [oracle@ccj ~]$ export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
??? [oracle@ccj ~]$ rman target=rman/rman
??? Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 22 17:08:54 2009
??? Copyright (c) 1982, 2005, Oracle.? All rights reserved.
??? connected to target database: ORCL (DBID=1223339172)
??? RMAN> restore database;
??? Starting restore at 2009-10-22 17:23:29
??? using channel ORA_DISK_1
??? 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/orcl/system01.dbf restoring datafile 00002 to /opt/oracle/oradata/orcl/undotbs01.dbf restoring datafile 00003 to /opt/oracle/oradata/orcl/sysaux01.dbf restoring datafile 00004 to /opt/oracle/oradata/orcl/users01.dbf restoring datafile 00005 to /opt/oracle/oradata/orcl/example01.dbf restoring datafile 00006 to /opt/oracle/oradata/db/reporter.dbf restoring datafile 00007 to /opt/oracle/oradata/db/sm_db.dbf restoring datafile 00008 to /opt/oracle/product/10g/dbs/nhnmcc_data.data channel ORA_DISK_1: reading from backup piece /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp
??? channel ORA_DISK_1: restored backup piece 1
??? piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp tag=TAG20091022T143121 channel ORA_DISK_1: restore complete, elapsed time: 00:02:38
??? Finished restore at 2009-10-22 17:26:09
??? RMAN> recover database until time '2009-10-22 14:37:00';
??? Starting recover at 2009-10-22 17:26:58
??? using channel ORA_DISK_1
??? starting media recovery
??? media recovery complete, elapsed time: 00:00:05
??? Finished recover at 2009-10-22 17:27:04
??? 最后，alter database open resetlogs;
??? 注：備份時archivelog狀態(tài)，恢復(fù)時候mount狀態(tài)；
??? 可能用到的命令sql>alter session set NLS_date_format = 'YYYY-MM-DD HH24:MI:SS'
關(guān)鍵詞標(biāo)簽：RMAN不完全恢復(fù)
相關(guān)閱讀
熱門文章
Linux EXT3文件系統(tǒng)誤刪文件恢復(fù)
RAID數(shù)據(jù)恢復(fù)常見故障處理手冊
數(shù)據(jù)無價 讓硬盤不被惡意格式化
反反復(fù)復(fù)的磁盤丟失故障處理過程
人氣排行 誤分區(qū) 誤格式化 誤刪除數(shù)據(jù)恢復(fù)挽救方法 "一鍵GHOST"傻瓜式系統(tǒng)備份與恢復(fù) 硬盤格式化也可破解還原 恢復(fù)被誤刪QQ好友獨(dú)門秘技 “卷影”共享文件：實戰(zhàn)卷影服務(wù) 實戰(zhàn)破解交換機(jī)密碼 Linux EXT3文件系統(tǒng)誤刪文件恢復(fù) 硬盤出現(xiàn)壞道的征兆與修復(fù)辦法