Oracle DG 归档设置验证出现的问题
Oracle DG 归档设置验证出现的问题
Oracle DG 归档设置验证出现的问题
- --主库
- SQL> col status for a10
- SQL> col destination for a20
- SQL> col error for a20
- SQL> SELECT STATUS,DESTINATION, ERROR FROM V$ARCHIVE_DEST;
- STATUS DESTINATION ERROR
- ---------- -------------------- --------------------
- VALID /home/oracle/flash_r
- ecovery_area/ORCL/ar
- chivelog
- ERROR orcl_st ORA-12514:
- TNS:listener does
- not currently know
- of service
- requested in
- connect descriptor
- STATUS DESTINATION ERROR
- ---------- -------------------- --------------------
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- 10 rows selected.
- --备库
- SQL> col status for a10
- SQL> col destination for a20
- SQL> col error for a20
- SQL> SELECT STATUS,DESTINATION, ERROR FROM V$ARCHIVE_DEST;
- STATUS DESTINATION ERROR
- ---------- -------------------- --------------------
- VALID /home/oracle/flash_r
- ecovery_area/ORCL/ar
- chivelog
- ERROR orcl_pd ORA-12514:
- TNS:listener does
- not currently know
- of service
- requested in
- connect descriptor
- STATUS DESTINATION ERROR
- ---------- -------------------- --------------------
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- INACTIVE
- VALID /home/oracle/flash_r
- ecovery_area/ORCL/ar
- chivelog
- STATUS DESTINATION ERROR
- ---------- -------------------- --------------------
- 11 rows selected.
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (SID_NAME = PLSExtProc)
- (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
- (PROGRAM = extproc)
- )
- <span style="background-color: rgb(0, 153, 0);">(SID_DESC =
- (GLOBAL_DBNAME = orcl)
- (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
- (SID_NAME = orcl)
- )
- </span>
- )
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = target)(PORT = 1521))
- )
- )
同样查询V$ARCHIVE_DEST或v$archive_dest_status:
SQL> select status,destination, error from v$archive_dest;
SQL> select error from v$archive_dest_status;
出现以下错误:
ORA-16009: remote archive log destination must be a STANDBY database
修改 主库与备库的log_archive_dest_2 参数,添加valid_for=(online_logfiles,primary_role) 选项
- SQL>alter system set log_archive_dest_2='service=orcl_pd valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=orcl_pd'
- scope=both;
- SQL>alter system set log_archive_dest_2='service=orcl_st valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=orcl_st'
- scope=both;
更多Oracle相关信息见Oracle 专题页面 http://www.bkjia.com/topicnews.aspx?tid=12
评论暂时关闭