• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 598
  • Last Modified:

Oracle Alter Database ResetLogs

I would like to know is it necessary to issue Alter Database ResetLogs
if I restore the entire database from the backup and restore everything from the Archived Re-Logs after any diaster that I lose everything.

As I know, onlyl incomplete recovery needs to issue Alter Database ResetLogs, but isn't restore everything from the backup and recover the database is a COMPLETE RECOVERY? I am so confused.
0
mawingho
Asked:
mawingho
2 Solutions
 
mawinghoAuthor Commented:
thanks for your reply, but what I amdoing is it a COMPLETE RECOVERY rather tha INCOMPLETE RECOVERY?
0
 
slightwv (䄆 Netminder) Commented:
>>but isn't restore everything from the backup and recover the database is a COMPLETE RECOVERY?

Yes.  Unless you did a recover until cancel or some other point-in-time recovery.

You do not need to open resetlogs on a complete recovery.


As always, the docs have the information you need:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmrvcon.htm#autoId12

Database Incarnations
 
A database incarnation is created whenever you open the database with the RESETLOGS option. After complete recovery, you can resume normal operations without an OPEN RESETLOGS.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now