1- One of the obsolete integrated extract was causing Rman not to delete expired archive logs. orcl:/u02/DBA/scripts ->./delete_arch.sh The Oracle base remains unchanged with value /u01/app/oracle Recovery Manager: Release 126.96.36.199.0 – Production on Fri Feb 9 15:25:15 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1450870477) RMAN> 2> 3> 4> 5> 6> using target database control … Continue reading GoldenGate – RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process.
A quick emergency FRA clean up when archived logs are full. Continue reading ORA-00257: archiver error – FRA Clean Up emergency
# Capture amount of redo logs generated when table is created in UNRECOVERABLE SQL> select vs.name, vm.value from v$mystat vm, v$statname vs where vm.statistic# = vs.statistic# and vs.name like '%redo size%'; NAME VALUE —————————————————————- ———- redo size 597736 SQL> create table test_all unrecoverable as (select * from all_objects); Table created. SQL> select vs.name, vm.value from v$mystat vm, v$statname vs where vm.statistic# = vs.statistic# and vs.name … Continue reading redo log generation during unrecoverable/nologging