Physical Standby 转 Logical Standby

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;  

Database altered.

SQL> alter database recover to logical standby ATYU30STD;

Database altered.

SQL> SHUTDOWN IMMEDIATE
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 5133828096 bytes
Fixed Size                  2091072 bytes
Variable Size            2650802112 bytes
Database Buffers         2466250752 bytes
Redo Buffers               14684160 bytes
Database mounted.
SQL> SHOW PARAMETER DB_NAME;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      ATYU30STD
SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE
----------------
LOGICAL STANDBY

SQL>