Oracle RMAN备份深入解析--联机备份

RMAN> backup database plus archivelog;此命令将触发以下操作：1、首先，进程使用alter system archivelog current命令完成了日志切换操作。2、进程将现存所有归档重做日志备份3、开始执行实际的数据库备份操作，此时会发生一次日志切换（alter system archivelog current），同时RMAN备份剩余的归档重做日志（使用backup archivelog all命令）。4、执行控制文件和服务器参数文件的自动备份操作。--------------------------------------------------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htmLinux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm--------------------------------------------------------------------------------案例：1、查看备份前的日志信息17:13:50 SYS@ prod>select group#,sequence#,thread#,status from v$log; GROUP# SEQUENCE# THREAD# STATUS---------- ---------- ---------- ---------------- 1 16 1 CURRENT 2 14 1 INACTIVE 3 15 1 INACTIVEElapsed: 00:00:00.052、执行备份RMAN> backup database plus archivelog; Starting backup at 03-JUL-14current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log（s） in backup setinput archived log thread=1 sequence=13 RECID=41 STAMP=851966028input archived log thread=1 sequence=14 RECID=42 STAMP=851966028input archived log thread=1 sequence=15 RECID=43 STAMP=851966030input archived log thread=1 sequence=16 RECID=44 STAMP=851966141channel ORA_DISK_1: starting piece 1 at 03-JUL-14channel ORA_DISK_1: finished piece 1 at 03-JUL-14piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0kpcfu5t_1_1 tag=TAG20140703T171541 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:04Finished backup at 03-JUL-14Starting backup at 03-JUL-14using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile（s） in backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/prod/system01.dbfinput datafile file number=00002 name=/u01/app/oracle/oradata/prod/sysaux01.dbfinput datafile file number=00008 name=/u01/app/oracle/oradata/prod/perftbs01.dbfinput datafile file number=00004 name=/u01/app/oracle/oradata/prod/users01.dbfinput datafile file number=00005 name=/u01/app/oracle/oradata/prod/example01.dbfinput datafile file number=00007 name=/u01/app/oracle/oradata/prod/undotbs2.dbfinput datafile file number=00006 name=/u01/app/oracle/oradata/prod/tbs1.dbfinput datafile file number=00003 name=/u01/app/oracle/oradata/prod/undotbs1.dbfchannel ORA_DISK_1: starting piece 1 at 03-JUL-14channel ORA_DISK_1: finished piece 1 at 03-JUL-14piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1 tag=TAG20140703T171545 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:26Finished backup at 03-JUL-14Starting backup at 03-JUL-14current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log（s） in backup setinput archived log thread=1 sequence=17 RECID=45 STAMP=851966231channel ORA_DISK_1: starting piece 1 at 03-JUL-14channel ORA_DISK_1: finished piece 1 at 03-JUL-14piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0mpcfu8o_1_1 tag=TAG20140703T171712 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 03-JUL-14Starting Control File and SPFILE Autobackup at 03-JUL-14piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/c-239333010-20140703-00 comment=NONEFinished Control File and SPFILE Autobackup at 03-JUL-14
3、查看告警日志[oracle@rh6 ~]$ tail -f /u01/app/oracle/diag/rdbms/prod/prod/trace/alert_prod.log Current log# 1 seq# 16 mem# 1: /dsk2/oradata/prod/redo01b.logThu Jul 03 17:13:50 2014Archived Log entry 43 added for thread 1 sequence 15 ID 0xfaf1e60 dest 2:Thu Jul 03 17:15:41 2014ALTER SYSTEM ARCHIVE LOGThu Jul 03 17:15:41 2014Thread 1 advanced to log sequence 17 （LGWR switch） Current log# 2 seq# 17 mem# 0: /dsk1/oradata/prod/redo02a.log Current log# 2 seq# 17 mem# 1: /dsk2/oradata/prod/redo02b.logArchived Log entry 44 added for thread 1 sequence 16 ID 0xfaf1e60 dest 2:Thu Jul 03 17:17:11 2014ALTER SYSTEM ARCHIVE LOGThu Jul 03 17:17:11 2014Thread 1 advanced to log sequence 18 （LGWR switch） Current log# 3 seq# 18 mem# 0: /dsk1/oradata/prod/redo03a.log Current log# 3 seq# 18 mem# 1: /dsk2/oradata/prod/redo03b.logArchived Log entry 45 added for thread 1 sequence 17 ID 0xfaf1e60 dest 2:4、备份后的日志切换信息17:13:56 SYS@ prod>select group#,sequence#,thread#,status from v$log; GROUP# SEQUENCE# THREAD# STATUS---------- ---------- ---------- ---------------- 1 16 1 INACTIVE 2 17 1 ACTIVE 3 18 1 CURRENTElapsed: 00:00:00.015、查看备份信息RMAN> list backup of database;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------17 Full 1.13G DISK 00:01:21 03-JUL-14 BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171545 Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1 List of Datafiles in backup set 17 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/system01.dbf 2 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/sysaux01.dbf 3 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs1.dbf 4 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/users01.dbf 5 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/example01.dbf 6 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/tbs1.dbf 7 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs2.dbf 8 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/perftbs01.dbf RMAN> list backup of archivelog all;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------16 31.11M DISK 00:00:01 03-JUL-14 BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171541 Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0kpcfu5t_1_1 List of Archived Logs in backup set 16 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 13 2051289 03-JUL-14 2066660 03-JUL-14 1 14 2066660 03-JUL-14 2066663 03-JUL-14 1 15 2066663 03-JUL-14 2066666 03-JUL-14 1 16 2066666 03-JUL-14 2066878 03-JUL-14BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------18 104.00K DISK 00:00:00 03-JUL-14 BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171712 Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0mpcfu8o_1_1 List of Archived Logs in backup set 18 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 17 2066878 03-JUL-14 2066956 03-JUL-14更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址