OracleDataGuard部署分析
這篇文章主要介紹“Oracle Data Guard部署分析”，在日常操作中，相信很多人在Oracle Data Guard部署分析問(wèn)題上存在疑惑，小編查閱了各式資料，整理出簡(jiǎn)單好用的操作方法，希望對(duì)大家解答”O(jiān)racle Data Guard部署分析”的疑惑有所幫助！接下來(lái)，請(qǐng)跟著小編一起來(lái)學(xué)習(xí)吧！
成都創(chuàng)新互聯(lián)作為成都網(wǎng)站建設(shè)公司，專注網(wǎng)站建設(shè)公司、網(wǎng)站設(shè)計(jì)，有關(guān)成都企業(yè)網(wǎng)站定制方案、改版、費(fèi)用等問(wèn)題，行業(yè)涉及資質(zhì)代辦等多個(gè)領(lǐng)域，已為上千家企業(yè)服務(wù)，得到了客戶的尊重與認(rèn)可。
序言
DATAGUARD是通過(guò)建立一個(gè)PRIMARY和STANDBY組來(lái)確立其參照關(guān)系。
STANDBY一旦創(chuàng)建，DATAGUARD就會(huì)通過(guò)將主數(shù)據(jù)庫(kù)(PRIMARY)的REDO傳遞給STANDBY數(shù)據(jù)庫(kù)，然后在STANDBY中應(yīng)用REDO實(shí)現(xiàn)數(shù)據(jù)庫(kù)的同步。
有兩種類型的STANDBY：物理STANDBY和邏輯STANDBY。
物理STANDBY提供與主數(shù)據(jù)庫(kù)完全一樣的拷貝（塊到塊），數(shù)據(jù)庫(kù)SCHEMA，包括索引都是一樣的。它是直接應(yīng)用REDO實(shí)現(xiàn)同步的。邏輯STANDBY則不是這樣，在邏輯STANDBY中，邏輯信息是相同的，但物理組織和數(shù)據(jù)結(jié)構(gòu)可以不同，它和主庫(kù)保持同步的方法是將接收的REDO轉(zhuǎn)換成SQL語(yǔ)句，然后在STANDBY上執(zhí)行SQL語(yǔ)句。邏輯STANDBY除災(zāi)難恢復(fù)外還有其它用途，比如用于用戶進(jìn)行查詢和報(bào)表。
安裝環(huán)境
在主庫(kù)--primary上搭建數(shù)據(jù)庫(kù)軟件，建立監(jiān)聽，采用dbca搭建實(shí)例；
在備庫(kù)--standby上搭建數(shù)據(jù)庫(kù)軟件，建立監(jiān)聽，但是不需要建立實(shí)例。
在linux上搭建oracle數(shù)據(jù)庫(kù)，過(guò)程略。
步驟概述：
1. 主庫(kù)開啟歸檔并設(shè)置快速恢復(fù)區(qū)；
2. 主庫(kù)創(chuàng)建歸檔同步目錄；
3. 主庫(kù)添加STANDBY日志文件；
4. 主備皆配置網(wǎng)絡(luò)---監(jiān)聽配置文件；
5. 將主庫(kù)的密碼文件傳輸?shù)絺鋷?kù)；
6. 修改主庫(kù)的參數(shù)文件傳輸?shù)絺鋷?kù)，需修改部分信息；
7. 以動(dòng)態(tài)參數(shù)文件的形式啟動(dòng)備庫(kù)數(shù)據(jù)庫(kù)；
8. 主庫(kù)登錄RMAN，【duplicate】復(fù)制數(shù)據(jù)庫(kù)；
一、 主備庫(kù)配置
1.創(chuàng)建歸檔同步目錄
[oracle@test1 ~]$ mkdir -p /home/oracle/flash [oracle@test2 ~]$ mkdir -p /home/oracle/flash
2.開啟歸檔并設(shè)置快速恢復(fù)區(qū)
SYS@PROD1 > alter system set db_recovery_file_dest='/home/oracle/flash'; alter system set db_recovery_file_dest_size=4G; alter database archivelog;
3.主庫(kù)添加STANDBY日志文件
alter database add standby logfile group 4 '/home/oracle/s1.log' size 50M; alter database add standby logfile group 5 '/home/oracle/s2.log' size 50M; alter database add standby logfile group 6 '/home/oracle/s3.log' size 50M; alter database add standby logfile group 7 '/home/oracle/s4.log' size 50M;
4.主備庫(kù)修改監(jiān)聽配置文件
[oracle@test1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/network/admin/
[oracle@test1 admin]$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test1.us.oracle.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = /u01/app/oracle SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=PROD1) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1) (SID_NAME=PROD1)) )
[oracle@test1 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. PROD1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test1.us.oracle.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PROD1) ) ) PROD1_S = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test2.us.oracle.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PROD1) ) )
啟動(dòng)監(jiān)聽，并測(cè)試服務(wù)名網(wǎng)絡(luò)的通暢。兩臺(tái)主機(jī)均需測(cè)試兩個(gè)服務(wù)名（此省略主庫(kù)的測(cè)試）：
[oracle@test1 admin]$ lsnrctl start [oracle@test2 admin]$ lsnrctl start
[oracle@test2 admin]$ tnsping prod1 TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 25-FEB-2019 11:46:06 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test1.us.oracle.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PROD1))) OK (0 msec) [oracle@test2 admin]$ tnsping prod1_s TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 25-FEB-2019 11:47:04 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test2.us.oracle.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PROD1))) OK (0 msec)
5.傳輸密碼文件：
[oracle@test1 dbs]$ cd $ORACLE_HOME/dbs [oracle@test1 dbs]$ ls hc_PROD1.dat init.ora lkPROD1 orapwPROD1 spfilePROD1.ora [oracle@test1 dbs]$ scp orapwPROD1 test2:/u01/app/oracle/product/11.2.0/dbhome_1/dbs oracle@test2's password: orapwPROD1 100% 1536 1.5KB/s 00:00
6.修改參數(shù)文件配置：
[oracle@test1 dbs]$ ls hc_PROD1.dat init.ora initPROD1.ora lkPROD1 orapwPROD1 spfilePROD1.ora [oracle@test1 dbs]$ cat initPROD1.ora PROD1.__db_cache_size=260046848 PROD1.__java_pool_size=4194304 PROD1.__large_pool_size=8388608 PROD1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment PROD1.__pga_aggregate_target=398458880 PROD1.__sga_target=390070272 PROD1.__shared_io_pool_size=0 PROD1.__shared_pool_size=104857600 PROD1.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/PROD1/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/u01/app/oracle/oradata/PROD1/control01.ctl','/u01/app/oracle/fast_recovery_area/PROD1/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='PROD1' *.db_recovery_file_dest='/home/oracle/flash' *.db_recovery_file_dest_size=4294967296 *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=PROD1XDB)' *.memory_target=786432000 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1' DB_UNIQUE_NAME=PROD1 LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD1,LEILEI)' LOG_ARCHIVE_DEST_1= 'LOCATION=/home/oracle/flash VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD1' LOG_ARCHIVE_DEST_2= 'SERVICE=PROD1_S ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=LEILEI' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc LOG_ARCHIVE_MAX_PROCESSES=30 FAL_SERVER=PROD1 STANDBY_FILE_MANAGEMENT=AUTO
傳輸靜態(tài)參數(shù)文件到備庫(kù)：
[oracle@test1 dbs]$ scp initPROD1.ora test2:/u01/app/oracle/product/11.2.0/dbhome_1/dbs oracle@test2's password: initPROD1.ora 100% 1399 1.4KB/s 00:00
在備庫(kù)上修改靜態(tài)參數(shù)文件：
[oracle@test2 dbs]$ cat initPROD1.ora *.control_files='/u01/app/oracle/oradata/PROD1/control01.ctl','/u01/app/oracle/fast_recovery_area/PROD1/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='PROD1' *.db_recovery_file_dest='/home/oracle/flash' *.db_recovery_file_dest_size=4294967296 *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=PROD1XDB)' *.memory_target=786432000 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1' DB_UNIQUE_NAME=LEILEI LOG_ARCHIVE_CONFIG='DG_CONFIG=(LEILEI,PROD1)' LOG_ARCHIVE_DEST_1= 'LOCATION=/home/oracle/flash VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=LEILEI' LOG_ARCHIVE_DEST_2= 'SERVICE=PROD1 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PROD1' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc LOG_ARCHIVE_MAX_PROCESSES=30 FAL_SERVER=PROD1 STANDBY_FILE_MANAGEMENT=AUTO
7.在備庫(kù)上，創(chuàng)建靜態(tài)參數(shù)文件中對(duì)應(yīng)的目錄文件夾
[oracle@test2 dbs]$ mkdir -p /home/oracle/flash mkdir -p /u01/app/oracle/admin/PROD1/adump mkdir -p /u01/app/oracle/oradata/PROD1 mkdir -p /u01/app/oracle/fast_recovery_area/PROD1
8.啟動(dòng)備庫(kù)到【nomount】階段；
[oracle@test2 ~]$ export ORACLE_SID=PROD1 [oracle@test2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 25 13:59:23 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SYS@PROD1 >startup nomount; ORACLE instance started. Total System Global Area 1219260416 bytes Fixed Size 2252744 bytes Variable Size 788529208 bytes Database Buffers 419430400 bytes Redo Buffers 9048064 bytes
9.主庫(kù)登錄RMAN，復(fù)制數(shù)據(jù)庫(kù)；
[oracle@test1 ~]$ rman target sys/oracle@prod1 auxiliary sys/oracle@prod1_s
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Feb 25 13:43:23 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD1 (DBID=2222506242)
connected to auxiliary database: PROD1 (not mounted)
RMAN> duplicate target database for standby from active database nofilenamecheck;
Starting Duplicate Db at 2019-02-25 13:43:31
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwPROD1' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD1' ;
}
executing Memory Script
Starting backup at 2019-02-25 13:43:32
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=17 device type=DISK
Finished backup at 2019-02-25 13:43:33
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/PROD1/control01.ctl';
restore clone controlfile to '/u01/app/oracle/fast_recovery_area/PROD1/control02.ctl' from
'/u01/app/oracle/oradata/PROD1/control01.ctl';
}
executing Memory Script
Starting backup at 2019-02-25 13:43:33
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_PROD1.f tag=TAG20190225T134333 RECID=2 STAMP=1001166214
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 2019-02-25 13:43:36
Starting restore at 2019-02-25 13:43:36
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 2019-02-25 13:43:37
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/PROD1/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/PROD1/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/PROD1/sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/PROD1/undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/PROD1/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/PROD1/example01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/PROD1/system01.dbf" datafile
2 auxiliary format
"/u01/app/oracle/oradata/PROD1/sysaux01.dbf" datafile
3 auxiliary format
"/u01/app/oracle/oradata/PROD1/undotbs01.dbf" datafile
4 auxiliary format
"/u01/app/oracle/oradata/PROD1/users01.dbf" datafile
5 auxiliary format
"/u01/app/oracle/oradata/PROD1/example01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/PROD1/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 2019-02-25 13:43:43
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf
output file name=/u01/app/oracle/oradata/PROD1/system01.dbf tag=TAG20190225T134343
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD1/sysaux01.dbf
output file name=/u01/app/oracle/oradata/PROD1/sysaux01.dbf tag=TAG20190225T134343
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/PROD1/example01.dbf
output file name=/u01/app/oracle/oradata/PROD1/example01.dbf tag=TAG20190225T134343
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD1/undotbs01.dbf
output file name=/u01/app/oracle/oradata/PROD1/undotbs01.dbf tag=TAG20190225T134343
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/PROD1/users01.dbf
output file name=/u01/app/oracle/oradata/PROD1/users01.dbf tag=TAG20190225T134343
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2019-02-25 13:45:16
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=1001167339 file name=/u01/app/oracle/oradata/PROD1/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=1001167339 file name=/u01/app/oracle/oradata/PROD1/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=1001167339 file name=/u01/app/oracle/oradata/PROD1/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=1001167339 file name=/u01/app/oracle/oradata/PROD1/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=6 STAMP=1001167339 file name=/u01/app/oracle/oradata/PROD1/example01.dbf
Finished Duplicate Db at 2019-02-25 13:45:32二、 檢查主備搭建情況
1. 主庫(kù)
[oracle@test1 ~]$ export ORACLE_SID=PROD1 [oracle@test1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 25 13:46:56 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS@PROD1 >select open_mode,database_role,switchover_status from v$database; OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS ---------------------------------------- -------------------------------- ---------------------------------------- READ WRITE PRIMARY SESSIONS ACTIVE SYS@PROD1 >select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- ------------------- ------------ ------------------- 1 1 16 52428800 512 1 NO CURRENT 996478 2019-02-25 14:19:03 2.8147E+14 2 1 14 52428800 512 1 YES INACTIVE 996073 2019-02-25 14:12:33 996161 2019-02-25 14:13:55 3 1 15 52428800 512 1 YES ACTIVE 996161 2019-02-25 14:13:55 996478 2019-02-25 14:19:03
2. 備庫(kù)
[oracle@test2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 25 14:04:36 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS@PROD1 >select open_mode,database_role,switchover_status from v$database; OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS ---------------------------------------- -------------------------------- ---------------------------------------- MOUNTED PHYSICAL STANDBY RECOVERY NEEDED 備庫(kù)處于MOUNTED模式下，只能開啟實(shí)時(shí)應(yīng)用在線日志或者歸檔日志。 SYS@PROD1 >select PROCESS,STATUS,SEQUENCE# from v$managed_standby; PROCESS STATUS SEQUENCE# ------------------ ---------------------- ----------------- ARCH CLOSING 15 ARCH CONNECTED 0 ...... ARCH CONNECTED 0 ARCH CONNECTED 0 ARCH CONNECTED 0 RFS IDLE 0 RFS IDLE 0 RFS IDLE 16 33 rows selected. SYS@PROD1 >alter database open; Database altered. SYS@PROD1 >select open_mode,database_role,switchover_status from v$database; OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS ------------- ----------------- ------------------- READ ONLY PHYSICAL STANDBY NOT ALLOWED
三、 測(cè)試主備功能及切換應(yīng)用
? 測(cè)試1
? 測(cè)試1 Test1： SYS@PROD1 >create table t1 (id number); Table created. Test2： SYS@PROD1 >desc t1 ERROR: ORA-04043: object t1 does not exist SYS@PROD1 >recover managed standby database disconnect; Media recovery complete. SYS@PROD1 >desc t1 ERROR: ORA-04043: object t1 does not exist Test1： SYS@PROD1 >alter system switch logfile; System altered. Test2： SYS@PROD1 >desc t1 Name Null? Type ---------------------------------------- ID NUMBER
? 測(cè)試2
11G新特性：ADG
Test2： SYS@PROD1 >recover managed standby database cancel; Media recovery complete. SYS@PROD1 >recover managed standby database using current logfile disconnect from session; Media recovery complete. Test1： SYS@PROD1 >create table t2 (id number); Table created. Test2： SYS@PROD1 >desc t2 Name Null? Type ----------------------------------- ID NUMBER
? 測(cè)試3
以下為Data Guard最為重要的兩個(gè)功能：
參考博客：http://www.cnblogs.com/hllnj2008/p/4995099.html
角色切換
TEST1: SYS@PROD1 >select open_mode,database_role,switchover_status from v$database; OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS ---------------------------------------- -------------------------------- ---------------------------------------- READ WRITE PRIMARY TO STANDBY SYS@PROD1 >alter database commit to switchover to physical standby; Database altered. SYS@PROD1 >conn / as sysdba; Connected to an idle instance. SYS@PROD1 >startup ORACLE instance started. Total System Global Area 1219260416 bytes Fixed Size 2252744 bytes Variable Size 788529208 bytes Database Buffers 419430400 bytes Redo Buffers 9048064 bytes Database mounted. Database opened. SYS@PROD1 >select open_mode,database_role,switchover_status from v$database; OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS ---------------------------------------- -------------------------------- ---------------------------------------- READ ONLY PHYSICAL STANDBY TO PRIMARY TEST2: SYS@PROD1 >recover managed standby database cancel; Media recovery complete. SYS@PROD1 >select open_mode,database_role,switchover_status from v$database; OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS ---------------------------------------- -------------------------------- ---------------------------------------- READ ONLY PHYSICAL STANDBY TO PRIMARY SYS@PROD1 >alter database commit to switchover to primary; Database altered. SYS@PROD1 >select open_mode,database_role,switchover_status from v$database; OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS ---------------------------------------- -------------------------------- ---------------------------------------- MOUNTED PRIMARY NOT ALLOWED SYS@PROD1 >alter database open; Database altered. SYS@PROD1 >insert into t1 values (1); 1 row created. SYS@PROD1 >commit; Commit complete. SYS@PROD1 >select * from t1; ID ---------- 1 TEST1: SYS@PROD1 >select * from t1; no rows selected SYS@PROD1 >recover managed standby database using current logfile disconnect from session; Media recovery complete. SYS@PROD1 >select * from t1; ID ---------- 1
到此，關(guān)于“Oracle Data Guard部署分析”的學(xué)習(xí)就結(jié)束了，希望能夠解決大家的疑惑。理論與實(shí)踐的搭配能更好的幫助大家學(xué)習(xí)，快去試試吧！若想繼續(xù)學(xué)習(xí)更多相關(guān)知識(shí)，請(qǐng)繼續(xù)關(guān)注創(chuàng)新互聯(lián)網(wǎng)站，小編會(huì)繼續(xù)努力為大家?guī)?lái)更多實(shí)用的文章！
名稱欄目：OracleDataGuard部署分析
網(wǎng)頁(yè)路徑：http://muchs.cn/article36/jpiepg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供響應(yīng)式網(wǎng)站、移動(dòng)網(wǎng)站建設(shè)、自適應(yīng)網(wǎng)站、動(dòng)態(tài)網(wǎng)站、、網(wǎng)站策劃
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
移動(dòng)網(wǎng)站建設(shè)知識(shí)
- 移動(dòng)網(wǎng)站建設(shè)的好處 2016-11-08
- 移動(dòng)網(wǎng)站建設(shè)需要注意什么 2021-09-14
- 手機(jī)端移動(dòng)網(wǎng)站建設(shè)需要注意哪些問(wèn)題呢？ 2013-12-19
- 深圳移動(dòng)網(wǎng)站建設(shè)需要注意什么？ 2021-06-10
- 移動(dòng)網(wǎng)站建設(shè)支付頁(yè)面設(shè)計(jì)：給用戶一個(gè)熟悉的味道 2023-03-05
- 如何才能做好企業(yè)的移動(dòng)網(wǎng)站建設(shè) 2016-11-07
- 移動(dòng)網(wǎng)站建設(shè)必備的基本常識(shí) 2016-11-16
- 你知道移動(dòng)網(wǎng)站建設(shè)如何做嗎？ 2021-10-09
- 成都移動(dòng)網(wǎng)站建設(shè)注意事項(xiàng)有哪些? 2020-08-18
- 移動(dòng)網(wǎng)站建設(shè)需要注意哪些事項(xiàng)？ 2022-12-01
- 淺析移動(dòng)網(wǎng)站建設(shè)的發(fā)展趨勢(shì) 2023-03-27
- 移動(dòng)網(wǎng)站建設(shè)需要多少錢？ 2021-12-07