Your office has new equiptment that allows you to multiplex your control files (

Question

Your office has new equiptment that allows you to multiplex your control files (currently tou only have one control file named control01.ctl in a single disk). The database name is TEST01. The SYSTEM user's password is "MY PASS". The current file is located in the C:oracleproduct.2.0oradataTEST01control1 disrectory. The new disk drives are labeled D and E. The directory structure for the new drives is the same as the C drive. Write the steps and the commands needed to mulitplex the control file and copy ir from its current location to the new drives, the result must be three control files, all onthe three sperate drives, leaving the existing control file intact and in place.

Explanation / Answer

1. In order to add a control we need to update the control_files parameter with the new location using the ALTER SYSTEM SET CONTROL_FILES command.

SQL> alter system

set control_files='C:/oracle/product/10.2.0/oradata/TEST01/control1/control01.ctl',

'D:/oracle/product/10.2.0/oradata/TEST01/control1/control01.ctl',

'E:/oracle/product/10.2.0/oradata/TEST01/control1/control01.ctl'

scope=spfile;

2. Next shutdown the database.

SQL> shutdown immediate

3. Copy one of the existing control files to the new location.

SQL> host

$ cp C:/oracle/product/10.2.0/oradata/TEST01/control1/control01.ctl D:/oracle/product/10.2.0/oradata/TEST01/control1/control01.ctl

$ cp C:/oracle/product/10.2.0/oradata/TEST01/control1/control01.ctl E:/oracle/product/10.2.0/oradata/TEST01/control1/control01.ctl

4. Just startup the database and it's done.

SQL> startup

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.