Recovery Catalog Creation

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 19 13:15:11 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba;
Connected.
SQL> create tablespace rman datafile 'E:\oracle\oradata\kumar\rman01.dbf' size 5
0m;

Tablespace created.

SQL>


SQL> create user tinku identified by kumar
  2  default tablespace rman
  3  quota unlimited on rman;

User created.

SQL> grant connect,resource to tinku;

Grant succeeded.

SQL> grant recovery_catalog_owner to tinku;

Grant succeeded.

SQL>




Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>rman target / catalog tinku/kumar

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: KUMAR (DBID=1996409166)
connected to recovery catalog database
recovery catalog is not installed

RMAN> create catalog;

recovery catalog created

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete


RMAN> backup database;

Starting backup at 19-FEB-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=15 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=16 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=E:\ORACLE\ORADATA\KUMAR\EXAMPLE01.DBF
input datafile fno=00011 name=E:\ORACLE\ORADATA\KUMAR\RMAN01.DBF
input datafile fno=00010 name=E:\ORACLE\ORADATA\KUMAR\XDB01.DBF
input datafile fno=00003 name=E:\ORACLE\ORADATA\KUMAR\CWMLITE01.DBF
input datafile fno=00007 name=E:\ORACLE\ORADATA\KUMAR\ODM01.DBF
channel ORA_DISK_1: starting piece 1 at 19-FEB-10
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00002 name=E:\ORACLE\ORADATA\KUMAR\UNDOTBS01.DBF
input datafile fno=00006 name=E:\ORACLE\ORADATA\KUMAR\INDX01.DBF
input datafile fno=00009 name=E:\ORACLE\ORADATA\KUMAR\USERS01.DBF
input datafile fno=00004 name=E:\ORACLE\ORADATA\KUMAR\DRSYS01.DBF
input datafile fno=00008 name=E:\ORACLE\ORADATA\KUMAR\TOOLS01.DBF
channel ORA_DISK_2: starting piece 1 at 19-FEB-10
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=E:\ORACLE\ORADATA\KUMAR\SYSTEM01.DBF
channel ORA_DISK_3: starting piece 1 at 19-FEB-10
channel ORA_DISK_2: finished piece 1 at 19-FEB-10 with 3 copies
piece handle=E:\ORACLE\ORA92\DATABASE\03L6DIB3_1_1 comment=NONE
piece handle=E:\ORACLE\ORA92\DATABASE\03L6DIB3_1_2 comment=NONE
piece handle=E:\ORACLE\ORA92\DATABASE\03L6DIB3_1_3 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:30
channel ORA_DISK_1: finished piece 1 at 19-FEB-10 with 3 copies
piece handle=E:\ORACLE\ORA92\DATABASE\02L6DIB3_1_1 comment=NONE
channel ORA_DISK_3: finished piece 1 at 19-FEB-10 with 3 copies
piece handle=E:\ORACLE\ORA92\DATABASE\04L6DIB3_1_1 comment=NONE
piece handle=E:\ORACLE\ORA92\DATABASE\02L6DIB3_1_2 comment=NONE
piece handle=E:\ORACLE\ORA92\DATABASE\04L6DIB3_1_2 comment=NONE
piece handle=E:\ORACLE\ORA92\DATABASE\02L6DIB3_1_3 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:47
piece handle=E:\ORACLE\ORA92\DATABASE\04L6DIB3_1_3 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:01:47
Finished backup at 19-FEB-10

RMAN>