SQL> create tablespace rman_cat datafile 'C:\oracle\product\10.2.0\oradata\cat\rman_cat01.DBF' SIZE 100M;
Tablespace created.
SQL> create user munna
identified by munna
default tablespace rman_cat
temporary tablespace temp;
User created.
SQL> grant connect,resource,recovery_catalog_owner to munna;
Grant succeeded.
RMAN> connect catalog munna/munna@cat
connected to recovery catalog database
RMAN> create catalog tablespace rman_cat
recovery catalog created
C:\>rman target sys/sys@dba20 catalog munna/munna@cat
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 12 16:08:21 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DBA20 (DBID=847839442)
connected to recovery catalog database
RMAN> run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database;
}
RMAN> report schema;
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
If any physical structure changes in target database then this command required for resynchronization.
RMAN> reset database;
database incarnation already registered
This command required only when incomplete recovery occurred in target database.
SQL> shutdown immediate;
Database closed.
Database dismounted.
Delete some Datafile
SQL> startup;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 75498876 bytes
Database Buffers 83886080 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\SYSTEM01.DBF'
C:\>rman target sys/sys@dba20 catalog munna/munna@cat
RMAN> run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
restore database;
recover database;
}
SQL> alter database open;
Database altered.