NAME DATABASE_ROLE DB_UNIQUE_NAME
-------------------------------------------------------------- ------------------------------------------------------------
FELIX PRIMARY felix_pd
(2)备库执行
17:14:34 SQL>select name,DATABASE_ROLE,DB_UNIQUE_NAME from v$database;
NAME DATABASE_ROLE DB_UNIQUE_NAME
--------------------------------------------------------------------------------------------------------------------------
FELIX PHYSICAL STANDBY felix_st
然后打开主备库:
alter database open;
进行日志切换:
alter system switch logile;
查看日志是否同步:
(主库)17:22:42 SQL>selectmax(sequence#) from v$log;
MAX(SEQUENCE#)
--------------
20
(备库)17:23:18 SQL>selectmax(sequence#) from v$log;
MAX(SEQUENCE#)
--------------
20
OK,到此全部执行完成!!