Step 1: Target DB
Stop replicat services
Create new gauranteed restore point
SQL> sho parameter db_n
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string TROY
SQL> col current_scn for 99999999999999999999999999
select current_scn from v$database;SQL>
CURRENT_SCN
---------------------------
17592545484828
SQL> select GROUP_NAME,LOG_CMPLT_CSN, seqno, rba from ggadmin.ICP02_CHKPNT;
GROUP_NA LOG_CMPLT_CSN SEQNO RBA
-------- -------------------------------------------------------------------------------------------------------------------------------- ---------- ----------
R_ICP02 5474 1269633
R1_ICP02 1 2800078
SQL> create restore point before_reset guarantee flashback database;
Restore point created.
SQL> select * from v$restore_point;
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME RESTORE_POINT_TIME PRE
---------- --------------------- --- ------------ --------------------------------------------------------------------------- --------------------------------------------------------------------------- ---
NAME PDB CLE PDB_INCARNATION# REP CON_ID
-------------------------------------------------------------------------------------------------------------------------------- --- --- ---------------- --- ----------
1.7593E+13 1 YES 4.0234E+11 25-JUN-21 10.53.18.000000000 AM YES
AFTER_REFRESH NO NO 0 NO 0
1.7593E+13 1 YES 2.3622E+10 27-JUN-21 05.36.44.000000000 AM YES
BEFORE_UPGRADE NO NO 0 NO 0
1.7593E+13 1 YES 4294967296 28-JUN-21 05.22.08.000000000 AM YES
BEFORE_RESET NO NO 0 NO 0
Step 2: Target DB
Flashback database to restore point
srvctl stop database -d TROY -o immediate
startup mount
flashback database to restore point BEFORE_UPGRADE;
alter database open resetlogs;
shu immediate
srvctl start database -d TROYStep 3: Target DB
SQL> select GROUP_NAME,LOG_CMPLT_CSN, seqno, rba from ggadmin.ICP02_CHKPNT;
GROUP_NA LOG_CMPLT_CSN SEQNO RBA
-------- -------------------------------------------------- ---------- ----------
R_ICP02 5474 1269633
R1_ICP02 1 2800078
Step 4: Target DB
dblogin UserID ggadmin@TROY, Password ggadmin
alter R_ICP02 extseqno 5474, extrba 1269633
start R_ICP02 NOFILTERDUPTRANSACTIONS
alter R1_ICP02 extseqno 1, extrba 2800078
start R1_ICP02 NOFILTERDUPTRANSACTIONS
DBATracker 