Control files multiplexing


What is Control File:

It is small binary file

It is required for database during startup operations

Each database associated only one oracle database

Control File Contents:

DB Name and identifiers

Tablespace names

Names and location of data files and redo log files

Check point information

Redo log and archive log information

Backup information

Multiplexing the control file:

Check the database running SPFILE (or) PFILE. My  DB is running SPFILE

Multiplexing Control file DB running in SPFILE

Step 1: Check the control file location


Step 2: Alter the SPFILE




Alter system set command is alter the spfile to including a list of control files to be used

Step 3: Shutdown the database


Shutdown the database in order to create additional control files on the OS level

Step 4: Create additional control files using OS copy command


Step 5: Start the database


When the DB started spfile will be read the oracle server will maintain all control_files parameter.

Step 6: Once complete the activity check the control_files parameter 


Multiplexing Control file DB running in PFILE

Step 1: Shutdown the database
Shutdown the database in order to create additional control files on the OS level

Step 2: Create additional control files
Using OS copy command

Step 4: Add control file names to pfile
Alter the pfile to include a list of all the control files.

Step 5: Start the database
When DB started the PFILE will be read and the oracle server will maintain all control_files parameter.

Comments

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2