亚洲激情专区-91九色丨porny丨老师-久久久久久久女国产乱让韩-国产精品午夜小视频观看

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

12c Oracle 定期驗證備份文件

發布時間:2020-07-16 21:26:12 來源:網絡 閱讀:898 作者:roidba 欄目:關系型數據庫

數據庫備份大家都知道,正常也會每天都定時備份,但是很少有人去做備份文件的驗證。一旦,我們需要使用備份文件,備份文件確實損壞的那就悲催了。定期每個月做一次備份驗證是必要的。

RMAN> restore database validate;

Starting restore at 12-JAN-2018 21:49:31
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/db_fullbk_19_1_965249636.rmn
channel ORA_DISK_1: piece handle=/u01/bak/db_fullbk_19_1_965249636.rmn tag=BACKUP_FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/db_fullbk_18_1_965249636.rmn
channel ORA_DISK_1: piece handle=/u01/bak/db_fullbk_18_1_965249636.rmn tag=BACKUP_FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/db_fullbk_17_1_965249636.rmn
channel ORA_DISK_1: piece handle=/u01/bak/db_fullbk_17_1_965249636.rmn tag=BACKUP_FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:55
Finished restore at 12-JAN-2018 21:51:02

RMAN> 

RMAN> restore archivelog from time 'sysdate-1' validate;

Starting restore at 12-JAN-2018 21:59:39
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/archive_24_1_965249706.arc
channel ORA_DISK_1: piece handle=/u01/bak/archive_24_1_965249706.arc tag=TAG20180112T205505
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/archive_22_1_965249706.arc
channel ORA_DISK_1: piece handle=/u01/bak/archive_22_1_965249706.arc tag=TAG20180112T205505
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/archive_23_1_965249706.arc
channel ORA_DISK_1: piece handle=/u01/bak/archive_23_1_965249706.arc tag=TAG20180112T205505
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/archive_21_1_965249706.arc
channel ORA_DISK_1: piece handle=/u01/bak/archive_21_1_965249706.arc tag=TAG20180112T205505
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/archive_25_1_965249717.arc
channel ORA_DISK_1: piece handle=/u01/bak/archive_25_1_965249717.arc tag=TAG20180112T205505
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/archive_35_1_965253442.arc
channel ORA_DISK_1: piece handle=/u01/bak/archive_35_1_965253442.arc tag=TAG20180112T215722
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u01/bak/archive_34_1_965253442.arc
channel ORA_DISK_1: piece handle=/u01/bak/archive_34_1_965253442.arc tag=TAG20180112T215722
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
Finished restore at 12-JAN-2018 21:59:50

RMAN> restore controlfile validate;

Starting restore at 12-JAN-2018 21:54:47
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece +DATADG/ORCL/AUTOBACKUP/2018_01_12/s_965249725.381.965249727
channel ORA_DISK_1: piece handle=+DATADG/ORCL/AUTOBACKUP/2018_01_12/s_965249725.381.965249727 tag=TAG20180112T205525
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
Finished restore at 12-JAN-2018 21:54:48

RMAN> restore spfile validate;

Starting restore at 12-JAN-2018 21:54:57
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece +DATADG/ORCL/AUTOBACKUP/2018_01_12/s_965249725.381.965249727
channel ORA_DISK_1: piece handle=+DATADG/ORCL/AUTOBACKUP/2018_01_12/s_965249725.381.965249727 tag=TAG20180112T205525
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
Finished restore at 12-JAN-2018 21:54:58

RMAN> 
向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

正阳县| 日照市| 金沙县| 磴口县| 出国| 东丰县| 巩义市| 合江县| 武山县| 泗洪县| 缙云县| 仁化县| 峡江县| 高唐县| 曲阜市| 七台河市| 巴林左旗| 连南| 岑巩县| 罗定市| 南召县| 临江市| 波密县| 中牟县| 承德县| 云安县| 城步| 江都市| 玉门市| 湖州市| 荣昌县| 健康| 常熟市| 临桂县| 青海省| 唐海县| 青冈县| 云和县| 漳州市| 萝北县| 获嘉县|