2
DG
1
DG
SQL> SELECT DEST_ID, STATUS, ERROR FROM V$ARCHIVE_DEST_STATUS
DEST_ID STATUS ERROR
---------- --------- --------------------------------------
1 VALID
2 VALID
SQL> SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SE
SEQUENCE# APPLIED
---------- ---------
13 YES
12 YES
11 YES
Real-Time Apply
archived redo log MRP
standby redolog
standby redolog
redolog
redolog redolog
online redolog 3 status active
recover managed standby database cancel;
DG
2
alter database add standby logfile thread 1
group 4'/u02/app/oracle/oradata/PROD1/stdredo04.log' size 2097
group 5'/u02/app/oracle/oradata/PROD1/stdredo05.log' size 2097
group 6'/u02/app/oracle/oradata/PROD1/stdredo06.log' size 2097
group 7'/u02/app/oracle/oradata/PROD1/stdredo07.log' size 2097
recover managed standby database using current logfile discon
select name,database_role,protection_mode,open_mode from v$da
SQL> select name,database_role,protection_mode,open_mode from
NAME DATABASE_ROLE PROTECTION_MODE OPEN_MODE
--------- ---------------- -------------------- -------------
PROD1 PRIMARY MAXIMUM PERFORMANCE READ WRITE
SQL> select name,database_role,protection_mode,open_mode from
NAME DATABASE_ROLE PROTECTION_MODE OPEN_MODE
--------- ---------------- -------------------- -------------
PROD1 PHYSICAL STANDBY MAXIMUM PERFORMANCE READ ONLY WITH
SQL> recover managed standby database cancel;
Media recovery complete.
SQL> select name,database_role,protection_mode,open_mode from
NAME DATABASE_ROLE PROTECTION_MODE OPEN_MODE
--------- ---------------- -------------------- -------------
PROD1 PHYSICAL STANDBY MAXIMUM PERFORMANCE READ ONLY
using current logfile
of 10
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论