Implementation of an active database for duplicate of Rman heterogeneous machine

Experimental environment:

Source database server Name: Beijing database Global name and SID:ORCL

Secondary database: Suzhou Only install database software, no new database

Copy a routine name and database names on the secondary server Suzhou is BJ's database.

The steps are as follows:

(1) Building the secondary database directory structure on the secondary database server Suzhou

(2) Establish database replication routine service on Suzhou server

(3) Source database server name Beijing create Pfile, and copy to secondary database, modify related content

(4) Using pfile files on the secondary server Suzhou to boot the secondary database to the Nomount state

(5) Add configuration listening and Network service resolution

(6) The source database server name Suzhou Execute rman duplicate command copy Database

(7) Creating SPFile files on the secondary server Suzhou

The first part: the Source database configuration

1. Source Database Open Archive

sql> archive log list;

Database log mode non-archive mode

AutoArchive disabled

Archive Endpoint Use_db_recovery_file_dest

The oldest online log sequence 5

Current Log Sequence 7

Sql>host mkdir e:\archive

Sql>host mkdir E:\backup

Sql> alter system set log_archive_dest_1= ' location=e:\archive ' Scope=both;

The system has changed.

sql> archive log list;

Database log mode non-archive mode

AutoArchive disabled

Archive Endpoint E:\archive

The oldest online log sequence 5

Current Log Sequence 7

sql> shutdown immediate;

The database has been closed.

The database has been unloaded.

The ORACLE routine has been closed.

sql> startup Mount;

The ORACLE routine has started.

Total System Global area 1252663296 bytes

Fixed Size 2175328 bytes

Variable Size 788532896 bytes

Database buffers 452984832 bytes

Redo buffers 8970240 bytes

Database loading complete.