Oracle 11g跨平台DataGuard Windows to Linux

章芋文

1074

12页

66次

2019-11-04

免费下载

Oracle 11g Cross platform Active Standby - Windows Primary database and Linux Active

Standby

 !

"

# !"#$%&$'$(%)

!!"

The environment used is as follows:

Primary

Windows 7 64 bit

11g Release 2

DB_UNIQUE_NAME=orcl

Active Standby

Oracle Enterprise Linux 5.7 64 bit

11g Release 2

DB_UNIUE_NAME=orcl_dr

 !"

(SID_DESC =

(GLOBAL_DBNAME =orcl_dr)

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

(SID_NAME =orcl_dr)

)

 

 "

ORCL_DR=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = linux01.gavinsoorma.com)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl_dr)

)

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = gavin-pc)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

 $%!

 $!&&

 $!

'($)*'+'$,"',-./0//&.

 $!&&&%./0//&//.

 $"1'$,2&3'2/!

4"5&26&

 78''7!

 "

&&&&&&"

DUPLICATE TARGET DATABASE

FOR STANDBY

FROM ACTIVE DATABASE

NOFILENAMECHECK

DORECOVER

SPFILE

SET DB_UNIQUE_NAME="orcl_dr"

SET AUDIT_FILE_DEST="/u02/app/oracle/admin/orcl_dr/adump"

SET DIAGNOSTIC_DEST="/u02/app/oracle"

SET LOG_ARCHIVE_DEST_2="service=orcl_dr LGWR SYNC REGISTER VALID_FOR=(online_logfile,primary_role)"

SET FAL_SERVER="orcl_dr"

SET FAL_CLIENT="orcl"

SET CONTROL_FILES='/u01/oradata/orcl_dr/control01.ctl','/u01/oradata/orcl_dr/control02.ctl','/u01/oradata/orcl_dr/control03.ctl'

SET DB_FILE_NAME_CONVERT='C:\ORADATA\ORCL\','/u01/oradata/orcl_dr/'

SET LOG_FILE_NAME_CONVERT='C:\ORADATA\ORCL\','/u01/oradata/orcl_dr/';

%#9:,';&$39<2&2 &,';&$39<2&='

!#)

/0>////">"0/&//)$000000000?&0@A?BC>B?"000

 =8!

)****">"0*&>*59D*%%*%%+,

of 12

免费下载

相关文档

评论