Hi Team,

Below how i created a guaranteed restore point.

=========================================================================================

SQL> select name,database_role,open_mode,flashback_on,log_mode from v$database;

NAME DATABASE_ROLE OPEN_MODE FLASHBACK_ON LOG_MODE
--------- ---------------- -------------------- ------------------ ------------
ASHISH PRIMARY READ WRITE YES ARCHIVELOG

SQL>
SQL> CREATE RESTORE POINT TEST_02112017 GUARANTEE FLASHBACK DATABASE;

Restore point created.

SQL>
SQL> SELECT scn, database_incarnation#, guarantee_flashback_database, storage_size, time, name FROM v$restore_point;


SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME NAME
---------- --------------------- --- ------------ -------------------------------- ------------------------------
1.4407E+13 3 YES 589299712 11-FEB-17 10.48.06.000000000 AM LOAD_TEST_02112017

################## After testing completes #######################################

SQL> shutdown immediate

SQL> startup mount

SQL> flashback database to restore point TEST_02112017;

Flashback complete

SQL> alter database open resetlogs;

=====================================================================================================================


Could you please help me understand? Why we need to open database with resetlogs after we flashback database to a guaranteed restore point.

Is there a way to open database without resetting the incarnation and logfile sequence?

Since 10g onwards all previous backup will remain valid after resetlogs. How this works?

Thank You ,
Ashish Francis