OracleRMAN(备份与恢复管理器).doc
文本预览下载声明
/blog/876180
1、 要使用RMAN备份前提是必须启动ORACLE归档日志功能;?2、 首先检查数据库归档日志模式,以DBA用户模式登陆系统,执行?
Sql代码??
SELECT?log_mode?from?v$database;--查看数据库归档方式??
3、 如果结果为NOARCHIVELOG则需要将数据库模式设置为归档模式,否则跳过此步?A、 关闭数据库?
Sql代码??
SQL?shutdown?immediate;??
B、 挂起模式启动数据库?
Sql代码??
SQL?startup?mount;??
C、 将数据库设置成归档模式?
Sql代码??
SQL?alter?database?archivelog;??
D、 启动数据库?
Sql代码??
SQL?alter?database?open;??
E、 重新做第二步的检查,如果为ARCHIVELOG表明数据库归档模式启动成功;?4、 利用RMAN做批处理备份脚本,为了简单这里只做两层的备份,0级备份和1级备份,0级备份代表全库备份,1级为增量备份:?A、 批处理脚本,可以根据实际情况做稍许调整,这边不做详细介绍了,经我测试在win7下执行是无问题的?
Bat代码??
set?oracle_sid=orcl??
set?y=%date:~0,4%??
set?m=%date:~5,2%??
set?d=%date:~8,2%??
set?h=%time:~0,2%??
set?mi=%time:~3,2%??
set?s=%time:~6,2%??
rman?target?/?log?f:\backup\logs\%y%%m%%d%_%h%%mi%%s%.log?cmdfile=F:\backup\backupscript\database_backup_orcl_level0.rman??
??
pause??
B、 RMAN脚本?
Sql代码??
================FILENAME:?database_backup_orcl_level0.rman==============??
================我是分割线====0级备份===============================??
??
RUN{??
?configure?retention?policy?to?redundancy?2;??
?#CONFIGURE?RETENTION?POLICY?TO?RECOVERY?WINDOW?OF??1??DAYS;??
??
?CONFIGURE?CONTROLFILE?AUTOBACKUP?ON;??
??
???
?CONFIGURE?CONTROLFILE?AUTOBACKUP?FORMAT?FOR?DEVICE?TYPE?DISK?TO?f:/backup/%F%T.control_bak;??
??
?ALLOCATE?CHANNEL?CH1?DEVICE?TYPE?DISK?FORMAT?f:/backup/%U%T%t.bak;??
??
?BACKUP?AS?COMPRESSED?BACKUPSET?INCREMENTAL?LEVEL=0?DATABASE?SKIP?INACCESSIBLE?FILESPERSET?10???
??
?????PLUS?ARCHIVELOG?FILESPERSET?20??
??
?????DELETE?ALL?INPUT;??
??
?RELEASE?CHANNEL?CH1;??
}??
??
?ALLOCATE?CHANNEL?FOR?MAINTENANCE?DEVICE?TYPE?DISK;??
??
?CROSSCHECK?BACKUPSET;??
??
?DELETE?NOPROMPT?OBSOLETE;??
===============分割线==============================================??
================FILENAME:?database_backup_orcl_level1.rman==============??
================我是分割线====1级备份===============================??
RUN{??
?configure?retention?policy?to?redundancy?2;??
?#CONFIGURE?RETENTION?POLICY?TO?RECOVERY?WINDOW?OF??1??DAYS;??
??
?CONFIGURE?CONTROLFILE?AUTOBACKUP?ON;??
??
显示全部