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’ […]