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

Customers are required to build a set of test libraries. The current environment is oracle RAC under window. It is best to use import and export, but it is currently in archive mode. It is too risky to use import and export, and there is not enough space on the backup server using RMAN. Well, the best way is the RMAN duplicate method. Test it in a stand-alone environment first!

The RMAN duplicate of Oracle 11g can be realized by Activedatabase duplicate and Backup-based duplicate. This case uses Active databaseduplicate, for Active databaseduplicate, there is no need for Source backup when cloning the database, which has obvious advantages for big data, especially for T-level databases. There is no need for backup before replication, which reduces the time for backup and transfer backup, and saves backup space at the same time.

This test replicates the PROD2 database to another server, named PROD5

View source library information

The source library must be in archive mode and enable the quick recovery area; confirm the data file and log file path!

[oracle@orar2p1 ~] $sqlplus / as sysdba

SQL*Plus:Release 11.2.0.3.0 Production on Tue Sep 5 14:56:01 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database11g Enterprise Edition Release 11.2.0.3.0-Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SYS@PROD2 > selectstatus from v$instance

STATUS

-

OPEN

SYS@PROD2 > selectname from v$datafile

NAME

/ u01/app/oracle/oradata/PROD2/system01.dbf

/ u01/app/oracle/oradata/PROD2/sysaux01.dbf

/ u01/app/oracle/oradata/PROD2/undotbs01.dbf

/ u01/app/oracle/oradata/PROD2/users01.dbf

/ u01/app/oracle/oradata/PROD2/example01.dbf

SYS@PROD2 > selectmember from v$logfile

MEMBER

/ u01/app/oracle/oradata/PROD2/redo03.log

/ u01/app/oracle/oradata/PROD2/redo02.log

/ u01/app/oracle/oradata/PROD2/redo01.log

SYS@PROD2 > showparameter name

NAME TYPE VALUE

-

Db_file_name_convert string

Db_name string PROD2

Db_unique_name string PROD2

Global_names boolean FALSE

Instance_name string PROD2

Lock_name_space string

Log_file_name_convert string

Processor_group_name string

Service_names string PROD2.us.oracle.com

Build the test library PROD5:

1) generate test library pfile

You can copy the pfile of the source library, replace the name, or regenerate the pfile, which is regenerated below!

[oracle@orar2p2dbs] $cat init.ora | grep-v ^ # | grep-v ^ $> initPROD5.ora

[oracle@orar2p2dbs] $vi initPROD5.ora

Db_name='PROD5'

Memory_target=1G

Processes = 150

Audit_file_dest='$ORACLE_BASE/admin/PROD5/adump'

Audit_trail='db'

Db_block_size=8192

Db_domain='us.oracle.com'

Db_recovery_file_dest='$ORACLE_BASE/fast_recovery_area'

Db_recovery_file_dest_size=2G

Diagnostic_dest='$ORACLE_BASE'

Dispatchers=' (PROTOCOL=TCP) (SERVICE=PROD5XDB)'

Open_cursors=300

Remote_login_passwordfile='EXCLUSIVE'

Undo_tablespace='UNDOTBS1' must be the same as the source library name here!

Control_files ='/ u01AccordingoradataPlacement PROD5OnoraActioncontrol01.ctlAccording to the repercussions of oracleplains fastening oracleplicasareaplains PROD5andoracontrol02.ctl'

Compatible='11.2.0'

Db_file_name_convert='/u01/app/oracle/oradata/PROD2/','/u01/app/oracle/oradata/PROD5/'

Log_file_name_convert='/u01/app/oracle/oradata/PROD2/','/u01/app/oracle/oradata/PROD5/','/u01/app/oracle/fast_recovery_area/PROD2/onlinelog/','/u01/app/oracle/fast_recovery_area/PROD5/' (the correspondence of the log file must be confirmed, otherwise an error will be reported)

2) create a test library related directory (create a related directory based on pfile information)

[oracle@orar2p2oradata] $mkdir PROD5

[oracle@orar2p2oradata] $cd.. / admin

[oracle@orar2p2admin] $mkdir-p PROD5/adump

3) to generate a password file, you can directly copy or regenerate the password file of the source library, but the passwords on both sides must be the same!

Oracle@orar2p2dbs] $orapwd file=orapwPROD5 password=oracle entries=30

Transfer parameter file scp initPROD2.ora oracle@192.0.2.12:/u01/app/oracle/product/11.2.0/db_1/dbs

Transfer password file scp orapwPROD2 oracle@192.0.2.12:/u01/app/oracle/product/11.2.0/db_1/dbs/orapwPROD5

The test library starts to nomout state

[oracle@orar2p2admin] $export ORACLE_SID=PROD5

[oracle@orar2p2admin] $sqlplus / as sysdba

SQL*Plus:Release 11.2.0.3.0 Production on Tue Sep 5 08:35:48 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to anidle instance.

SYS@PROD5 > startupnomount

Configure snooping

Both sides should configure the snooping and tnsname.ora of the source and target libraries.

Source database static listening information

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(GLOBAL_DBNAME=PROD2.us.oracle.com)

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

(SID_NAME=PROD2))

)

Source database tnsnames.ora configuration information

PROD2 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PROD2.us.oracle.com)

)

)

PROD5 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PROD5.us.oracle.com)

)

)

Target library static listening information

SID_LIST_LISTENER=

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = PROD5.us.oracle.com)

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

(SID_NAME = PROD5)

)

)

Target library tnsnames.ora configuration information

PROD2 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PROD2.us.oracle.com)

)

)

PROD5 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PROD5.us.oracle.com)

)

)

Start rman in the source database PROD2 to copy the database

Start database replication

[oracle@orar2p2admin] $rman target sys/oracle@prod2 auxiliary sys/oracle@prod5

RecoveryManager: Release 11.2.0.3.0-Production on Tue Sep 5 08:26:17 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected totarget database: PROD2 (DBID=1512727797)

Connected toauxiliary database: PROD5 (not mounted)

RMAN > duplicate target database to prod5 from active database nofilenamecheck

Duplicate targetdatabase to prod from active database nofilenamecheck

-- if the path of the master / slave library file remains the same, add nofilenamecheck (otherwise an error will be reported)

Verify Clone

[oracle@orar2p2admin] $sql

SQL*Plus:Release 11.2.0.3.0 Production on Tue Sep 5 08:41:35 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database11g Enterprise Edition Release 11.2.0.3.0-Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SYS@PROD5 > selectstatus from v$instance

STATUS

-

OPEN

SYS@PROD5 > selectname from v$datafile

NAME

/ u01/app/oracle/oradata/PROD5/system01.dbf

/ u01/app/oracle/oradata/PROD5/sysaux01.dbf

/ u01/app/oracle/oradata/PROD5/undotbs01.dbf

/ u01/app/oracle/oradata/PROD5/users01.dbf

/ u01/app/oracle/oradata/PROD5/example01.dbf

SYS@PROD5 > selectmember from v$logfile

MEMBER

/ u01/app/oracle/oradata/PROD5/redo03.log

/ u01/app/oracle/oradata/PROD5/redo02.log

/ u01/app/oracle/oradata/PROD5/redo01.log

SYS@PROD5 > showparameter control

NAME TYPE VALUE

-

_ optimizer_extended_stats_usage_continteger 192

Rol

_ optimizer_join_order_control integer 3

Control_file_record_keep_time integer 7

Control_files string / u01/app/oracle/oradata/PROD5/

Ora_control01.ctl,/u01/app/or

Acle/fast_recovery_area/PROD5/

Ora_control02.ctl

Control_management_pack_access string DIAGNOSTIC+TUNING

SYS@PROD5 >

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.