Step by Step RMAN Recovery Catalog Creation and Configuration in Windows Oracle

SQL> select name,log_mode from V$database;

NAME      LOG_MODE
--------- ------------
ORCL      ARCHIVELOG



SQL> select name from V$datafile;

NAME
--------------------------------------------------------------------------------

E:\APP\HONNIKERY\ORADATA\ORCL\SYSTEM01.DBF
E:\APP\HONNIKERY\ORADATA\ORCL\SYSAUX01.DBF
E:\APP\HONNIKERY\ORADATA\ORCL\UNDOTBS01.DBF
E:\APP\HONNIKERY\ORADATA\ORCL\USERS01.DBF
E:\APP\HONNIKERY\ORADATA\ORCL\EXAMPLE01.DBF


SQL> create tablespace rman datafile 'E:\APP\HONNIKERY\ORADATA\ORCL\rman.dbf'
  2  size 1000m  reuse autoextend on ;

Tablespace created.


SQL> create user rman identified by rman default tablespace
  2  rman temporary tablespace temp;

User created.



SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

SQL>