Sunday, 15 December 2013

How to create control file

SQL> shutdown;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "KUMAR" RESETLOGS  ARCHIVELOG
  2  --  SET STANDBY TO MAXIMIZE PERFORMANCE
  3      MAXLOGFILES 50
  4      MAXLOGMEMBERS 5
  5      MAXDATAFILES 100
  6      MAXINSTANCES 1
  7      MAXLOGHISTORY 226
  8  LOGFILE
  9    GROUP 1 'E:\ORACLE\ORADATA\KUMAR\REDO01.LOG'  SIZE 100M,
 10    GROUP 2 'E:\ORACLE\ORADATA\KUMAR\REDO02.LOG'  SIZE 100M,
 11    GROUP 3 'E:\ORACLE\ORADATA\KUMAR\REDO03.LOG'  SIZE 100M
 12  -- STANDBY LOGFILE
 13  DATAFILE
 14    'E:\ORACLE\ORADATA\KUMAR\SYSTEM01.DBF',
 15    'E:\ORACLE\ORADATA\KUMAR\UNDOTBS01.DBF',
 16    'E:\ORACLE\ORADATA\KUMAR\CWMLITE01.DBF',
 17    'E:\ORACLE\ORADATA\KUMAR\DRSYS01.DBF',
 18    'E:\ORACLE\ORADATA\KUMAR\EXAMPLE01.DBF',
 19    'E:\ORACLE\ORADATA\KUMAR\INDX01.DBF',
 20    'E:\ORACLE\ORADATA\KUMAR\ODM01.DBF',
 21    'E:\ORACLE\ORADATA\KUMAR\TOOLS01.DBF',
 22    'E:\ORACLE\ORADATA\KUMAR\USERS01.DBF',
 23    'E:\ORACLE\ORADATA\KUMAR\XDB01.DBF',
 24    'E:\ORACLE\ORADATA\KUMAR\OEM_REPOSITORY.DBF'
 25  CHARACTER SET WE8MSWIN1252
 26  ;

Control file created.

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

No comments:

Post a Comment