Starting with 10g, it's possible to use the RMAN CATALOG command to add backuppieces stored in the disk to the RMAN repository. You may need to catalog backup pieces in the following situations: You copy or move a backup piece with an operating system utility and want it to be usable by RMAN. The RMAN metadata for the backup piece was removed, but the backup piece still exists. This situation can occur if you ran the DELETE command on a backup piece that was only temporarily … [Read more...] about Oracle Database: How to catalog tape backup pieces
RMAN
How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database
Question: Our rman catalog database is 11.2.0.3 right now, do I need to upgrade the database to 12.1.0.2 first, and then upgrade the catalog to 12.1.0.2? The version of the RMAN catalog database does not need to match that of the recovery catalog. Therefore you can upgrade the RMAN catalog without upgrading the RMAN database. This is true of any version of the database, not only 12c. If you are intending to upgrade the catalog schema to 12c then you need to run these 2 … [Read more...] about How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database
Oracle RMAN Pluggable Database Point in Time Recovery
Point in time recovery of a Pluggable Database (from hereon referred to as a PDB) requires ALL files including UNDO to be restored and recovered to the specified time. As all PDBs write to the ROOT UNDO tablespace, point in time recovery of a PDB will use an auxiliary instance and will restore the CDB$ROOT UNDO, SYSTEM, SYSAUX, and SYSEXT tablespaces into the ROOT of the auxiliary instance. The datafiles of the PDB itself are restored and recovered in-situ. The auxiliary database is created … [Read more...] about Oracle RMAN Pluggable Database Point in Time Recovery
Oracle RMAN 12c – New Features
This post provides information on enhancements available in RMAN within Oracle 12c. Support for Container and Pluggable Databases RMAN in 12c provides full backup and recovery support for a Pluggable Database environment. You can perform the backup of the entire container database (CDB), either full or using an incremental backup strategy, or one/many pluggable databases (PDB). SYSBACKUP Privilege In 12c, Oracle support for separation of database administration (DBA) duties by … [Read more...] about Oracle RMAN 12c – New Features
RMAN Restore/Duplicate Performs Implicit Crosschecking and Cataloging
The Problem After restoring a controlfile, the restore database can take a long time to restore due to implicit croscchecking and cataloging. RMAN> restore database; RMAN-03090: Starting implicit crosscheck backup at 2012/10/05 01:56:55 RMAN-08030: allocated channel: ORA_DISK_1 RMAN-08500: channel ORA_DISK_1: SID=63 device type=DISK RMAN-06206: Crosschecked XXXX objects ------> Time taken Time taken Time taken list incarnation of database; List of … [Read more...] about RMAN Restore/Duplicate Performs Implicit Crosschecking and Cataloging
Oracle RMAN interview questions
General RMAN Questions What is RMAN and How to configure it? RMAN is an Oracle Database client that performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies the dba jobs by managing the production database's backing up, restoring, and recovering database files. This tool integrates with sessions running on an Oracle database to perform a range of backup and recovery activities, including maintaining an RMAN … [Read more...] about Oracle RMAN interview questions
How to Move/Restore Oracle Database to New Host and File System using RMAN
You may need to restore a database to a new server due to the following reasons: confirming your disaster recovery strategy cloning a database to a new server for UAT or or PRE-PRODUCTION moving the database to a new server This post will work for all file systems - ASM, OCFS, raw, cooked etc. The steps can be summarised as: take a backup of the database on the existing host on the new host, restore the controlfiles, datafiles and tempfiles to the new location on the new host, … [Read more...] about How to Move/Restore Oracle Database to New Host and File System using RMAN
Oracle Interview Questions : Recovery catalog for RMAN backup
Why use a recovery catalog? The RMAN catalog has several benefits. It makes restore if all the target database is lost, including the controlfile. As that controlfile contains all backup information, the catalog would then be used to identify a controlfile backup. If an RMAN catalog is not used, the controlfile autobackup should be configured to ON. There are some features which are only supported using an RMAN catalog. Primarily the ability to store scripts which would be available to all … [Read more...] about Oracle Interview Questions : Recovery catalog for RMAN backup
Running RMAN DUPLICATE / RESTORE on a different version than source database version.
The Problem 1. RMAN DUPLICATE fails as below: input datafile copy recid=22 stamp=717598749 filename=/temp_datavol/clone_files/DUPTEST1/datafile/largetbl.298.684694005 datafile 24 switched to datafile copy input datafile copy recid=23 stamp=717598749 filename=/temp_datavol/clone_files/DUPTEST1/datafile/audittbl.449.690377511 datafile 25 switched to datafile copy input datafile copy recid=24 stamp=717598750 … [Read more...] about Running RMAN DUPLICATE / RESTORE on a different version than source database version.
Oracle RMAN: Monitoring Recovery Manager Jobs
Sometimes it is useful to identify what a server session performing a backup or copy operation is doing. You have access to several views that can assist in monitoring the progress of or obtaining information about RMAN jobs: ViewDescription V$PROCESSIdentifies currently active processes. V$SESSION Identifies currently active sessions. Use this view to determine which Oracle database server sessions correspond to which RMAN allocated channels. V$SESSION_LONGOPSProvides progress … [Read more...] about Oracle RMAN: Monitoring Recovery Manager Jobs