| RMAN and Dataguard [message #670440] |
Wed, 04 July 2018 11:58  |
dirish
Messages: 232
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
