Your database is running in archivelog mode. Examine the parameters for your database instance:LOG_ARCHIVE_DEST_l ='LOCA

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: 899566
Joined: Mon Aug 02, 2021 8:13 am

Your database is running in archivelog mode. Examine the parameters for your database instance:LOG_ARCHIVE_DEST_l ='LOCA

Post by answerhappygod »

Your database is running in archivelog mode. Examine the parameters for your database instance:LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'LOG_ARCHIVE _MIN_SUCCEED_DEST = 2While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.What happens at the next log switch?

A. The database instance hangs and the redo log files are not overwritten.
B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
C. The database instance is shutdown immediately.
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