Which two are prerequisites for creating a standby data…

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

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.

Explanation:
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;
https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4719



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Chunn

Chunn

Correct Ans: A, E

FORCE LOGGING is recommended for Data Guard environment however, when using EMCC to create a standby database primary must be started with SPFILE since it will make changes to database parameters otherwise it will fail. You can still create the standby with out enabling FORCE LOGGING.

Lihui

Lihui

Why B incorrect??

Chunn

Chunn

Sorry.. B,E are correct.
Also explanation is correct. My notes have answers in wrong order and seems I have copied it without paying attention. Sorry…