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
Using the following query one can see the flashback data available. SELECT to_char(sysdate,'YYYY-MM-DD HH24:MI') current_time, to_char(f.oldest_flashback_time, 'YYYY-MM-DD HH24:MI') OLDEST_FLASHBACK_TIME, (sysdate – f.oldest_flashback_time)*24*60 HIST_MIN FROM v$database d, V$FLASHBACK_DATABASE_LOG f; CURRENT_TIME OLDEST_FLASHBACK HIST_MIN —————- —————- ———- 2012-04-25 07:34 2012-04-25 05:48 106.066667 Continue reading How to see the oldest flashback available?
RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; RMAN command to run level 1 backup. Level 1 backup will backup all blocks changed since most recent cumulative or differential backup. If a level 0 backup doesn’t exists, when running INCREMENTAL backup Oracle will perform a full backup. RMAN> BACKUP INCREMENTAL LEVEL 1 … Continue reading RMAN – incremental backup
If for some reason the online redo log were lost or when cloning the copy of shutdown database you don’t have the on-line redo logs, you would need to open the database with “RESETLOGS” option which will create the online redo logs. Example: SQL> startup nomount; ORACLE instance started. Total System Global Area 521936896 bytes Fixed Size 2177328 bytes Variable Size 356517584 bytes Database Buffers … Continue reading How to fix issue when the online redo logs are missing?
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect to RMAN catalog and try to run a RMAN command like “list backup” it will generate an error as shown below calora4db01q:/home/oracle $ rman target / catalog rmancataloguser/rmancatalogpassword@catalogdb Recovery Manager: Release 10.2.0.4.0 – Production on Sun Jul 17 08:33:42 2011 Copyright (c) 1982, 2007, Oracle. … Continue reading How to check if RMAN catalog is installed for a database?
# 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