What is the difference between restoring a database and recovering a database?
Answer / Manuj Kumar
Restoring a database refers to the process of re-creating an entire database from backup files. This includes creating new control files, datafiles, and redo logs based on the backup set and archive log files. On the other hand, recovering a database involves using the recovery manager (RMAN) or SQL*Plus commands to bring a database to a consistent state after a failure or crash. Recovery can be done in no-media recovery or media recovery mode.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we tune a sql query to optimize the performance of a database?
What is the difference between restoring a database and recovering a database?
What if your ocr (oracle cluster registry) is corrupted?
Why is cluster verification utility so important in oracle rac?
What is required by oracle rac database to connect to a network?
What do you mean by database normalization and why is it important?
How can we collect the statistics of different database objects?
How oracle flex asm works?
Mention what is split brain syndrome in rac?
How can you determine what protocol is being used for interconnect traffic?
Mention how oracle flex asm works?
What are the components required to manage oracle real application clusters database?