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
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
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.
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
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, if not longer. Therefore, if your backup took 10 hours to complete, it will take at least 10 hours to restore to the same host. Another good indicator is to determine the … [Read more...] about Beginners Guide to Monitoring Oracle Database Restore/Recovery Progress
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 … [Read more...] about TSPITR fails With RMAN-06553