Controlfile in Oracle Database

 Today we are going to have look at the most important element of the Oracle Databases.Being Oracle DBA we must have good knowledge about Controlfile. It plays an important role in Oracle Database. If something happens wrong with it we are not able to start our database. Let’s have some important knowledge about Controlfile. Whenever we face oracle interviews. More than one questions come from a Controlfile session.

Controlfile Contains the following type of information:

1. Archive log history
2. Tablespace and datafile records (filenames, datafile checkpoints, read/write status, offline or not)
3. Current redo log file sequence number
4. Database’s creation date
5. Database name
6. Current archive log mode
7. Backup information
8. Database block corruption information
9. Database ID, which is unique to each DB

As we know Control file plays an important role in the Oracle database. Multiplexing of controlfile is also playing an important role. Now we are going to know about the steps of multiplexing of controlfile.

Multiplexing Control file using SPFILE:

SQL>ALTER SYSTEM SET control_files='D:\oracle\product\11.2.0\oradata\orcl\CONTROL01.CTL','D:\oracle\product\11.2.0\oradata\orcl\CONTROL02.CTL','D:\oracle\product\11.2.0\oradata\orcl\CONTROL03.CTL','D:\oracle\product\11.2.0\oradata\orcl\CONTROL04.CTL' SCOPE=spfile;
SQL> shutdown;
D:\> copy D:\oracle\product\11.2.0\oradata\orcl\CONTROL01.CTL D:\oracle\product\11.2.0\oradata\orcl\CONTROL04.CTL
SQL> startup;

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp