SWITCHOVER VERIFY WARNING: switchover target has no standby database defined in LOG_ARCHIVE_DEST_n p
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name string
cell_offloadgroup_name string
db_file_name_convert string +DATA, +DATA
db_name string orcl
db_unique_name string orcl
global_names boolean FALSE
instance_name string orcl1
lock_name_space string
log_file_name_convert string +DATA, +DATA
pdb_file_name_convert string
processor_group_name string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL> ALTER DATABASE SWITCHOVER TO dgorcl VERIFY;
ALTER DATABASE SWITCHOVER TO dgorcl VERIFY
*
ERROR at line 1:
ORA-16475: succeeded with warnings, check alert log for more details
SQL> !oerr ora 16475
16475, 0000, "succeeded with warnings, check alert log for more details"
// *Cause: The ALTER DATABASE SWITCHOVER TO <target_db_name> VERIFY command
// succeeded but with warnings.
// *Action: Check alert log for more details.
SQL> select database_role,open_mode from v$database;
DATABASE_ROLE OPEN_MODE
---------------- --------------------
PRIMARY READ WRITE
alert日志提示信息：
SWITCHOVER VERIFY: Send VERIFY request to switchover target DGORCL
SWITCHOVER VERIFY WARNING: switchover target has no standby database defined in LOG_ARCHIVE_DEST_n parameter. If the switchover target is converted to a primary database, the new primary database will not be protected.
ORA-16475 signalled during: ALTER DATABASE SWITCHOVER TO dgorcl VERIFY...