The Problem Received below error while restoring COLD backup of source database using RMAN at target server. RMAN> run{ 2> restore database; 3> } Starting restore at 07-SEP-16 RMAN-06908: WARNING: operation will not run in parallel on the allocated channels RMAN-06909: WARNING: parallelism require Enterprise Edition allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=391 device type=DISK released […]
RMAN
How does the RMAN Retention Policy Obsolete Incremental Backupsets
The report/delete obsolete commands works in two steps. First, we identify the oldest full backup (i.e. full or level 0 backupset, or image copy) of every file that is not obsolete, as defined by the retention policy (either REDUNDANCY or RECOVERY WINDOW). Every older full backup is obsolete. Then, all archived logs and level > […]
How do we Set A Retention Policy For Tape Backups And Disk Backups Differently
Question: How do we Set A Retention Policy For Tape Backups And Disk Backups Differently? For example, setting the tape retention policy to 14 days while setting it to 3 days for the disk backups. Step 1: Set the retention policy. RMAN currently only allows one retention policy. The retention policy should be set to […]
RMAN backup Concepts for Oracle RAC
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 […]
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 […]