How Oracle uses standby to upgrade a single-instance database to a RAC Environment (ii) establishment of a standby database

With Oracle's standby technology, a single-instance database can be upgraded to a RAC database. This approach can effectively reduce the downtime for single instance migration to the RAC environment.

This article describes the establishment of the standby database.

The last one completed most of the preparation of the work, the following open the database, but also to set the target database password file.

Copy the password files on the two nodes of the standby RAC Environment:

bash-3.00$ CD $ORACLE _home/dbs

bash-3.00$ FTP 172.0.2.61

Connected to 172.0.2.61.

NETDB1 FTP server ready.

Name (172.0.2.61:oracle): Oracle

331 Password required for Oracle.

Password:

230 User Oracle logged in.

Remote system type is UNIX.

Using binary mode to transfer files.

Ftp> bin

Type set ToI.

Ftp> Cd/data/oracle/product/11.1/dbs

CWD command successful.

ftp> prompt

Interactive mode off.

Ftp> Mget orapwtest11g

PORT command successful.

Opening BINARY mode data connection for orapwtest11g (1536 bytes).

Transfer complete.

local:orapwtest11gremote:orapwtest11g

1536 bytes received in 0.017 seconds (87.65 kbytes/s)

Ftp> exit

? Invalid command

Ftp> quit

221-you have transferred 1536 bytes in 1 files.

221-total traffic for this session is 2229 bytes in 2 transfers.

221-thank for using the FTP service on NETDB1.

221 Goodbye.

bash-3.00$ MV Orapwtest11gorapwtest11gr1

On Node 2, the password file should be renamed to ORAPWTEST11GR2.

Modify the listening configuration on the standby Database node 1 and add the TEST11GR1 configuration in the Sid_list_listener configuration:

Sid_list_listener =

(Sid_list =

(Sid_desc =

(Sid_name = rac11g1)

(Oracle_home =/data/oracle/product/11.1/database)

)

(Sid_desc =

(Sid_name = TEST11GR1)

(Oracle_home =/data/oracle/product/11.1/database)

)

)

Restart listening below:

bash-3.00$ Lsnrctl Stop

Lsnrctl for solaris:version11.1.0.6.0-production on 1 March-July-2009 17:21:39

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (Description= (address= (protocol=tcp) (HOST=SER1-VIP) (port=1521))

Command execution succeeded

bash-3.00$ Lsnrctl Start

Lsnrctl for solaris:version11.1.0.6.0-production on 1 March-July-2009 17:21:42

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Start/data/oracle/product/11.1/database/bin/tnslsnr: Please wait ...

Tnslsnr for Solaris:version11.1.0.6.0-production

System parameter file is/data/oracle/product/11.1/database/network/admin/listener.ora

Write log information for/data/oracle/diag/tnslsnr/ser1/listener/alert/log.xml

Listening: (Description= (Address= (protocol=tcp) (host=172.0.2.68) (port=1521))

Listening: (Description= (Address= (protocol=tcp) (Host=ser1) (port=1521))

Listening: (Description= (Address= (PROTOCOL=IPC) (Key=extproc))

Connecting to (Description= (address= (protocol=tcp) (HOST=SER1-VIP) (port=1521))

Status of the Listener

------------------------

Alias LISTENER

Version Tnslsnr for Solaris:version11.1.0.6.0-production

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/