Oracle DataGaurd
Oracle DataGaurd[@more@]
v$archived_log
v$archive_dest_status
Read-Only Mode
1 , startup nomount;
2 , alter database mount standby database;
3 , alter database open read only;
1 , alter database recover managed standby database cancel;
2 , alter database open read only;
To move the standby database from read-only mode back to managed recovery mode :
1 , Terminate all active user sessions on the standby database;
2 , Restart log apply services : alter database recover managed standby database;
DataGaurd
---------------------------
Log Transport Services:
Log Apply Services:(Managed Recovery Mode , Read-Only Mode)
alter system set Log_archive_trace = integer ;
Remote File Service (RFS)
Archiver (ARCn)
Managed Recovery Process (MRP)
Start the standby instance
1 , startup nomount;
2 , alter database mount standby database;
Initiating Log Apply Services
Log apply services can run as a foreground session or as a background process with
control options such as CANCEL, FINISH, TIMEOUT, DELAY, DISCONNECT, and PARALLEL.
alter database recover managed standby database;
alter database recover managed standby database disconnect from session;
Monitoring the Recovery Process :
v$managed_standby
Controlling Managed Recovery Mode :
To control the managed recovery operation, use the TIMEOUT, CANCEL, NODELAY, DELAY, NEXT,
PARALLEL, FINISH, EXPIRE, and DISCONNECT control options.
< cancel , cancel immediate , cancel nowait >
< disconnect , disconnect [from session] >
< EXPIRE : This means that the value of the EXPIRE control option is the earliest amount of time that the
managed recovery operation will terminate, but it could be significantly later than the specified value. >
---------------------------
Log Transport Services:
Log Apply Services:(Managed Recovery Mode , Read-Only Mode)
alter system set Log_archive_trace = integer ;
Remote File Service (RFS)
Archiver (ARCn)
Managed Recovery Process (MRP)
Start the standby instance
1 , startup nomount;
2 , alter database mount standby database;
Initiating Log Apply Services
Log apply services can run as a foreground session or as a background process with
control options such as CANCEL, FINISH, TIMEOUT, DELAY, DISCONNECT, and PARALLEL.
alter database recover managed standby database;
alter database recover managed standby database disconnect from session;
Monitoring the Recovery Process :
v$managed_standby
Controlling Managed Recovery Mode :
To control the managed recovery operation, use the TIMEOUT, CANCEL, NODELAY, DELAY, NEXT,
PARALLEL, FINISH, EXPIRE, and DISCONNECT control options.
< cancel , cancel immediate , cancel nowait >
< disconnect , disconnect [from session] >
< EXPIRE : This means that the value of the EXPIRE control option is the earliest amount of time that the
managed recovery operation will terminate, but it could be significantly later than the specified value. >
v$archived_log
v$archive_dest_status
Read-Only Mode
1 , startup nomount;
2 , alter database mount standby database;
3 , alter database open read only;
1 , alter database recover managed standby database cancel;
2 , alter database open read only;
To move the standby database from read-only mode back to managed recovery mode :
1 , Terminate all active user sessions on the standby database;
2 , Restart log apply services : alter database recover managed standby database;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66634/viewspace-863610/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11G support different OS Platform DataGaurd ( windows and linux )OraclePlatformWindowsLinux
- DataGaurd環境主庫崩潰後將備庫切為主庫
- oracle DBLink oracleOracle
- Oracle 中$ORACLE_HOME/bin/oracle檔案Oracle
- oracle 修改ORACLE例項Oracle
- oracle安裝工具目錄常用解釋oracle wallet manager/Oracle Directory Manager /oracle net manager /Oracle Net ManagOracle
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- 【Oracle】oracle tablespace&datafile -- oracle表空間 分享[轉]Oracle
- cx_Oracle 連線 OracleOracle
- [Oracle]Oracle良性SQL建議OracleSQL
- oracle之 Oracle LOB 詳解Oracle
- [oracle]centos 7 安裝oracleOracleCentOS
- Oracle工具(Oracle Tools) – SQLT(SQLTXPLAIN)OracleSQLAI
- oracle clone oracle_home 方法Oracle
- oracle 817 archive err,oracle hangOracleHive
- 【Oracle】修改oracle監聽埠Oracle
- 【Oracle】Oracle常用EVENT之三Oracle
- 【Oracle】Oracle常用EVENT之二Oracle
- 【Oracle】Oracle常用EVENT之一Oracle
- Oracle Clusterware and Oracle Grid InfrastructureOracleASTStruct
- 【Oracle】--"任性"Oracle安裝之旅Oracle
- OracleOracle
- Oracle vs PostgreSQL DBA(21)- Oracle VPDOracleSQL
- 【Oracle】Oracle logminer功能介紹Oracle
- Oracle案例12——NBU Oracle恢復Oracle
- [Oracle] -- 配置Oracle環境變數Oracle變數
- 「Oracle」Oracle 資料庫安裝Oracle資料庫
- oracle 12c Deprecation of Oracle StreamsOracle
- Oracle HowTo:How to get Oracle SCN?Oracle
- Oracle Temporary Tables(Oracle 臨時表)Oracle
- ORACLE_BASE 與 ORACLE_HOMEOracle
- Oracle OAF(Oracle Application Framework) SampleOracleAPPFramework
- 20 Differences Between Oracle on NT and Oracle on UnixOracle
- Oracle技術專題 - Oracle瑣Oracle
- ORACLE-BASE - Oracle DBA and development articlesOracledev
- oracle 學習筆記 (ORACLE NET )Oracle筆記
- For oracle databases, if the top showing the oracle database, then oracle process is using the top cOracleDatabase
- Oracle 之 Cloning $oracle_home (克隆安裝oracle軟體)Oracle