-
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
RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0… READ MORE
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect… 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
When AUTOBACKUP is turned on Oracle will create backup of controlfile and spfile. When one runs backup of the database… READ MORE
Using the debug option one can turn on trace information, this can be used to troubleshoot an issue. Example: $ORACLE_HOME/bin/rman… READ MORE
Steps if you need to restore all datafiles in a tablespace is corrupted so you would need to restore the… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 