Databases Reference
In-Depth Information
SYS @ visx1> alter system set cluster_interconnects='192.168.10.2' scope=spfile sid='visx2';
System altered.
SYS @ visx1> alter tablespace temp1 add tempfile '+RECO_CM01' size 32767M;
Tablespace altered.
SYS @ visx1>
How It Works
On Exadata, Oracle RAC databases are created using the Database Configuration Assistant the same way that they are on
non-Exadata 11gR2 environments—if you've used
dbca
in the past, you will find no surprises when running it on Exadata.
There are a few items that you'll need to keep in mind when creating RAC databases on Exadata:
•
Make sure you select all of the RAC nodes that you want your Oracle RAC instances to run on.
If unsure, you can always add RAC instances at a later date, but we generally recommend to
err on the high side and use all available compute node servers, shutting down instances or
deploying RAC services appropriately at a later date if necessary.
•
Use the Database Machine template to eliminate configuration missteps and to provide
consistency.
•
Select the appropriate Oracle ASM disk groups for both data files and recovery structures.
•
When complete, set your
cluster_interconnects
initialization parameter using the
InfiniBand address, make sure your temporary tablespaces are properly sized, and so forth.
21-2. Setting Up a DBFS File System on Exadata
Problem
You wish to implement an Oracle Database File System on Exadata for external files.
Solution
A typical Oracle Exadata installation is built with an interesting set of storage cell grid disks and ASM disk groups
prefixed with DBFS. By default, these will be used to store your Oracle Cluster Registry and voting disks, but you can
also use these to create an Oracle Database File System (DBFS).
■
on exadata you can use any available asM disk groups for DbFs storage, but in the example below we'll use
the
DBFS_DG ASM
disk group.
Note
1.
Log in to your database or Oracle ASM instance and determine the space available for your
target ASM disk group by running the script in Listing 21-1:
Listing 21-1.
lst21-01-dbfsspace.sql
SQL> select name,total_mb,free_mb
from v$asm_diskgroup
where name='DBFS_DG'
/
Search WWH ::
Custom Search