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.