You have configured flash recovery area in your database and you set the followingInitialization parameters for your dat

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You have configured flash recovery area in your database and you set the followingInitialization parameters for your dat

Post by answerhappygod »

You have configured flash recovery area in your database and you set the followingInitialization parameters for your database instance:LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY'LOG _ARCHIEVE_DEST 2 = 'LOCATION=/disk2/arch'LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/archLOG_ARCH1VK_DEST_4 = 'LOCATION=/disk4/arch'LOG_ARCHIVE_MIN-SUCCEED_DEST = 2While the database instance is functional, you realized that the destination set by theLOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.What happens in an event of log switch?

A. The online redo log file is not allowed to be overwritten.
B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply