Oracle Rman Backup in-depth analysis-online backup

Oracle Rman Backup in-depth analysis-online backup

Rman> backup Database plus archivelog;

1. First, the process uses the ALTER system Archivelog current command to complete the log switching operation.

2. Process will have all existing archived redo log backups

3. Start the actual database backup operation, where a log switchover (alter system archivelog current) occurs, while Rman backs up the remaining archive redo logs (using the Backup archivelog All command).

4. Perform automatic backup operation of control file and server parameter file.

Case:

1. Check the log information before backup

17:13:50 [email protected] prod>select group#,sequence#,thread#,status from V$log; group# sequence# thread# STATUS----------------------------------------------1 1 curre NT 2 1 INACTIVE 3 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

[email protected] ~]$ tail-f/u01/app/oracle/diag/rdbms/prod/prod/trace/alert_prod.log

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

Thu Jul 03 17:13:50 2014

Archived Log entry added for thread 1 sequence 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 (LGWR switch)

Current log# 2 seq# mem# 0:/dsk1/oradata/prod/redo02a.log

Current log# 2 seq# mem# 1:/dsk2/oradata/prod/redo02b.log

Archived Log entry added for thread 1 sequence 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 (LGWR switch)

Current log# 3 seq# mem# 0:/dsk1/oradata/prod/redo03a.log

Current log# 3 seq# mem# 1:/dsk2/oradata/prod/redo03b.log

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

4. Post-BACKUP log switching information

17:13:56 [email protected] 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&nBsp 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   &nBsp 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

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1434114