Post-Install Database Tasks - Oracle Exadata Recipes: A Problem-Solution Approach - page 586

• If you wish to configure a Fast Recovery Area or archiving, we recommend using the

RECO ASM

disk group.

• The dbm template will seed memory settings, character sets, and other options; you can

choose to modify these when running dbca based on your database's requirements.

Not ■ If you are unfamiliar with the Database Configuration assistant, please refer to the oracle documentation at
http://docs.oracle.com/cd/E11882_01/server.112/e25494/create002.htm#ADMIN12479 .

When the Database Configuration Assistant completes, you will have an Oracle RAC cluster registered with your
cluster registry and all instances on all nodes should be up. Validate this using srvctl as oracle :

[oracle@cm01dbm01 ~]$ srvctl status database -d visx
Instance visx1 is running on node cm01dbm01
Instance visx2 is running on node cm01dbm02
[oracle@cm01dbm01 ~]$

After you've confirmed your database is available and healthy, depending on the version of your DBM template,
you may need to set or modify some of your database settings including cluster-related and recovery-specific database
initialization parameters, temporary tablespace files and sizes, audit actions, and block change tracking. The code
below demonstrates these activities. Connect to SQL*Plus as SYSDBA and execute the following code based on your
needs and Exadata configuration:

SYS @ visx1> alter database enable block change tracking using file '+DATA_CM01';
Database altered.
SYS @ visx1> alter system set fast_start_mttr_target=300;
System altered.
SYS @ visx1> audit delete on aud$;
Audit succeeded.
SYS @ visx1> create temporary tablespace temp3 tempfile '+RECO_CM01' size 50m;
Tablespace created.
SYS @ visx1> alter database default temporary tablespace temp3;
Database altered.
SYS @ visx1> drop tablespace temp1 ;
Tablespace dropped.
SYS @ visx1> drop tablespace temp2 ;
Tablespace dropped.
SYS @ visx1> create temporary tablespace temp1 tempfile '+RECO_CM01' size 32767M autoextend on;
Tablespace created.
SYS @ visx1> create temporary tablespace temp2 tempfile '+RECO_CM01' size 32767M autoextend on;
Tablespace created.
SYS @ visx1> alter database default temporary tablespace temp1;
Database altered.
SYS @ visx1> drop tablespace temp3;
Tablespace dropped.
SYS @ visx1> alter system set cluster_interconnects='192.168.10.1' scope=spfile sid='visx1';
System altered.