Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <DatabaseTemplate name="wailua" description="This is a template created from an existing template - New Database." version="12.1.0.0.0">
- <CommonAttributes>
- <option name="OMS" value="false"/>
- <option name="JSERVER" value="false"/>
- <option name="SPATIAL" value="false"/>
- <option name="IMEDIA" value="false"/>
- <option name="XDB_PROTOCOLS" value="true">
- <tablespace id="SYSAUX"/>
- </option>
- <option name="ORACLE_TEXT" value="false">
- <tablespace id="SYSAUX"/>
- </option>
- <option name="SAMPLE_SCHEMA" value="true">
- <tablespace id="SYSAUX"/>
- </option>
- <option name="CWMLITE" value="false">
- <tablespace id="SYSAUX"/>
- </option>
- <option name="APEX" value="false">
- <tablespace id="SYSAUX"/>
- </option>
- <option name="DV" value="false">
- <tablespace id="SYSAUX"/>
- </option>
- </CommonAttributes>
- <Variables/>
- <CustomScripts Execute="false"/>
- <InitParamAttributes>
- <InitParams>
- <initParam name="memory_target" value="0" unit="MB"/>
- <initParam name="db_create_file_dest" value="+DATA"/>
- <initParam name="db_domain" value=""/>
- <initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
- <initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
- <initParam name="compatible" value="12.1.0.1.0"/>
- <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
- <initParam name="sga_target" value="3200" unit="MB"/>
- <initParam name="processes" value="300"/>
- <initParam name="local_listener" value="LISTENER_WAILUA"/>
- <initParam name="undo_tablespace" value="UNDOTBS1"/>
- <initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
- <initParam name="db_recovery_file_dest" value="+DATA"/>
- <initParam name="audit_trail" value="db"/>
- <initParam name="db_block_size" value="32768"/>
- <initParam name="open_cursors" value="300"/>
- <initParam name="db_recovery_file_dest_size" value="4815" unit="MB"/>
- <initParam name="pga_aggregate_target" value="1600" unit="MB"/>
- </InitParams>
- <MiscParams>
- <databaseType>MULTIPURPOSE</databaseType>
- <maxUserConn>20</maxUserConn>
- <customSGA>true</customSGA>
- <characterSet>AL32UTF8</characterSet>
- <nationalCharacterSet>AL16UTF16</nationalCharacterSet>
- <archiveLogMode>false</archiveLogMode>
- <initParamFileName>{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/pfile/init.ora</initParamFileName>
- </MiscParams>
- <SPfile useSPFile="true">+DATA/{DB_UNIQUE_NAME}/spfile{SID}.ora</SPfile>
- </InitParamAttributes>
- <StorageAttributes>
- <ControlfileAttributes id="Controlfile">
- <maxDatafiles>100</maxDatafiles>
- <maxLogfiles>16</maxLogfiles>
- <maxLogMembers>3</maxLogMembers>
- <maxLogHistory>1</maxLogHistory>
- <maxInstances>8</maxInstances>
- <image name="control01.ctl" filepath="+DATA/{DB_UNIQUE_NAME}/"/>
- <image name="control02.ctl" filepath="+DATA/{DB_UNIQUE_NAME}/"/>
- </ControlfileAttributes>
- <DatafileAttributes id="+DATA/{DB_UNIQUE_NAME}/temp01.dbf" con_id="1">
- <tablespace>TEMP</tablespace>
- <temporary>false</temporary>
- <online>true</online>
- <status>0</status>
- <size unit="MB">20</size>
- <reuse>true</reuse>
- <autoExtend>true</autoExtend>
- <increment unit="KB">640</increment>
- <maxSize unit="MB">-1</maxSize>
- </DatafileAttributes>
- <DatafileAttributes id="+DATA/{DB_UNIQUE_NAME}/sysaux01.dbf" con_id="1">
- <tablespace>SYSAUX</tablespace>
- <temporary>false</temporary>
- <online>true</online>
- <status>0</status>
- <size unit="MB">550</size>
- <reuse>true</reuse>
- <autoExtend>true</autoExtend>
- <increment unit="KB">10240</increment>
- <maxSize unit="MB">-1</maxSize>
- </DatafileAttributes>
- <DatafileAttributes id="+DATA/{DB_UNIQUE_NAME}/undotbs101.dbf" con_id="1">
- <tablespace>UNDOTBS1</tablespace>
- <temporary>false</temporary>
- <online>true</online>
- <status>0</status>
- <size unit="MB">200</size>
- <reuse>true</reuse>
- <autoExtend>true</autoExtend>
- <increment unit="KB">5120</increment>
- <maxSize unit="MB">-1</maxSize>
- </DatafileAttributes>
- <DatafileAttributes id="+DATA/{DB_UNIQUE_NAME}/system01.dbf" con_id="1">
- <tablespace>SYSTEM</tablespace>
- <temporary>false</temporary>
- <online>true</online>
- <status>0</status>
- <size unit="MB">700</size>
- <reuse>true</reuse>
- <autoExtend>true</autoExtend>
- <increment unit="KB">10240</increment>
- <maxSize unit="MB">-1</maxSize>
- </DatafileAttributes>
- <DatafileAttributes id="+DATA/{DB_UNIQUE_NAME}/users01.dbf" con_id="1">
- <tablespace>USERS</tablespace>
- <temporary>false</temporary>
- <online>true</online>
- <status>0</status>
- <size unit="MB">5</size>
- <reuse>true</reuse>
- <autoExtend>true</autoExtend>
- <increment unit="KB">1280</increment>
- <maxSize unit="MB">-1</maxSize>
- </DatafileAttributes>
- <TablespaceAttributes id="SYSAUX" con_id="1">
- <temporary>false</temporary>
- <defaultTemp>false</defaultTemp>
- <undo>false</undo>
- <local>true</local>
- <blockSize>-1</blockSize>
- <allocation>1</allocation>
- <uniAllocSize unit="KB">-1</uniAllocSize>
- <initSize unit="KB">64</initSize>
- <increment unit="KB">64</increment>
- <incrementPercent>50</incrementPercent>
- <minExtends>1</minExtends>
- <maxExtends>4096</maxExtends>
- <minExtendsSize unit="KB">64</minExtendsSize>
- <logging>true</logging>
- <recoverable>false</recoverable>
- <maxFreeSpace>0</maxFreeSpace>
- <autoSegmentMgmt>true</autoSegmentMgmt>
- <bigfile>true</bigfile>
- <datafilesList>
- <TablespaceDatafileAttributes id="+DATA">
- <id>-1</id>
- </TablespaceDatafileAttributes>
- </datafilesList>
- </TablespaceAttributes>
- <TablespaceAttributes id="SYSTEM" con_id="1">
- <temporary>false</temporary>
- <defaultTemp>false</defaultTemp>
- <undo>false</undo>
- <local>true</local>
- <blockSize>-1</blockSize>
- <allocation>3</allocation>
- <uniAllocSize unit="KB">-1</uniAllocSize>
- <initSize unit="KB">64</initSize>
- <increment unit="KB">64</increment>
- <incrementPercent>50</incrementPercent>
- <minExtends>1</minExtends>
- <maxExtends>-1</maxExtends>
- <minExtendsSize unit="KB">64</minExtendsSize>
- <logging>true</logging>
- <recoverable>false</recoverable>
- <maxFreeSpace>0</maxFreeSpace>
- <autoSegmentMgmt>true</autoSegmentMgmt>
- <bigfile>true</bigfile>
- <datafilesList>
- <TablespaceDatafileAttributes id="+DATA">
- <id>-1</id>
- </TablespaceDatafileAttributes>
- </datafilesList>
- </TablespaceAttributes>
- <TablespaceAttributes id="TEMP" con_id="1">
- <temporary>true</temporary>
- <defaultTemp>true</defaultTemp>
- <undo>false</undo>
- <local>true</local>
- <blockSize>-1</blockSize>
- <allocation>1</allocation>
- <uniAllocSize unit="KB">-1</uniAllocSize>
- <initSize unit="KB">64</initSize>
- <increment unit="KB">64</increment>
- <incrementPercent>0</incrementPercent>
- <minExtends>1</minExtends>
- <maxExtends>0</maxExtends>
- <minExtendsSize unit="KB">64</minExtendsSize>
- <logging>true</logging>
- <recoverable>false</recoverable>
- <maxFreeSpace>0</maxFreeSpace>
- <autoSegmentMgmt>true</autoSegmentMgmt>
- <bigfile>true</bigfile>
- <datafilesList>
- <TablespaceDatafileAttributes id="+DATA">
- <id>-1</id>
- </TablespaceDatafileAttributes>
- </datafilesList>
- </TablespaceAttributes>
- <TablespaceAttributes id="UNDOTBS1" con_id="1">
- <temporary>false</temporary>
- <defaultTemp>false</defaultTemp>
- <undo>true</undo>
- <local>true</local>
- <blockSize>-1</blockSize>
- <allocation>1</allocation>
- <uniAllocSize unit="KB">-1</uniAllocSize>
- <initSize unit="KB">512</initSize>
- <increment unit="KB">512</increment>
- <incrementPercent>50</incrementPercent>
- <minExtends>8</minExtends>
- <maxExtends>4096</maxExtends>
- <minExtendsSize unit="KB">512</minExtendsSize>
- <logging>true</logging>
- <recoverable>false</recoverable>
- <maxFreeSpace>0</maxFreeSpace>
- <autoSegmentMgmt>true</autoSegmentMgmt>
- <bigfile>true</bigfile>
- <datafilesList>
- <TablespaceDatafileAttributes id="+DATA">
- <id>-1</id>
- </TablespaceDatafileAttributes>
- </datafilesList>
- </TablespaceAttributes>
- <TablespaceAttributes id="USERS" con_id="1">
- <temporary>false</temporary>
- <defaultTemp>false</defaultTemp>
- <undo>false</undo>
- <local>true</local>
- <blockSize>-1</blockSize>
- <allocation>1</allocation>
- <uniAllocSize unit="KB">-1</uniAllocSize>
- <initSize unit="KB">128</initSize>
- <increment unit="KB">128</increment>
- <incrementPercent>0</incrementPercent>
- <minExtends>1</minExtends>
- <maxExtends>4096</maxExtends>
- <minExtendsSize unit="KB">128</minExtendsSize>
- <logging>true</logging>
- <recoverable>false</recoverable>
- <maxFreeSpace>0</maxFreeSpace>
- <autoSegmentMgmt>true</autoSegmentMgmt>
- <bigfile>true</bigfile>
- <datafilesList>
- <TablespaceDatafileAttributes id="+DATA">
- <id>-1</id>
- </TablespaceDatafileAttributes>
- </datafilesList>
- </TablespaceAttributes>
- <RedoLogGroupAttributes id="1">
- <reuse>false</reuse>
- <fileSize unit="KB">51200</fileSize>
- <Thread>1</Thread>
- <member ordinal="0" memberName="redo01.log" filepath="+DATA/{DB_UNIQUE_NAME}/"/>
- </RedoLogGroupAttributes>
- <RedoLogGroupAttributes id="2">
- <reuse>false</reuse>
- <fileSize unit="KB">51200</fileSize>
- <Thread>1</Thread>
- <member ordinal="0" memberName="redo02.log" filepath="+DATA/{DB_UNIQUE_NAME}/"/>
- </RedoLogGroupAttributes>
- <RedoLogGroupAttributes id="3">
- <reuse>false</reuse>
- <fileSize unit="KB">51200</fileSize>
- <Thread>1</Thread>
- <member ordinal="0" memberName="redo03.log" filepath="+DATA/{DB_UNIQUE_NAME}/"/>
- </RedoLogGroupAttributes>
- </StorageAttributes>
- </DatabaseTemplate>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement