-
编辑 删除
如何恢复在全备后添加了数据文件的数据库
参考How to Recover a Database Having Added a Datafile Since Last Backup (文档 ID 29430.1)HOW TO RECOVER A DATABASE HAVING ADDED A DATAFILE SINCE THE LAST BACKUP-----------------------------------------------------------------------This bulletin outlines the steps required in performing databas...
-
编辑 删除
处理过期的archivelog和rman备份
当手工删除了归档日志以后，Rman备份会检测到日志缺失，从而无法进一步继续执行。所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常。[执行顺序如下：手工删除archivelog --->crosscheck--->delete expired 最后可以用list copy检查]试验如下：1.Crosscheck日志RMAN> crosscheck archivelog all;2、...
-
编辑 删除
RAC数据库的RMAN备份异机恢复到单节点数据库
1、首先在rac环境用rman备份数据库。[oracle@rac1 admin]$ rman target /run{allocate channel c1 device type disk connect 'sys/welcome123@IRAC1';allocate channel c2 device type disk connect 'sys/welcome123@IRAC2';backup AS COMPRESSED BACKUPSET incremental level= 0 Database format=...
-
编辑 删除
查看备份信息脚本
查看某个备份集SPFILESELECT DISTINCT A.SET_STAMP, B.COMPLETION_TIME, HANDLEFROM V$BACKUP_SPFILE B, V$BACKUP_PIECE A WHERE A.SET_STAMP = B.SET_STAMP AND A.DELETED = 'NO' AND B.SET_STAMP = &SET_STAMP; 查看RMAN的配置信息SELECT NAME,VALUE FROM V$RMAN_CONFIGURATION...
-
编辑 删除
RMAN恢复脚本案例
$ crontab -l0 12,19 * * * $ORACLE_HOME/scripts/arcbkup.sh59 03 * * * $ORACLE_HOME/scripts/dbbkup.sh30 9 * * * $ORACLE_HOME/scripts/delete.sh5 20 * * * $ORACLE_HOME/nmon.sh$ more $ORACLE_HOME/scripts/arcbkup.sh#/usr/bin/sh#. XXX.env. XXX.envrman target / cmdfile=XXX/bkup_p...
