Exam Prep Questions

1:Your database currently has one control file. You, after careful consideration, decide that adding two more control files will provide better protection against a single point of failure at the control file level. To accomplish this, you edit the initSID.ora file to point to the new location.
control_files='/mydatabases/mydb1/control_01.ctl',
'/mydatabases02/mydb1/control_02.ctl',
'/mydatabases03/mydb1/control_03.ctl'

You shut down your database normal and copy the control files to the new location.

Cp /mydatabases/mydb1/control_01.ctl /mydatabases2/mydb1/control_02.ctl
Cp /mydatabases/mydb1/control_01.ctl /mydatabases3/mydb1/control_03.ctl

When you restart your database using the altered PFILE, you receive the error ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.