ORA-16079: standby archival not enabled
Cause: The standby database did not have archival enabled.
Action: In order to allow the standby database to access the standby log files, the standby database must be in ARCHIVELOG mode.
ORA-16079:standby archival not enabled 异常表示,没有启用 standby archival 功能。
ORA-16079被抛出,表明standby archival log archival没有启用。你必须启用standby archival log archiving,才能准备备库。
当试图在Data Guard环境中创建或开启备库状态时,出现ORA-16079错误。
1、在协调端里,增加参数 LOG_ARCHIVE_DEST_n=’SERVICE=standby_host VALID_FOR=(ONLINE_LOGFILE,ALL_ROLES) DB_UNIQUE_NAME=standby_db_name ARCH ASYNC NOAFFIRM’
2、在standby端,打开参数 log_archive_config
alter system set log_archive_config=’/a,service=standby_host valid_for=(online_logfile,all_roles) db_unique_name=standby_db_name arch async noaffirm’ scope=both;
3、开启standby端的archival
alter system set log_archive_dest_state_2=enable scope=both;
4、重启standby端实例(必要时)
shutdown immediate;
startup mount;
alter database recover managed standby database finish;
alter database open read only;