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