Oracle Recovery Manager Oracle Database provides RMAN for backing up and restoring the database. RMAN enables you to back up, restore, and recover data files, control files, SPFILEs, and archived redo logs. You can run RMAN from the command line or you can use it from the Backup Manager in Enterprise Manager. In addition, RMAN […]
RMAN
Oracle Database: How to catalog tape backup pieces
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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 filename=/temp_datavol/clone_files/DUPTEST1/datafile/largetbl.988.713432115 contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script Segmentation fault The […]