Hello,
I created the logical standby database.
I used the document "http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ls.htm"
So, after a I open with resetlogs the logical standby, I try to start the Log apply with:
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
But this command returns:
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE
*
ERROR at line 1:
ORA-00254: error in archive control string ''
ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 625
ORA-06512: at line 1
My configuration of log archive is:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------------------------------------------------------------
log_archive_config string DG_CONFIG=(PROD, STBY)
log_archive_dest_1 string LOCATION=+ORAFRA VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STBY
log_archive_dest_2 string SERVICE=PROD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PROD
log_archive_dest_3 string LOCATION=+ORADATA VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=STBY
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_3 string ENABLE
fal_client string STBY
fal_server string PROD
The db_name is correct. I updated this parameter with:
ALTER DATABASE RECOVER TO LOGICAL STANDBY STBY; (the Oracle document).
Somebody can help me?
Thank you very much!!!!