Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to build Oracle DG", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to build Oracle DG" this article.

Oracle DG build (duplicate mode)

(1) main library: enable archiving mode

(2) main database: enable the mandatory log writing feature

(3) main library: turn off flashback

(4) main library: configure static monitoring, configure tnsnames file

(5) main library: add standby logfile files

(6) main library: modify parameter file

(7) Master library: copy the master library file to the standby database

(8) slave library: configure static monitoring, configure tnsnames.ora file

(9) Reserve library: modify parameter file and password file

(10) standby library: create the corresponding directory according to the parameter file

(11) Reserve library: startup nomount

(12) Master database: restore the backup database by rman duplicate

(13) verify whether the construction is successful.

(14) Master-Slave switching

(1) main library: enable archiving mode

SQL > shutdown immediate

SQL > startup mount

SQL > alter database archivelog

SQL > alter database open

SQL > alter system set db_recovery_file_dest_size=10G

SQL > alter system set db_recovery_file_dest='/home/oracle/flash'

(2) main database: enable the mandatory log writing feature

SQL > select force_logging from v$database

SQL > alter database force logging

(3) main library: turn off flashback

SQL > select flashback_on from v$database

SQL > alter database flashback off

(4) main library: configure static monitoring, configure tnsnames file

[oracle@chen ~] $cd $ORACLE_HOME/network/admin

[oracle@chen admin] $vi listener.ora

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(GLOBAL_DBNAME=chicago.us.oracle.com)

(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

(SID_NAME=chicago)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = chen.example.com) (PORT = 1521))

)

)

[oracle@chen admin] $vi tnsnames.ora

Chicago =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = chen.example.com) (PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = chicago.us.oracle.com)

)

)

Boston =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = jch.example.com) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = boston.us.oracle.com)

)

)

[oracle@chen admin] $lsnrctl stop

[oracle@chen admin] $lsnrctl start

(5) main library: add standby logfile files

SQL > select member from v$logfile

SQL > select bytes/1024/1024 from v$log

SQL > alter database add standby logfile group 4'/ u01 size size 50m

SQL > alter database add standby logfile group 5'/ u01 size size 50m

SQL > alter database add standby logfile group 6'/ u01 size size 50m

SQL > alter database add standby logfile group 7'/ u01 size size 50m

(6) main library: modify parameter file

Https://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ps.htm#SBYDB00426

Example 3-1 Primary Database: Primary Role Initialization Parameters

Example 3-2 Primary Database: Standby Role Initialization Parameters

SQL > create pfile from spfile

[oracle@chen admin] $cd $ORACLE_HOME/dbs

[oracle@chen dbs] $vi initchicago.ora

* .DB_NAME=chicago

* .DB_UNIQUE_NAME=chicago

* .LOG_ARCHIVE_CONFIG='DG_CONFIG= (chicago,boston)'

* .LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/flash VALID_FOR= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago'

* .LOG_ARCHIVE_DEST_2='SERVICE=boston ASYNC VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'

* .LOG_ARCHIVE_DEST_STATE_1=ENABLE

* .LOG_ARCHIVE_DEST_STATE_2=ENABLE

* .REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

* .LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

* .FAL_SERVER=boston

* .DB_FILE_NAME_CONVERT='boston','chicago'

* .LOG_FILE_NAME_CONVERT='boston','chicago'

* .STANDBY_FILE_MANAGEMENT=AUTO

[oracle@chen dbs] $cp spfilechicago.ora spfilechicago.ora.bak

SQL > shutdown immediate

SQL > create spfile from pfile

SQL > startup

SQL > show parameter log_archive_dest_2

(7) Master library: copy the master library file to the standby database

Monitor files, TNS files, parameter files, password files to the standby library and rename them

[oracle@chen dbs] $mkdir / home/oracle/dg

[oracle@chen dbs] $cp initchicago.ora / home/oracle/dg/

[oracle@chen dbs] $cp orapwchicago / home/oracle/dg/

[oracle@chen admin] $cp listener.ora / home/oracle/dg/

[oracle@chen admin] $cp tnsnames.ora / home/oracle/dg/

[oracle@chen ~] $tar-zcvf dg.tar.gz dg/

[oracle@chen ~] $scp dg.tar.gz jch:/home/oracle

(8) slave library: configure static monitoring, configure tnsnames.ora file

[oracle@jch ~] $tar-zxvf dg.tar.gz

[oracle@jch ~] $cd $ORACLE_HOME/network/admin

[oracle@jch admin] $mv listener.ora listener.ora.bak

[oracle@jch admin] $mv tnsnames.ora tnsnames.ora.bak

[oracle@jch admin] $cp / home/oracle/dg/listener.ora.

[oracle@jch admin] $cp / home/oracle/dg/tnsnames.ora.

[oracle@jch admin] $vi listener.ora

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(GLOBAL_DBNAME=boston.us.oracle.com)

(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)

(SID_NAME=boston)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = jch.example.com) (PORT = 1521))

)

)

[oracle@jch admin] $lsnrctl start

(9) Reserve library: modify parameter file and password file

[oracle@jch dbs] $cp / home/oracle/dg/initchicago.ora.

[oracle@jch dbs] $cp / home/oracle/dg/orapwchicago.

[oracle@jch dbs] $mv orapwchicago orapwboston

[oracle@jch dbs] $mv initchicago.ora initboston.ora

[oracle@jch dbs] $vi initboston.ora

:% s/chicago/AAAA/g

:% s/boston/chicago/g

:% s/AAAA/boston/g

* .DB_NAME=chicago

* .DB_UNIQUE_NAME=boston

* .LOG_ARCHIVE_CONFIG='DG_CONFIG= (boston,chicago)'

* .LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/flash VALID_FOR= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=boston'

* .LOG_ARCHIVE_DEST_2='SERVICE=chicago ASYNC VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=chicago'

* .LOG_ARCHIVE_DEST_STATE_1=ENABLE

* .LOG_ARCHIVE_DEST_STATE_2=ENABLE

* .REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

* .LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

* .FAL_SERVER=chicago

* .DB_FILE_NAME_CONVERT='chicago','boston'

* .LOG_FILE_NAME_CONVERT='chicago','boston'

* .STANDBY_FILE_MANAGEMENT=AUTO

(10) standby library: create the corresponding directory according to the parameter file

[oracle@jch ~] $mkdir flash

[oracle@jch ~] $cd / u01/app/oracle/admin/

[oracle@jch admin] $mkdir boston/adump-p

[oracle@jch ~] $mkdir / u01/app/oracle/oradata/boston

(11) Reserve library: startup nomount

[oracle@jch ~] $export ORACLE_SID=boston

[oracle@jch ~] $sqlplus / as sysdba

SQL > create spfile from pfile

SQL > startup nomount

(12) Master database: restore the backup database by rman duplicate

[oracle@chen ~] $export ORACLE_SID=chicago

[oracle@chen ~] $rman target / auxiliary sys/oracle@boston

RMAN > duplicate target database for standby from active database

(13) verify whether the construction is successful.

Main library:

SQL > archive log list

SQL > alter system switch logfile

Prepare the library:

SQL > archive log list

SQL > select process, pid, status, client_process from v$managed_standby

SQL > SELECT PROTECTION_MODE, PROTECTION_LEVEL,DATABASE_ROLE ROLE,SWITCHOVER_STATUS FROM V$DATABASE

Standby library: sync data

SQL > alter database open

SQL > recover managed standby database using current logfile disconnect from session

-SQL > recover managed standby database cancel

Main library:

SQL > create table test1 as select level as id from dual connect by level select * from test1

(14) Master-Slave switching

Https://docs.oracle.com/cd/E11882_01/server.112/e41134/role_management.htm#SBYDB00625

Main library:

SQL > SELECT SWITCHOVER_STATUS FROM V$DATABASE

SQL > ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN

SQL > SHUTDOWN ABORT

SQL > STARTUP MOUNT

Prepare the library:

SQL > SELECT SWITCHOVER_STATUS FROM V$DATABASE

SQL > ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN

SQL > ALTER DATABASE OPEN

-SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

When the master database fails, the return for master-slave switching in the above way is as follows:

Database not available for switchover

End-Of-REDO archived log file has not been recovered

Archived log files detected beyond End-Of-REDO

Incomplete recovery SCN:0:1038219 archive SCN:0:1037990

Solution:

SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH

-ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE

SQL > ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN

SQL > ALTER DATABASE OPEN

These are all the contents of the article "how to build Oracle DG". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.