Cloning an Oracle/DB2/Sybase Database in a SAN Environment Using EVA Snapclone Technology (August 2007)

6
Creating Production Database Components on EVA LUNs
To create the production database in the Oracle home directory, create the database using
the following SQL script and name it as Prod:
Note:
If the production database already exists, you need not perform this step.
connect / as SYSDBA
set echo on
spool /prod/OraHome1/assistants/dbca/logs/CreateDB.log
startup nomount pfile="/prod/OraHome1/admin/DB1/pfile/initDB1.ora";
CREATE DATABASE DB1
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/prod/DB1/sys_data/system01.dbf' SIZE 250M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/prod/DB1/sys_data/temp01.dbf' SIZE 200M
REUSE
UNDO TABLESPACE "UNDOTBS1" DATAFILE
'/prod/DB1/sys_data/undotbs01.dbf' SIZE 200M AUTOEXTEND ON
NEXT 5120K MAXSIZE UNLIMITED,
'/prod/DB1/sys_data/undotbs02.dbf' SIZE 200M AUTOEXTEND ON
NEXT 5120K MAXSIZE UNLIMITED,
'/prod/DB1/sys_data/undotabs03.dbf'SIZE 200M AUTOEXTEND ON
NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('/prod/DB1/log_1/redo01a.log', '/prod/DB1/log_2/redo01b.log') SIZE 102400K,
GROUP 2 ('/prod/DB1/log_1/redo02a.log', '/prod/DB1/log_2/redo02b.log') SIZE 102400K,
GROUP 3 ('/prod/DB1/log_1/redo03a.log', '/prod/DB1/log_2/redo03b.log') SIZE 102400K;
spool off
exit;
This step is used to create a database to test the cloning of data using EVA Snapclone.