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 […]
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 […]
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 […]
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: View Description V$PROCESS Identifies currently active processes. V$SESSION Identifies currently active sessions. Use this view to determine […]
Beginners Guide to Monitoring Oracle Database Restore/Recovery Progress
In an production environment, it is a common task to take backup and restore it using RMAN. So it is important to know the Tips and techniques for monitoring a restore/recovery operation and determine whether it is indeed working, slow or hung. In general, a restore should take approximately the same time as a backup, […]
TSPITR fails With RMAN-06553
The Problem TSPITR fails With RMAN-06553 when the tablespace (using OMF files) is dropped including contents and datafiles: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/22/2015 16:43:08 RMAN-03015: error occurred in stored script Memory Script RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME … TO […]
Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN
This post covers the detailed steps for creating a physical standby database on a normal file system using RMAN for a primary database in ASM. Overview Here the Standby database can be created using the following 2 methods: Normal Restore and Recovery using RMAN. Creating a Duplicate database for Standby using RMAN. Method 1 Perform […]
How to Create a Physical Standby from ASM Primary
The Setup This post offers step by step procedure to create physical standby from ASM primary. Database Name: chicago Primary db_unique_name: chicago standby db_unique_name: boston Primary Hostname: prim.example.com standby Hostname: stdby.example.com Steps 1. Enable Force Logging: SQL> ALTER DATABASE FORCE LOGGING; Database altered. 2. On the primary node, create a staging directory. For example: [oracle@prim […]
How To Catalog Backups / Archivelogs / Datafile Copies / Controlfile Copies in Oracle Database
The RMAN CATALOG command is used to accomplish the following: Add backup pieces and image copies on disk to the RMAN repository. Record a datafile copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy. Record the existence of the last […]
RMAN: SET NEWNAME Command Using SQL
When you must restore the database the same directory structure is not always available. If you have a database containing 1000s of datafiles it can be very tedious to setup the set newname commands for all the datafiles. Using sqlplus we can extract the information we need into a file which can then be easily […]