2 Multiplexer Control Files Oracle (control-files)


Multiplexer Oracle control files.

How to add control files in Oracle.

How to multiplex the control files with a spile.

How to add a control file with a PFILE.

It is strongly recommended to multiplex control files also called ctl files (control-files).

Multiplexing can be implemented in the creation of the database or subsequently.

We'll add a control file in the next destination E: \ DATABASE \ -> CONTROL04.CTL.
Add an Oracle control file with a static parameter file PFILE.

Edit the PFILE is appointing initSID.ora, complete control file parameter by adding the path + name of the new control file.

 CONTROL_FILES = ('Coracledba\oradata\test_database\control.ctl'

                'D:\DATABASE\CONTROL02.CTL'

                 ‘E:\DATABASE\CONTROL03.CTL '

                 ‘E:\DATABASE\CONTROL04.CTL ')

Adds a control file with Oracle server parameter file SPFILE.

In console mode in Sql * Plus, use the ALTER SYSTEM SET parameter on CONTROL_FILES with the option SCOPE=SPFILE .

 SQL> ALTER SYSTEM SET CONTROL_FILES = 'Coracledba\oradata\test_database\control.ctl'

'D:\DATABASE\CONTROL02.CTL'

 E:\DATABASE\CONTROL03.CTL '

 E:\DATABASE\CONTROL04.CTL 'SCOPE =SPFILE;

Now we do an immediate shutdown of the database.

SQL> SHUTDOWN IMMEDIATE;
Copy a control file for Oracle multiplex.

Then the principle is the copy / paste a file ctl, we will copy either a control existing files 1, 2 or 3 in the new slot E:\DATABASE\ and then rename the file ctl CONTROL04.CTL.

Be careful to copy a file to multiplex coherent control (no worries if the database is closed normally ie without SHUTDOWN ABORT).

We start the Oracle database.

SQL> STARTUP;

You now have 4 control files.

You can also use this technique to move a control file or delete a file control.

2 comments:

Unknown said...

This is really informative blog. I can try some implementation by myself with the help of the article like this.

I recently joined in IIHT Vadapalani for Oracle DBA Training in Chennai. This is a best coaching center and best place improving our skill-set.

Jaideep Singh said...

Hello,
I read your blog and it was very interesting and useful for me. I am very thankful to you for these types of blogs and i wish you can post like this.
Thank you.

 

Oracle DBA Tutorial Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates