Oracle Version 10.2.0.1
Tested on Windows XP
Create catalog mandatory steps:
1. Create tablespace
2. Create owner
3. Grant privileges
4. Create Catalog
5. Connect to the database
6. Register the database
Step2
=====
create user rman identified by rman
default tablespace RMAN
quota unlimited on RMAN;
Step3
=====
grant recovery_catalog_owner to rman;
grant connect, resource to rman;
Step4
=====
C:\>rman catalog rman/rman@rman
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Mar 8 12:40:03 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> create catalog tablespace "RMAN";
recovery catalog created
C:\>rman target sys/oracle@orcl
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Mar 8 14:49:10 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1144457296)
RMAN> connect catalog rman/rman@rman
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
