creating rman catalog

Here creating orcl as a catalog database madhu as catalog user rman01 catalog tablespace

other than that


CREATE TABLESPACE RMAN01 DATAFILE 'F:\oracle\product\10.1.0\oradata\orcl\RMAN01.DBF' SIZE

100M REUSE AUTOEXTEND ON;

CREATE USER madhu IDENTIFIED BY madhu
DEFAULT TABLESPACE RMAN01 TEMPORARY TABLESPACE TEMP;

GRANT CONNECT, RESOURCE, RECOVERY_CATALOG_OWNER TO madhu;

C:\Documents and Settings\Administrator>set oracle_sid=orcl

C:\Documents and Settings\Administrator>rman catalog madhu@orcl

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

recovery catalog database Password:
connected to recovery catalog database
recovery catalog is not installed

RMAN> CREATE CATALOG TABLESPACE RMAN01;

recovery catalog created
----------------------------------------------------------------------------------------
once it created we need to register the target database;

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

C:\Documents and Settings\Administrator>set oracle_sid=hp

C:\Documents and Settings\Administrator>set oracle_sid=hp

C:\Documents and Settings\Administrator>RMAN TARGET / CATALOG madhu/madhu@orcl

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: HP (DBID=3130092004)
connected to recovery catalog database

RMAN>  REGISTER DATABASE;

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


RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'F:\hpback\%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\S
NCFHP.ORA'; # default

RMAN>