31 Aug, 2010
Posted by: Mark In: Oracle
We have a generic RMAN script that backups up most of our database, however we noticed that on one day one of the servers archive logs was increasing in size and after some investigation we found the following issue.
The Problem
RMAN> print script full_disk_disk_backup;
printing stored global script: full_disk_disk_backup
{sql ‘alter system archive log current’;
sql ‘alter database backup [...]
22 Aug, 2010
Posted by: Mark In: Oracle
Recently I upgraded a database from 10.2.0.3 to 11.1.0.7 however after testing, the customer found that their application wasn’t performing well under the new version. They had a number of other tasks on so they asked me to downgrade them back to the 10.2.0.3 version. These are the steps I took to successfully take them [...]
28 Jan, 2010
Posted by: Mark In: Oracle
End
RMAN Guide for Oracle Real Application Clusters 10gR2;
A short guide to backup and recovery using RMAN in RAC 10gR2
RMAN is a utility that backs up, restores, and recovers Oracle databases. It can be used with or without the central information repository called a recovery catalog. If a recovery catalog is not used, RMAN uses the [...]
Recent Comments