Database Reference
In-Depth Information
*.compatible='12.1.0.0.0'
*.db_block_size=8192
*.db_domain=''
*.db_name=CLONE
*.db_recovery_file_dest='/u01/fra'
*.db_recovery_file_dest_size=4800m
*.dispatchers='(PROTOCOL=TCP) (SERVICE=CLONEXDB)'
*.open_cursors=300
*.pga_aggregate_target=256m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=768m
*.undo_tablespace='UNDOTBS1'
#*.db_create_file_dest=/u01/oradata
*.clonedb=TRUE
*.control_files='/u01/oradata/CLONE/ctrl01.ctl','/u01/oradata/CLONE/ctrl02.ctl'
Please ensure that all the required directories exist, especially the audit file destination. The parameter clonedb
must be set to true. If you intend to connect to the database as SYS please create a password file as well. You should
also update the oratab file and add the new clone database to it.
Creating the Clone Database
With the parameter file in place connect to the database and execute the crtdb.sql script. For example:
SQL> @crtdb
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> STARTUP NOMOUNT
ORACLE instance started.
Total System Global Area 801701888 bytes
Fixed Size 2293496 bytes
Variable Size 318767368 bytes
Database Buffers 478150656 bytes
Redo Buffers 2490368 bytes
SQL> CREATE CONTROLFILE REUSE SET DATABASE CLONE RESETLOGS
2 MAXLOGFILES 32
3 MAXLOGMEMBERS 2
4 MAXINSTANCES 1
5 MAXLOGHISTORY 908
6 LOGFILE
7 GROUP 1 '/u01/oradata/CLONE/CLONE_log1.log' SIZE 100M BLOCKSIZE 512,
8 GROUP 2 '/u01/oradata/CLONE/CLONE_log2.log' SIZE 100M BLOCKSIZE 512
9 DATAFILE
10 '/media/backup/NCDB/NCDB/system01.dbf' ,
 
Search WWH ::




Custom Search