RMAN is designed to complete a backup or restore as quikly and efficiently as possible. But if a job takes longer than expected to complete it can be confusing trying to determine: What precisely is RMAN doing at any particular time? Is RMAN hung or just slow? How far into the backup/restore has it got? […]
RMAN
Oracle RMAN Backup Shell Script Example
Pre-requisites 1. Create a catalog database (rmancat) if one does not exist. (With additional UNDO-, USERS- and TEMP-tablespaces) 2. Configure SQL*Net to handle the catalog (rmancat) and the ‘target’ database connections. 3. Create a user ‘RMAN’ in the catalog database. SQL> create user rman identified by rman default tablespace USERS quota unlimited on users temporary […]
Upgrading to Oracle 12c using RMAN DUPLICATE with “NOOPEN” clause and “BACKUP LOCATION”
When cloning (duplicating) a database to a higher version, traditionally (prior to 12c), you must use restore/recover of an RMAN backup. This is because the database in the destination must be opened with UPGRADE option. Therefore, the RMAN duplicate could not be used because RMAN automatically opens the auxiliary database with resetlogs. This would fail […]
Beginners Guide to RMAN compression for backups
As the databases keep growing, so does the space occupied by their backups. Fortunately, RMAN has built-in support to compress such large-sized backups which can be handy rather than using an OS utility such as TAR or so on. The following are the 3 kinds of compression techniques used by RMAN: Null compression Unused block […]
Oracle Database 12c New Feature – RMAN “RECOVER TABLE”
Table recovery Table recovery was possible in earlier releases as well. Until previous releases, if we wanted to recover a table, we had the following options: Database point in time recovery (DBPITR) Tablespace point in time recovery (TSPITR) Flashback technology The RECOVER TABLE command is a new feature in 12C that allows a point in […]
How to recreate Control file in Oracle Database
What are control files? The control file is a binary file that defines the current state of the physical database. The control file is one of the core files at the heart of the Oracle database. Together, this means that the Oracle instance itself is the only means by which the contents of the control […]
Managing Oracle Database Backup with RMAN (Examples included)
Installed with the database, Recovery Manager (RMAN) is an Oracle database client which performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering the database. The RMAN environment consists of the utilities and databases that play a role in backing up […]
How to delete archives from only 1 archive destination when 2 or more are in use
If you want to delete the archives of 1 LOG_ARCHIVE_DEST using rman command and want to keep the archive logs from other LOG_ARCHIVE_DEST_[n] for some other purpose, then use DELETE LIKE-clause in RMAN. This way you can maintain the archives in one location and keep the same copy of the archives in another location. Consider […]