You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RM

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 are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RM

Post by answerhappygod »

You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1Incremental backups on all the other days of the week.One of the data files is corrupted and the current online redo log file is lost because of a media failure.You want to recover the data file.Examine the steps involved in the recovery process:1.Shut down the database instance.2.Start up the database instance in nomount state.3.Mount the database.4.Take the data file offline.5.Put the data file online.6.Restore the control file.7.Restore the database.8.Restore the data file.9.Open the database with the resetlog option.10.Recover the database withthe noredo option.11.Recover the data file with the noredo option.Identify the required steps in the correct order.

A. 4, 8, 11, 5
B. 1, 3, 8, 11, 9
C. 1, 2, 6, 3, 7, 10, 9
D. 1, 3, 7, 10, 9 E. 1, 2, 6, 3, 8, 11, 9
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