Databases Reference
In-Depth Information
From the output, it's clear that the RECO diskgroup has 5,685,751 MB. Assume it is more than enough for the FRA.
7.
Log on to the Compute Node as the Oracle Database Software owner, which may be
named “oradb.” (Note that in some installations the owner for both the Database Software
and Grid Infrastructure may be the same.)
8.
Log on to the database as SYSDBA:
$ sqlplus / as sysdba
9.
Set the fast recovery area parameters—location and size:
SQL> alter system set db_recovery_file_dest_size = 5520G;
System altered.
SQL> alter system set db_recovery_file_dest = '+RECO';
System altered.
10.
On the Compute Node, add a special service called RMAN that is available on all eight
nodes of the Exadata rack:
$ srvctl add service -d PROPRD -s RMAN -r
"PROPRD1,PROPRD2,PROPRD3,PROPRD4,PROPRD5,PROPRD6,PROPRD7,PROPRD8"
Not
■
the exact database name, instance names, and the nodes will need to be used in the above command. in this
example we have shown a database called prOprd that runs on all eight nodes, so there are eight instances.
11.
Start the newly created service:
$ srvctl start service -d PROPRD -s RMAN
12.
While still on the Compute Node, under $ORACLE_HOME of Oracle Database, go to the
directory network/admin:
$ cd $ORACLE_HOME/network/admin
13.
Open the file tnsnames.ora and place the following entry there:
RMAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pprd-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RMAN)
)
)
