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 … More
Category: RMAN
ORA-00257: archiver error – FRA Clean Up emergency
A quick emergency FRA clean up when archived logs are full.
RMAN – incremental backup
RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0 … More
How to check if RMAN catalog is installed for a database?
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect … More
Using RMAN to validate backup
When using VALIDATE option, Oracle will validate backup and not create backups and will not restore when this option is … More
How to rename block change tracking file?
To move/rename current block change tracking file, one would need to restart the database. # Get current block change tracking … More
RMAN – to enable compression of backupset
Backup in RMAN can be compressed when they are being created. Using the following command one can compress backup to … More
RMAN – checksyntax
Starting RMAN with check syntax will check syntax of RMAN command, it will report errors if the syntax is incorrect. … More
Offlining a datafile
When one offline a datafile before you online the datafile one has to recover the datafile 1) Offline a datafile … More
Scenario when the controlfile is lost and there was a datafile added
Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of … More
