11g Standby database creation without any RMAN backups

Posted by Gavin Soorma
On December 4, 2009
1 Comments

Quick steps to set up a 11g Standby database with Active Data Guard using the Active Duplication feature available in 11g where we can create a standby database without having to take a backup on the primary database. Datafiles are copied over the network. Primary machine – OATU036 Standby machine – DROU036 Database Name – […]

Posted by Gavin Soorma
On December 1, 2009
0 Comments

In Oracle 11g, we can grant restricted access to the RMAN catalog to some users so that they can only access a limited set of databases that are registered in the RMAN catalog. This is done by creating a Virtual Private Catalog which in turn will grant a particular user read/write access to only that […]

Posted by Gavin Soorma
On September 22, 2009
0 Comments

We can now use SQL*PLUS type substitution variables in RMAN like &1, &2 and so on and the same can be linked to shell scripts as shown below with the new clause USING where we are passing the Incremental Level and the backup tag to the actual RMAN command. Also note that in 11g we […]

Posted by Arjun Raja
On June 25, 2009
1 Comments

USING RMAN REPAIR ADVISOR: Export ORACLE_SID=test1 sqlplus “sys as sysdba” Shutdown immediate. Go to c:\app\bb16872\test1 and rename SYSTEM01.DBF to SYSTEM01.old Next try to startup database…will fail with error that SYSTEM01.DBF is missing. Y:\>rman target / Recovery Manager: Release 11.1.0.6.0 – Production on Wed Apr 30 10:51:03 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. […]

News

11g Standby database creation without any RMAN backups

11g RMAN Virtual Private Catalog

11g RMAN Substitution Variables

11g RMAN REPAIR ADVISOR