to forcefully delete the archivelogs either from primary or standby
DELETE FORCE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
Process to follow :
1. archive log list on primay
2. archive log list on standby
3. on standby
SQL> SELECT * FROM v$archive_gap;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 910218 910218
4. copy the archivelog from primary to standby using below
on primary:
PROD oracle@primary:/oracle09/path/to/\ $ sftp dr.sample.com
Connected to dr.sample.com.
sftp> pwd
Remote working directory: /home/oracle
sftp> cd /oracle09
sftp> ls
lost+found sss sssbkpinc nohup.out stand01.ctl
sftp> cd sss
sftp> ls
admin nohup.out
sftp> cd admin
sftp> ls
arch audit bdump cdump create diag export listener lsnr_extproc nohup.out
osw sftp> cd arch
sftp> ls
...*.arc files will be displayed
sftp> put redo_569515577_1_910218.arc
Uploading redo_569515577_1_910218.arc to /oracle09/path/to/\/redo_569515577_1_910218.arc
redo_569515577_1_910218.arc 100% 8739KB 4.3MB/s 00:02
sftp>
On standby:
sqlplus / as sysdba
SQL> ALTER DATABASE REGISTER LOGFILE '/oracle09/path/to/\/redo_569515577_1_910218.arc';
Database altered.
SQL> SELECT * FROM v$archive_gap;
no rows selected
SQL> SELECT process, status, sequence#
FROM v$managed_standby
WHERE process LIKE 'MRP%';
2 3
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804225
-------------------------------------------------------------------------------------------------------------------------------------
PROD oracle@primary:/oracle09/path/to/\ $ ls -lrth *910218*
-rw-r----- 1 oracle dba 8.5M Mar 18 06:12 redo_569515577_1_910218.arc
PROD oracle@primary:/oracle09/path/to/\ $ sftp dr.sample.com
Connected to dr.sample.com.
sftp> pwd
Remote working directory: /home/oracle
sftp> cd /oracle09
sftp> ls
lost+found sss sssbkpinc nohup.out stand01.ctl
sftp> cd sss
sftp> ls
admin nohup.out
sftp> cd admin
sftp> ls
arch audit bdump cdump create diag export listener lsnr_extproc nohup.out
osw
sftp> cd arch
sftp> ls
...*.arc files will be displayed
sftp> put redo_569515577_1_910218.arc
Uploading redo_569515577_1_910218.arc to /oracle09/path/to/\/redo_569515577_1_910218.arc
redo_569515577_1_910218.arc 100% 8739KB 4.3MB/s 00:02
sftp>
on standby :
PROD-DR oracle@dr:/oracle09/path/to/\ $ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 24 00:39:49 2026
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
SQL> select thread#,sequence#,applied,registrar from v$archived_log where applied='YES' and sequence#='804754' ORDER BY SEQUENCE#;
no rows selected
SQL> !ls -lrth *select thread#,sequence#,applied,registrar from v$archived_log where applied='YES' and sequence#='804754' ORDER BY SEQUENCE#;^C
SQL> !ls -lrth *804754*
-rw-r----- 1 oracle dba 119M Mar 24 00:12 redo_569515577_2_804754.arc
SQL> ALTER DATABASE REGISTER LOGFILE '/oracle09/path/to/\/redo_569515577_2_804754.arc';
ALTER DATABASE REGISTER LOGFILE '/oracle09/path/to/\/redo_569515577_2_804754.arc'
*
ERROR at line 1:
ORA-16089: archive log has already been registered
SQL> select thread#,sequence#,applied,registrar from v$archived_log where sequence#='804754' ORDER BY SEQUENCE#;
THREAD# SEQUENCE# APPLIED REGISTR
---------- ---------- --------- -------
2 804754 NO RFS
SQL> SELECT * FROM v$archive_gap;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 910218 910218
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PROD-DR oracle@dr:/oracle09/path/to/\ $ ls -lrth *910218*
-rw-r----- 1 oracle dba 8.5M Mar 24 00:45 redo_569515577_1_910218.arc
PROD-DR oracle@dr:/oracle09/path/to/\ $ date
Tue Mar 24 00:45:45 EDT 2026
PROD-DR oracle@dr:/oracle09/path/to/\ $ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 24 00:45:54 2026
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
SQL> ALTER DATABASE REGISTER LOGFILE '/oracle09/path/to/\/redo_569515577_1_910218.arc';
Database altered.
SQL> SELECT * FROM v$archive_gap;
no rows selected
SQL> SELECT process, status, sequence#
FROM v$managed_standby
WHERE process LIKE 'MRP%';
2 3
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804225
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804237
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804238
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804238
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 WAIT_FOR_LOG 804239
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804239
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804239
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804239
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804239
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804240
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804240
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804244
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804245
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804245
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804245
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804245
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
MRP0 APPLYING_LOG 804246
SQL>
No comments:
Post a Comment