1. ADG数据库没有打开
SQL> @check
select * from sys.test01 where rowid in(select max(rowid) from sys.test01)
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SELECT dt from sys.checkadg where id =1
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10456: cannot open standby database; media recovery session may be in
progress
SQL>
2. 操作步骤:
# 先在从库停止standby
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database open;
Database altered.
# 启动日志应用
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL>
3. 测试ADG
SQL> @check
FILE_NAME
--------------------------------------------------------------------------------
2019-11-24 13:30:46
DT
------------------------------------------------------------
2019-11-24 14:04:47
SQL> select max(sequence#),thread# from v$archived_log where RESETLOGS_CHANGE# = (SELECT RESETLOGS_CHANGE# FROM V$DATABASE_INCARNATION WHERE STATUS = 'CURRENT') GROUP BY THREAD#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
188142 1
108461 2
SQL>
SQL> set line 999
SQL> set tab off
SQL> select name, value from v$dataguard_stats;
NAME VALUE
-------------------------------- ----------------------------------------------------------------
transport lag +00 00:00:00
apply lag +00 00:00:00
apply finish time +00 00:00:00.000
estimated startup time 26
SQL>
4. 其他
SQL> set tab off
SQL> show parameter fal;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string
fal_server string orcldg
SQL> alter database recover managed standby database using current logfile disconnect from session;