User's Manual

2.5 Create and set up Oracle database

● Allocate database

Create a database on the shared disk. The shared disk should be active.

Each file is allocated as follows:

File Location Note

Init.ora file Local Allocate on a local disk of each node

Server parameter file Share

Control files Share

Data files Share

Redo log files Share

Archive log files Arbitrary Allocate either on a local disk or a shared disk

● Create database (Scalable operation with Oracle9i RAC)

Create a database on an arbitrary node. This database should be accessible from other

nodes.

Refer to the Oracle9i RAC manual.

● Create database (Standby operation)

Operational node

Create a database on an operational node. Standby nodes have to access this database.

Refer to the Oracle manual.

Standby node

Set up directory generation, file copy, and link. The configuration should be the same as

that of the operational node where the database is generated.

Under $ORACLE_HOME/dbs

Under $ORACLE_BASE/admin/$ORACLE_SID

The access privilege to the generated directory and file should be the same as that of the

operational node.

Set up an output location on the standby nodes if you use archive log operation.

The required files in the operational node can be backed up in a tar format by executing

the “cloracpy” command. Refer to “Chapter 4.4”.

Mutual standby / N:1 Standby operation

Create a database on an operational node.