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

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;    <<
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博客 ” ，链接：http://blog.itpub.net/14181270/viewspace-1061802/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14181270/viewspace-1061802/