oracle 归档日志策略,RMAN 配置归档日志删除策略

迈不过友情╰ 2022-10-21 12:59 434阅读 0赞

5、演示归档日志删除策略

\[Oracle@linux1 ~\]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Nov 12 15:10:17 2013

\--查看当前数据库保留策略

RMAN> show retention policy;

RMAN configuration parameters for database with db\_unique\_name USBO are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; \# default

\--查看当前数据库保归档日志留策略

RMAN> show archivelog deletion policy;

RMAN configuration parameters for database with db\_unique\_name USBO are:

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; \# default

\--查看过时的备份

RMAN> report obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

no obsolete backups found

\--列出copy副本

RMAN> list copy;

specification does not match any datafile copy in the repository

specification does not match any control file copy in the repository

List of Archived Log Copies for database with db\_unique\_name USBO

=====================================================================

Key    Thrd Seq    S Low Time

\------- ---- ------- - -------------------

124    1    121    A 2013/11/12 15:34:15

Name: /u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_121\_983pm3gp\_.arc  --当前的归档日志

\--修改当前的归档日志保留策略为2个备份副本

RMAN> configure archivelog deletion policy to backed up 2 times to device type disk;

new RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;

new RMAN configuration parameters are successfully stored

\--备份归档日志，并删除已经备份的归档日志

RMAN> backup archivelog all delete input;

Starting backup at 2013/11/12 15:37:25

current log archived

using channel ORA\_DISK\_1

channel ORA\_DISK\_1: starting archived log backup set

channel ORA\_DISK\_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=121 RECID=124 STAMP=831310563

input archived log thread=1 sequence=122 RECID=125 STAMP=831310645

channel ORA\_DISK\_1: starting piece 1 at 2013/11/12 15:37:26

channel ORA\_DISK\_1: finished piece 1 at 2013/11/12 15:37:27

piece handle=/u03/database/usbo/fr\_area/USBO/backupset/2013\_11\_12/o1\_mf\_annnn\_TAG20131112T153726\_983pop3p\_.bkp

tag=TAG20131112T153726 comment=NONE

channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:01

channel ORA\_DISK\_1: deleting archived log(s)

RMAN-08138: WARNING: archived log not deleted - must create more backups --->出现警告提示，日志当前不能被删除，更多的备份需要创建

archived log file name=/u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_121\_983pm3gp\_.arc thread=1 sequence=121

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_122\_983pooxb\_.arc thread=1 sequence=122

Finished backup at 2013/11/12 15:37:27

\--从os层面查看归档日志，当前已备份的两个归档日志没有删除

sys@USBO> ho ls -hltr /u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/\*

\-rw-r----- 1 oracle asmadmin 3.0K Nov 12 15:36 /u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_121\_983pm3gp\_.arc

\-rw-r----- 1 oracle asmadmin 4.5K Nov 12 15:37 /u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_122\_983pooxb\_.arc

\--从视图查询也可以获得其状态

sys@USBO> select name,status from v$archived\_log where STATUS='A';

NAME                                                                            STA

\-------------------------------------------------------------------------------- ---

/u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_121\_983pm3gp\_.arc  A

/u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_122\_983pooxb\_.arc  A

\--第二次备份归档日志

\-- Author : Leshami

\-- Blog  : http://www.linuxidc.com

RMAN> backup archivelog all delete input tag=arc\_2nd;

Starting backup at 2013/11/12 15:41:58

current log archived

using channel ORA\_DISK\_1

channel ORA\_DISK\_1: starting archived log backup set

channel ORA\_DISK\_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=121 RECID=124 STAMP=831310563  --sequence 121与122依旧被备份

input archived log thread=1 sequence=122 RECID=125 STAMP=831310645

input archived log thread=1 sequence=123 RECID=126 STAMP=831310918

channel ORA\_DISK\_1: starting piece 1 at 2013/11/12 15:41:58

channel ORA\_DISK\_1: finished piece 1 at 2013/11/12 15:41:59

piece handle=/u03/database/usbo/fr\_area/USBO/backupset/2013\_11\_12/o1\_mf\_annnn\_ARC\_2ND\_983py6mv\_.bkp tag=ARC\_2ND comment=NONE

channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:01

channel ORA\_DISK\_1: deleting archived log(s)                      --sequence 121与122被删除

archived log file name=/u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_121\_983pm3gp\_.arc RECID=124 STAMP=831310563

archived log file name=/u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_122\_983pooxb\_.arc RECID=125 STAMP=831310645

RMAN-08138: WARNING: archived log not deleted - must create more backups --->出现警告提示，日志123不能被删除，更多的备份需要创建

archived log file name=/u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_123\_983py6gh\_.arc thread=1 sequence=123

\--再次查看，只有sequence 123存在，121与122已经被删除

RMAN> list copy;

specification does not match any datafile copy in the repository

specification does not match any control file copy in the repository

List of Archived Log Copies for database with db\_unique\_name USBO

=====================================================================

Key    Thrd Seq    S Low Time

\------- ---- ------- - -------------------

126    1    123    A 2013/11/12 15:37:25

Name: /u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_123\_983py6gh\_.arc

Finished backup at 2013/11/12 15:41:59

\--配置新的归档日志删除策略

RMAN> configure archivelog deletion policy to backed up 1 times to device type disk;

old RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;

new RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;

new RMAN configuration parameters are successfully stored

\--第三次备份归档日志

RMAN> backup archivelog all tag=arc\_3rd;

Starting backup at 2013/11/12 15:44:11

current log archived

using channel ORA\_DISK\_1      --下面是skip的提示信息，因为根据新的策略，sequence 123已经被备份过一次了

skipping archived log file /u03/database/usbo/fr\_area/USBO/archivelog/2013\_11\_12/o1\_mf\_1\_123\_983py6gh\_.arc; already backed up 1 time(s)

channel ORA\_DISK\_1: starting archived log backup set

channel ORA\_DISK\_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=124 RECID=127 STAMP=831311051

channel ORA\_DISK\_1: starting piece 1 at 2013/11/12 15:44:12

channel ORA\_DISK\_1: finished piece 1 at 2013/11/12 15:44:13

piece handle=/u03/database/usbo/fr\_area/USBO/backupset/2013\_11\_12/o1\_mf\_annnn\_ARC\_3RD\_983q2d34\_.bkp tag=ARC\_3RD comment=NONE

channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2013/11/12 15:44:13

\--清除策略

RMAN> configure archivelog deletion policy clear;

old RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;

RMAN configuration parameters are successfully reset to default value

\--列出所有归档日志的备份信息

RMAN> list backup of archivelog all;

List of Backup Sets

===================

BS Key  Size      Device Type Elapsed Time Completion Time

\------- ---------- ----------- ------------ -------------------

24      8.00K      DISK        00:00:00    2013/11/12 15:37:26

BP Key: 24  Status: AVAILABLE  Compressed: NO  Tag: TAG20131112T153726

Piece Name: /u03/database/usbo/fr\_area/USBO/backupset/2013\_11\_12/o1\_mf\_annnn\_TAG20131112T153726\_983pop3p\_.bkp

List of Archived Logs in backup set 24

Thrd Seq    Low SCN    Low Time            Next SCN  Next Time

\---- ------- ---------- ------------------- ---------- ---------

1    121    3090437    2013/11/12 15:34:15 3090507    2013/11/12 15:36:03

1    122    3090507    2013/11/12 15:36:03 3090591    2013/11/12 15:37:25

BS Key  Size      Device Type Elapsed Time Completion Time

\------- ---------- ----------- ------------ -------------------

25      37.50K    DISK        00:00:00    2013/11/12 15:41:58

BP Key: 25  Status: AVAILABLE  Compressed: NO  Tag: ARC\_2ND

Piece Name: /u03/database/usbo/fr\_area/USBO/backupset/2013\_11\_12/o1\_mf\_annnn\_ARC\_2ND\_983py6mv\_.bkp

List of Archived Logs in backup set 25

Thrd Seq    Low SCN    Low Time            Next SCN  Next Time

\---- ------- ---------- ------------------- ---------- ---------

1    121    3090437    2013/11/12 15:34:15 3090507    2013/11/12 15:36:03

1    122    3090507    2013/11/12 15:36:03 3090591    2013/11/12 15:37:25

1    123    3090591    2013/11/12 15:37:25 3090746    2013/11/12 15:41:58

BS Key  Size      Device Type Elapsed Time Completion Time

\------- ---------- ----------- ------------ -------------------

26      2.50K      DISK        00:00:00    2013/11/12 15:44:12

BP Key: 26  Status: AVAILABLE  Compressed: NO  Tag: ARC\_3RD

Piece Name: /u03/database/usbo/fr\_area/USBO/backupset/2013\_11\_12/o1\_mf\_annnn\_ARC\_3RD\_983q2d34\_.bkp

List of Archived Logs in backup set 26

Thrd Seq    Low SCN    Low Time            Next SCN  Next Time

\---- ------- ---------- ------------------- ---------- ---------

1    124    3090746    2013/11/12 15:41:58 3090839    2013/11/12 15:44:11

![0b1331709591d260c1c78e86d0c51c18.png][]

[0b1331709591d260c1c78e86d0c51c18.png]: /images/20221021/70a0487081304b6187120588840b4b1a.png

oracle 归档日志策略,RMAN 配置归档日志删除策略

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 oracle开启归档日志并修改归档日志路径

相关 PostgreSQL：WAL日志归档策略

相关 Oracle归档日志管理

相关 Oracle 归档日志管理

相关 oracle 归档日志策略,RMAN 配置归档日志删除策略

相关查询oracle归档日志是否开启,Oracle 开启归档日志以及关闭归档日志

相关 oracle归档日志配置查询

相关 oracle归档日志删除方法

相关 Oracle归档日志处理

相关如何正确删除Oracle 归档日志文件