sivarajdharmarajan

 Profile Answers by sivarajdharmarajan 

• Oct 9th, 2008

 

RESETLOGS
                   resets the current log sequence number to 1 and
                   invalidates all redo entries in the online and
                   archived redo log files.  You must use this option to
                   open the database after performing media recovery
                   with a backup controlfile.  After opening the
                   database with this option, you should perform a
                   complete database backup. 
 
NORESETLOGS
                   leaves the log sequence number and redo log files in
                   their current state.

    You can only specify these options after performing incomplete media recovery.  In any other case, Oracle uses the NORESETLOGS automatically. 

regards
siva

ianilreddy

 Profile Answers by ianilreddy 

• Aug 7th, 2010

 

resetlogs
When we perform incomplete recovery we should go for resetlogs the incarnation will be created any information in redo logs not required for recovery is flushed out if the redolog files are not present it will create automatically the previous backup and archivelogs not required logsequence
no set 1.

noresetlogs
When we perform complete recovery we can go for this.