Database Archive

Homework Summary
1. Show Database Archive Log Mode Status
2. List 3 V$ Data Dictionary Views Related to ARCHIVELOG Mode
3. Show Data files, Redo Logs, and Temp Files Name and Location
4. How to Determine if a Data File is in Hot-Backup Mode
Homework
1. Show Database Archive Log Mode Status – 25 points
 Use a SQL Query to show current Archive Log Mode on your Database. Your
database should be in ARCHIVELOG Mode if you completed Lab.
 (1) Provide the query and its results
2. List 3 V$ Data Dictionary Views and their descriptions related to
ARCHIVELOG Mode – 25 points
 (2) Provide Data Dictionary View name and their description.
3. Show Data files, Redo Logs, and Control Files On Your Database – 25
points
 Use a SQL Query to get data files, redo logs, and control files name and their
location
 (3) Provide the query and its results
4. How to Determine if a Data File is in Hot-Backup Mode – 25 points
 Use a SQL Query to show Data Files Status of Hot-Backup Mode
 Hint: If a Data File is in Hot-Backup Mode then the result will return ACTIVE,
if not then result will be NOT-ACTIVE
 (4) Provide the query and its results
Deliverables
1. Provide answers to (1), (2), (3), and (4). Include all answers into one file (docx or
similar). Submit the assignment via blackboard

 
ORDER THIS PAPER OR A SIMILAR ONE WITH PRO WRITING TUTORS AND GET AN AMAZING DISCOUNT"