Home » Server Options » Data Guard » RMAN and Dataguard (Oracle 11.2.0.3.0, RHEL 5.8)
RMAN and Dataguard [message #670440] Wed, 04 July 2018 11:58 Go to previous message
dirish
Messages: 223
Registered: November 2006
Senior Member
on both primary and standby sites - i have in RMAN > CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

but archivelogs are not being deleted on the primary site

when i try to delete from RMAN
RMAN> delete noprompt archivelog until time 'SYSDATE-5';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2836 device type=DISK
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=/ilarch1/archive/CI/CI2_37118_826186736.arc thread=2 sequence=37118


SQL> select max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)
--------------
37154


SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ilarch1/archive/CI/CI
Oldest online log sequence 37153
Next log sequence to archive 37155
Current log sequence 37155


please help

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Impact and risk during data guard implementation
Next Topic: RAC - DG
Goto Forum:
  


Current Time: Sun Jan 26 21:04:13 CST 2020