Creating Control File in oracle database

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS ‘/home/oracle/dbscripts/control_file.sql’;

Database altered.

SQL>exit

Now open your control_file.sql

[oracle@ermankara dbscripts]$ cat control_file.sql
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE “DB12CC” NORESETLOGS  NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
‘/data/DB12CC/onlinelog/o1_mf_1_dq1dsxry_.log’,
‘/reco/DB12CC/onlinelog/o1_mf_1_dq1dsxvb_.log’
) SIZE 50M BLOCKSIZE 512,
GROUP 2 (
‘/data/DB12CC/onlinelog/o1_mf_2_dq1dsy3t_.log’,
‘/reco/DB12CC/onlinelog/o1_mf_2_dq1dsy5p_.log’
) SIZE 50M BLOCKSIZE 512,
GROUP 3 (
‘/data/DB12CC/onlinelog/o1_mf_3_dq1dsyf4_.log’,
‘/reco/DB12CC/onlinelog/o1_mf_3_dq1dsyg2_.log’
) SIZE 50M BLOCKSIZE 512
— STANDBY LOGFILE
DATAFILE
‘/data/DB12CC/datafile/o1_mf_system_dq1dqmhx_.dbf’,
‘/data/DB12CC/datafile/o1_mf_denemene_dr5p3o6t_.dbf’,
‘/data/DB12CC/datafile/o1_mf_sysaux_dq1dpjdm_.dbf’,
‘/data/DB12CC/datafile/o1_mf_undotbs1_dq1ds1qg_.dbf’,
‘/data/DB12CC/datafile/o1_mf_example_dq1dt1pc_.dbf’,
‘/data/DB12CC/datafile/o1_mf_users_dq1ds0nv_.dbf’,
‘/u01/app/oracle/erman.dbf’,
‘/u01/app/oracle/product/12.1.2/db/dbs/bigtbs_f1.dat’,
‘/data/DB12CC/datafile/o1_mf_omf_ts2_dr5q53y7_.dbf’,
‘/data/DB12CC/datafile/dummy.dbf’
CHARACTER SET AL32UTF8
;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s