I keep forgetting the syntax for create control file, thought it would help me and others for the syntax and the steps to create.
STEPS:
1. Shutdown the database
2. sqlplus '/as sysdba'
3. startup nomount
4. Create Control file (syntax below)
5. alter database open
CREATE CONTROLFILE REUSE DATABASE "anydatabasename" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 1000
MAXINSTANCES 8
MAXLOGHISTORY 500
LOGFILE
GROUP 1 'REDLOG PATH' SIZE 10M,
GROUP 2 'REDLOG PATH' SIZE 10M
DATAFILE
;
EXAMPLE:
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 1000
MAXINSTANCES 8
MAXLOGHISTORY 500
LOGFILE
GROUP 1 '/APPS/proddata/log01a.dbf' SIZE 10M,
GROUP 2 '/APPS/proddata/log02a.dbf' SIZE 10M
DATAFILE
'/APPS/proddata/a_txn_data01.dbf' ,
'/APPS/proddata/a_txn_data02.dbf' ,
'/APPS/proddata/a_txn_data03.dbf' ,
'/APPS/proddata/a_txn_ind01.dbf' ,
'/APPS/proddata/a_txn_ind02.dbf' ,
'/APPS/proddata/a_txn_ind03.dbf' ,
'/APPS/proddata/a_txn_ind04.dbf' ,
'/APPS/proddata/a_txn_ind05.dbf' ;
If you want to set a new SID for the database then use SET instead of REUSE.
If you want to reset redo logs which will be ideal for a cloned database out of a cold backup.
STEPS:
1. Shutdown the database
2. sqlplus '/as sysdba'
3. startup nomount
4. Create Control file (syntax below)
5. alter database open
CREATE CONTROLFILE REUSE DATABASE "anydatabasename" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 1000
MAXINSTANCES 8
MAXLOGHISTORY 500
LOGFILE
GROUP 1 'REDLOG PATH' SIZE 10M,
GROUP 2 'REDLOG PATH' SIZE 10M
DATAFILE
EXAMPLE:
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 1000
MAXINSTANCES 8
MAXLOGHISTORY 500
LOGFILE
GROUP 1 '/APPS/proddata/log01a.dbf' SIZE 10M,
GROUP 2 '/APPS/proddata/log02a.dbf' SIZE 10M
DATAFILE
'/APPS/proddata/a_txn_data01.dbf' ,
'/APPS/proddata/a_txn_data02.dbf' ,
'/APPS/proddata/a_txn_data03.dbf' ,
'/APPS/proddata/a_txn_ind01.dbf' ,
'/APPS/proddata/a_txn_ind02.dbf' ,
'/APPS/proddata/a_txn_ind03.dbf' ,
'/APPS/proddata/a_txn_ind04.dbf' ,
'/APPS/proddata/a_txn_ind05.dbf' ;
If you want to set a new SID for the database then use SET instead of REUSE.
If you want to reset redo logs which will be ideal for a cloned database out of a cold backup.
Comments