hello. I configured standby database with primary database in oracle 12c grid infrustructure. my standby database is also RAC. 3-4 days ago we got error and we improve db_recovery_file_dest_size. However it is not improved in standby size. And Logs couldn't move to standby. I lost these logs. I altered db_recovery_file_size in standby like primary.
Now my standby database's last archivelog sequence 696, my primary database's 2428. Archivelogs deleted.
SQL> SELECT * FROM V$ARCHIVE_GAP;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# CON_ID
---------- ------------- -------------- ----------
2 696 2428 1
should i "dublicate database" command from standby database? any idea? and backup policy is 3 days so i lost backups in primary database too.
standby database alert log;
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 696-795
DBID 1433734935 branch 905954199
FAL[client]: All defined FAL servers have been attempted.
------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that's sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
------------------------------------------------------------
THREAD# SEQUENCE# APPLIED
---------- ---------- ---------
1 787 YES
1 788 YES
1 789 YES
1 790 YES
1 791 YES
1 792 YES
1 793 YES
1 794 YES
1 795 YES
1 796 NO
1 797 NO
THREAD# SEQUENCE# APPLIED
---------- ---------- ---------
2 2429 NO
2 2430 NO
882 rows selected.