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

Configure the main library parameter file:

Add:

* .log_archive_config='DG_CONFIG= (CWFOL,CWFOLB)'

* .log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CWFOL'

* .log_archive_dest_2='SERVICE=CWFOLB LGWR SYNC AFFIRM VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CWFOLB'

Restart each node:

two。 Add standby log to the main library:

Alter database add standby logfile thread 1 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 1 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 1 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 1 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 1 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

3. Configure static snooping, main library and standby database, each node

4. The master database enables flashback and forced logs:

5. Generate a password file:

Orapwd file='$ORACLE_HOME/dbs/orapwCWFOL1' password=oracle entries=5 force=y ignorecase=y

Orapwd file='$ORACLE_HOME/dbs/orapwCWFOL2' password=oracle entries=5 force=y ignorecase=y

Orapwd file='$ORACLE_HOME/dbs/orapwCWFOLB' password=oracle entries=5 force=y ignorecase=y

Or after a node is generated, then copy it to another node and rename it.

6. To edit a file for the repository, you only need db_name:

[oracle@foldg dbs] $cat initCWFOLB.ora

Db_name=CWFOLB

7. Edit duplicate.sql

[oracle@foldb1 ~] $cat duplicate.sql

Duplicate target database

For standby

From active database

DORECOVER

Spfile

Set service_names='CWFOLB'

Set db_unique_name='CWFOLB'

Set log_archive_dest_1='location=+FRA VALID_FOR= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CWFOLB'

Set log_archive_dest_2='SERVICE=COWELLORC LGWR SYNC VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CWFOL'

Set standby_file_management='AUTO'

Set fal_server='CWFOL'

Set fal_client='CWFOLB'

Set control_files='+DATA'

Set cluster_database='false'

Error that occurred:

1.

MAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of Duplicate Db command at 01/28/2016 13:03:45

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-04014: startup failed: ORA-00119: invalid specification for system parameter REMOTE_LISTENER

ORA-00132: syntax error or unresolved network name 'foldb-cluster-scan:1521'

RMAN > * * end-of-file**

* .remote_listener='foldb-cluster-scan:1521'

Solution: drop this parameter on the main library, copy it, and modify it.

two。 The main database and standby database cannot be synchronized in real time, and the status is wait_for_log. Alter system switch logfile is required.

The reason is that there is no standby log for Node 2 on the slave library, add:

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

Alter database add standby logfile thread 2 ('+ DATA','+FRA') size 200m

The normal results are as follows:

SQL > select status from v$managed_standby

STATUS

-

CLOSING

CLOSING

CLOSING

CONNECTED

IDLE

IDLE

APPLYING_LOG

IDLE

IDLE

IDLE

IDLE

11 rows selected.

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.