ITPub博客

首页 > 数据库 > Oracle > DATAGUARD配置RMAN的archivelog参数引起 RMAN-08591:

DATAGUARD配置RMAN的archivelog参数引起 RMAN-08591:

原创 Oracle 作者:13175 时间:2013-12-01 22:11:59 0 删除 编辑
RMAN> backup datafile 7;


Starting backup at 01-DEC-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=D:\APP\JIN\ORADATA\JJKK\JJKK.DBF
channel ORA_DISK_1: starting piece 1 at 01-DEC-13
channel ORA_DISK_1: finished piece 1 at 01-DEC-13
piece handle=D:\APP\JIN\PRODUCT\11.2.0\FRA\JJKK\BACKUPSET\2013_12_01\O1_MF_NNNDF_TAG20131201T220230_99PJCP97_.BKP tag=TAG2
0131201T220230 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-DEC-13
RMAN-08591: WARNING: invalid archived log deletion policy

oerr rman 8591 
8591, 3, "WARNING: invalid archived log deletion policy" 
// *Cause: An invalid ARCHIVELOG DELETION POLICY was supplied. The archived 
// log deletion policy was APPLIED but there was no mandatory 
// archived log destinations. 
// *Action: One of the following: 
// 1) Change archived log deletion policy using CONFIGURE command 
// 2) Make one or more of standby destination as MANDATORY. 



RMAN> show all;


RMAN configuration parameters for database with db_unique_name JJKK are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;    <<<原来做了DATAGRARD的实验,没有取消这条配置。
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\JIN\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFJJKK.ORA'; # default



RMAN> configure ARCHIVELOG DELETION POLICY clear;


old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
RMAN configuration parameters are successfully reset to default value


RMAN> show all;


RMAN configuration parameters for database with db_unique_name JJKK are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default  <<<恢复为默认了
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\JIN\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFJJKK.ORA'; # default




RMAN> backup datafile 7;


Starting backup at 01-DEC-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=D:\APP\JIN\ORADATA\JJKK\JJKK.DBF
channel ORA_DISK_1: starting piece 1 at 01-DEC-13
channel ORA_DISK_1: finished piece 1 at 01-DEC-13
piece handle=D:\APP\JIN\PRODUCT\11.2.0\FRA\JJKK\BACKUPSET\2013_12_01\O1_MF_NNNDF_TAG20131201T220603_99PJLCQZ_.BKP tag=TAG2
0131201T220603 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-DEC-13    <<<搞定


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/14181270/viewspace-1061802/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-22

  • 博文量
    52
  • 访问量
    224927