Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Oracle Discussions

Exam 1z0-063 topic 1 question 188 discussion

Actual exam question from Oracle's 1z0-063
Question #: 188
Topic #: 1
[All 1z0-063 Questions]

A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2. Issue ALTER SYSTEM SET CONTROL_FILES= /u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/ disk2/control02, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/app/oracle/ oradata/cdb1/disk3/control03.ctl;.
4. Copy the control file from the existing location to /u01/app/oracle/oradata/cdb1/disk3/control03.ctl.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.

  • A. 3, 4
  • B. 2, 1, 4, 6
  • C. 3, 1, 4, 6
  • D. 1, 5, 2, 4, 6
  • E. 2, 6
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
You can create an additional control file copy for multiplexing by copying an existing control file to a new location and adding the file name to the list of control files.
Similarly, you rename an existing control file by copying the file to its new name or location, and changing the file name in the control file list. In both cases, to guarantee that control files do not change during the procedure, shut down the database before copying the control file.
To add a multiplexed copy of the current control file or to rename a control file:
1. Shut down the database.
2. Copy an existing control file to a new location, using operating system commands.
3. Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control file name, or to change the existing control filename.
4. Restart the database.
by alipilot2006 at April 24, 2019, 9:55 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
heqh
2 years, 11 months ago
Answer B
upvoted 1 times
...
FelipeK
4 years, 2 months ago
Answer B
upvoted 2 times
...
sherifelia
4 years, 2 months ago
Answer B
upvoted 2 times
...
gracee
4 years, 3 months ago
correct ans: B
upvoted 1 times
...
Sherry
4 years, 7 months ago
The correct answer is B. The root point is SCOPE=SPFILE is necessary
upvoted 2 times
Sugar
3 years, 10 months ago
I agree on this. i just double check it on my book
upvoted 1 times
...
...
alipilot2006
4 years, 12 months ago
The answer is "B"
upvoted 2 times
Varlos
4 years, 11 months ago
It's wrong. Control File 2 doestn have .ctl extension. Must be "C"
upvoted 1 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel