-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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… READ MORE
A quick emergency FRA clean up when archived logs are full. This file contains hidden or bidirectional Unicode text… READ MORE
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… READ MORE
RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0… READ MORE
If for some reason the online redo log were lost or when cloning the copy of shutdown database you don’t… READ MORE
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect… READ MORE
# Capture amount of redo logs generated when table is created in UNRECOVERABLE SQL> select vs.name, vm.value from v$mystat vm,… READ MORE
When using VALIDATE option, Oracle will validate backup and not create backups and will not restore when this option is… READ MORE
To move/rename current block change tracking file, one would need to restart the database. # Get current block change tracking… READ MORE
Backup in RMAN can be compressed when they are being created. Using the following command one can compress backup to… READ MORE
Starting RMAN with check syntax will check syntax of RMAN command, it will report errors if the syntax is incorrect.… READ MORE
When one offline a datafile before you online the datafile one has to recover the datafile 1) Offline a datafile… READ MORE
Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of… READ MORE
Scenario when all control files for some reason have been lost. The following scenario shows how to restore controlfile and… READ MORE
Restore spfile through RMAN, here are some scenerios/examples. There are some pre-requites, the database would need to be in nomount… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 