Exam 1z0-066 topic 1 question 38 discussion

Actual exam question from Oracle's 1z0-066

Question #: 38
Topic #: 1

[All 1z0-066 Questions]

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

A. The primary database must have FORCE LOGGING enabled.
B. The primary database must be in archivelog mode.
C. A backup of the primary database must exist.
D. The primary host and the proposed standby database host must run the same operating system.
E. The primary database instance must be started using an SPFILE.
F. The primary database must have flashback enabled.

Show Suggested Answer

Suggested Answer: AB 🗳️
A: Before you create a standby database you must first ensure the primary database is properly configured.
Place the primary database in FORCE LOGGING mode.
B: If archiving is not enabled, issue the following SQL statements to put the primary database in ARCHIVELOG mode and enable automatic archiving:
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;
References:
https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4719

by Sugar at Nov. 6, 2021, 3:06 p.m.

Comments

Submit Cancel

Rockfics

1 year, 7 months ago

Selected Answer: AB

Answer A,B C. A backup is not necessary. It can be created by the wizard D. Dataguard support mix O.S. E. PFILE is an option F. Flashback Database is not mandatory

upvoted 1 times

...