Shulou(Shulou.com)06/01 Report--

In-depth Analysis of Oracle RMAN backup-- online backup

RMAN > backup database plus archivelog

This command triggers the following actions:

1. First, the process completes the log switching operation using the alter system archivelog current command.

2. The process redoes log backups of all existing archives.

3. Start the actual database backup operation, at which time a log switch (alter system archivelog current) occurs, and RMAN backs up the remaining archive redo logs (using the backup archivelog all command).

4. Perform automatic backup of control files and server parameter files.

Case study:

1. View the log information before backup

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.05

2. Perform backup

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. Check the alarm log

[oracle@rh7] $tail-f / u01/app/oracle/diag/rdbms/prod/prod/trace/alert_prod.log

Current log# 1 seq# 16 mem# 1: / dsk2/oradata/prod/redo01b.log

Thu Jul 03 17:13:50 2014

Archived Log entry 43 added for thread 1 sequence 15 ID 0xfaf1e60 dest 2:

Thu Jul 03 17:15:41 2014

ALTER SYSTEM ARCHIVE LOG

Thu Jul 03 17:15:41 2014

Thread 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.log

Archived Log entry 44 added for thread 1 sequence 16 ID 0xfaf1e60 dest 2:

Thu Jul 03 17:17:11 2014

ALTER SYSTEM ARCHIVE LOG

Thu Jul 03 17:17:11 2014

Thread 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.log

Archived Log entry 45 added for thread 1 sequence 17 ID 0xfaf1e60 dest 2:

4. Log switching information after backup

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.01

5. View backup information

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 Murray 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 MurJul- 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.