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
RMAN
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, 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
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 … [Read more...] about TSPITR fails With RMAN-06553
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 the backup of the ASM primary database ( Datafiles, Controlfile for standby and Archivelogs ) Make the backup pieces available on the Standby … [Read more...] about Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN
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 ~]$ mkdir –p /home/oracle/stage 3. Create the same exact … [Read more...] about How to Create a Physical Standby from ASM Primary
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 user-managed datafile copies made after the final shutdown. Restrictions and Usage Notes You must be connected to the target database, which must be mounted or open. If RMAN … [Read more...] about How To Catalog Backups / Archivelogs / Datafile Copies / Controlfile Copies in Oracle Database
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 modified and executed as an RMAN script to complete the task. Oracle 11g New Command - 'SET NEWNAME FOR DATABASE' Starting from 11.2, we can use SET NEWNAME FOR DATABASE clause to … [Read more...] about RMAN: SET NEWNAME Command Using SQL
Script to monitor RMAN Backup and Restore Operations
RMAN is designed to complete a backup or restore as quikly and efficiently as possible. But if a job takes longer than expected to complete it can be confusing trying to determine: What precisely is RMAN doing at any particular time? Is RMAN hung or just slow? How far into the backup/restore has it got? How much more work is there to go? Knowing just how much processing has been done so far is often crucial when trying to decide whether or not to wait for job completion. RMAN … [Read more...] about Script to monitor RMAN Backup and Restore Operations
Oracle RMAN Backup Shell Script Example
Pre-requisites 1. Create a catalog database (rmancat) if one does not exist. (With additional UNDO-, USERS- and TEMP-tablespaces) 2. Configure SQL*Net to handle the catalog (rmancat) and the 'target' database connections. 3. Create a user 'RMAN' in the catalog database. SQL> create user rman identified by rman default tablespace USERS quota unlimited on users temporary tablespace TEMP; SQL> grant recovery_catalog_owner to rman; 4. Create the RMAN-catalog in the … [Read more...] about Oracle RMAN Backup Shell Script Example
Upgrading to Oracle 12c using RMAN DUPLICATE with “NOOPEN” clause and “BACKUP LOCATION”
When cloning (duplicating) a database to a higher version, traditionally (prior to 12c), you must use restore/recover of an RMAN backup. This is because the database in the destination must be opened with UPGRADE option. Therefore, the RMAN duplicate could not be used because RMAN automatically opens the auxiliary database with resetlogs. This would fail with error 'ORA-39700: database must be opened with UPGRADE option'. In RMAN 12c, a new option is available "NOOPEN" requesting RMAN to … [Read more...] about Upgrading to Oracle 12c using RMAN DUPLICATE with “NOOPEN” clause and “BACKUP LOCATION”