Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
How to apply archive log file in Oracle?
Answer:
Archive Log need to apply when you need to recover database.
SQL> startup mount
SQL> alter database recover
<<-- Here database instance shall prompt you for required archive log file, you may perform Manual or AUTO recovery-->>
SQL> startup mount
SQL> alter database recover
<<-- Here database instance shall prompt you for required archive log file, you may perform Manual or AUTO recovery-->>
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the use of archive log file? | How does archive log file helps to make backup consistent? |