Shulou(Shulou.com)06/01 Report--

The OA library in the formal environment needs to be migrated from Windows to Linux, but because the amount of data is relatively large, the bandwidth is relatively narrow, and the data pump takes too long, it is intended to be migrated by DataGuard, so it is tested.

Environment

Main library: OS:Windows VERSION:11.2.0.4 ORACLE_SID:OA DB_NAME:OA DB_UNIQUE_NAME:OA

Standby library: OS:Windows VERSION:11.2.0.4 ORACLE_SID:OA DB_NAME:OA DB_UNIQUE_NAME:OA_DG

Cascading library: OS:Linux VERSION:11.2.0.4 ORACLE_SID:OA DB_NAME:OA DB_UNIQUE_NAME:OA_DG2

1. View the information of each library platform

SQL > select platform_id,platform_name from v$database

The main library is the same as the standby library:

PLATFORM_ID PLATFORM_NAME

12 Microsoft Windows x86 64-bit

Cascading libraries:

PLATFORM_ID PLATFORM_NAME

13 Linux x86 64-bit

Looking at the compatibility table, you can see that the current platform and Oracle version can build DataGuard across platforms, but you need to type Patch 13104881 (the current version has been typed)

two。 The standby library generates pfile, and transfers the pfile and password files to the OA_DG2-related directory

3. Modify pfile on cascading library

[oracle@node3 dbs] $more initOA.ora

*。 Audit_file_dest ='/ opt/app/oracle/admin/OA/adump'

* .audit_trail='DB'

* .compatible='11.2.0.0.0'

*。 Control_files ='/ opt/app/oracle/oradata/OA/CONTROL01.CTL','/opt/app/oracle/fast_recovery_area/OA/CONTROL02.CTL'

* .db_block_size=8192

* .db_name='OA'

* .db_recovery_file_dest_size=4102029312

*。 Db_recovery_file_dest ='/ opt/app/oracle/fast_recovery_area'

*。 Db_unique_name = 'OA_DG2'

*。 Diagnostic_dest ='/ opt/app/oracle'

* .dispatchers=' (PROTOCOL=TCP) (SERVICE=OAXDB)'

*。 Fal_client = 'OA_DG2'

*。 Fal_server = 'OA_DG'

*。 Db_file_name_convert ='C:\ APP\ ADMINISTRATOR\ ORADATA\ OA\,'/ opt/app/oracle/oradata/OA/','C:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ OA\,'/ opt/app/oracle/fast_recovery_area/OA/'

*。 Log_file_name_convert ='C:\ APP\ ADMINISTRATOR\ ORADATA\ OA\','/ opt/app/oracle/oradata/OA/'

*。 Log_archive_config = 'dg_config= (OA,OA_DG,OA_DG2)'

* .log_archive_dest_1='location=/opt/app/oracle/archivelog valid_for= (all_logfiles,all_roles)

* .log_archive_format='ARC%S_%R.%T'

* .nls_language='SIMPLIFIED CHINESE'

* .nls_territory='CHINA'

* .open_cursors=300

* .pga_aggregate_target=428867584

* .processes=150

* .recyclebin='OFF'

* .remote_login_passwordfile='EXCLUSIVE'

* .sga_target=1291845632

* .standby_file_management='AUTO'

* .undo_tablespace='UNDOTBS1'

Modify the red font to adapt it to the current environment

4. Create the required directory on the cascading library

Cd $ORACLE_BASE

Mkdir-p oradata/OA/adump

Mkdir-p oradata/OA

Mkdir-p fast_recovery_area/OA

5. Add tns

To add the tns of a cascading library.

OA_DG2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 172.21.74.231) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = oa)

)

)

Cascading library add tns of standby library

OA_DG =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 172.21.74.233) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = oa)

)

)

6. Modify the parameters of the standby library to transfer standby logfile to the cascading library

SQL > alter system set log_archive_dest_state_3=defer;-temporarily closed

SQL > alter system set log_archive_config='dg_config= (OA,OA_DG,OA_DG2)'

SQL > alter system set log_archive_dest_3='service=OA_DG2 async valid_for= (STANDBY_LOGFILES,STANDBY_ROLE) db_unique_name=OA_DG2'

7. Cascading library configuration static snooping

[oracle@node3 admin] $more listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = 172.21.74.231) (PORT = 1521))

)

)

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME = OA)

(ORACLE_HOME = / opt/app/oracle/product/11g)

(GLOBAL_DBNAME = OA)

)

)

ADR_BASE_LISTENER = / opt/app/oracle

8. Use the replication feature of RMAN to create a standby library:

1) lsnrctl start

2) rman target sys@primary auxiliary sys@standby

3) duplicate target database for standby from active database

If you report an error RMAN-05001: auxiliary filename / opt/app/oracle/oradata/orcl/users01.dbf conflicts with a file used by the target database, execute duplicate target database for standby from active database nofilenamecheck

You can also replicate in parallel to improve performance. After you need to assign multiple channels to the main database and slave database, execute the copy command:

Run

{

Allocate channel chan1 type disk

Allocate channel chan2 type disk

Allocate channel chan3 type disk

Allocate channel chan4 type disk

Allocate auxiliary channel aux1 type disk

Allocate auxiliary channel aux2 type disk

Allocate auxiliary channel aux3 type disk

Allocate auxiliary channel aux4 type disk

Duplicate target database for standby from active database

}

9. After the copy is completed, verify whether the file paths in the cascading library are correct.

SQL > select file_name from dba_data_files

FILE_NAME

/ opt/app/oracle/oradata/OA/USERS01.DBF

/ opt/app/oracle/oradata/OA/UNDOTBS01.DBF

/ opt/app/oracle/oradata/OA/SYSAUX01.DBF

/ opt/app/oracle/oradata/OA/SYSTEM01.DBF

SQL > select group#,member from v$logfile

GROUP# TYPE MEMBER

-

3 ONLINE / opt/app/oracle/oradata/OA/REDO03.LOG

2 ONLINE / opt/app/oracle/oradata/OA/REDO02.LOG

1 ONLINE / opt/app/oracle/oradata/OA/REDO01.LOG

4 STANDBY C:\ APP\ ADMINISTRATOR\ ORADATA\ OA\ STANDBYREDO04.LOG

5 STANDBY C:\ APP\ ADMINISTRATOR\ ORADATA\ OA\ STANDBYREDO05.LOG

6 STANDBY C:\ APP\ ADMINISTRATOR\ ORADATA\ OA\ STANDBYREDO06.LOG

7 STANDBY C:\ APP\ ADMINISTRATOR\ ORADATA\ OA\ STANDBYREDO07.LOG

7 rows selected.

You can see that the directory of standby redo is incorrect (it seems that log_file_name_convert has no effect on standby log). At this point, you can manually delete the standby log group and add it again:

SQL > alter database drop standby logfile group 4

SQL > alter database drop standby logfile group 5

SQL > alter database drop standby logfile group 6

SQL > alter database drop standby logfile group 7

SQL > alter database add standby logfile group 4 ('/ opt/app/oracle/oradata/OA/STANDBYRD04.LOG') size 50m

SQL > alter database add standby logfile group 5 ('/ opt/app/oracle/oradata/OA/STANDBYRD05.LOG') size 50m

SQL > alter database add standby logfile group 6 ('/ opt/app/oracle/oradata/OA/STANDBYRD06.LOG') size 50m

SQL > alter database add standby logfile group 7 ('/ opt/app/oracle/oradata/OA/STANDBYRD07.LOG') size 50m

Open the transfer parameters of the slave library after verification

SQL > alter system set log_archive_dest_3_state=enable

Verify that the transmission is normal, and execute it in the cascading library

SQL > SELECT PROCESS

2 PID

3 STATUS

4 SEQUENCE#

5 DELAY_MINS

6 FROM V$MANAGED_STANDBY

PROCESS PID STATUS SEQUENCE# DELAY_MINS

ARCH 30382 CLOSING 158 0

ARCH 30384 CLOSING 154 0

ARCH 30386 CONNECTED 0 0

ARCH 30388 CLOSING 155 0

RFS 32195 IDLE 0 0

RFS 32193 IDLE 0 0

RFS 32191 IDLE 0 0

You can see that the RFS process has been established, indicating that there is no problem with the transmission. (if there is a problem with the transmission, you can deal with the alert log of the library, which should be the problem of the password file.)

10. Cascading library starts real-time application

Start the log application:

Alter database recover managed standby database disconnect

This command instructs the standby library to start using archive log files for recovery.

After the application of the archive log is completed, start the real-time application:

SQL > alter database recover managed standby database cancel

SQL > alter database open

SQL > alter database recover managed standby database using current logfile disconnect;-although the MRP process starts successfully after the statement is executed, it is verified that there is still no real real-time application log.

Verify real-time applications:

SQL > SELECT * FROM V$DATAGUARD_STATS

NAME VALUE UNIT TIME_COMPUTED DATUM_TIME

Transport lag + 00 00:05:22 day (2) to second (0) interval 11 *

Apply lag + 00 00:05:22 day (2) to second (0) interval 11 *

Apply finish time day (2) to second (3) interval 11 take 01 Universe 17:44:19 on 2018

Estimated startup time 11 second

Note: the cascading library of Oracle 11g does not support real-time applications and will not be applied until the source database logs are switched. The cascading library of Oracle 12c supports real-time applications.

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.