RMAN configuration for oracle database backup

 1)Enable archive log

SQL> Conn sys/<pass>@TargetDB as sysdba;

SQL> Shut immediate;

SQL> Startup mount;

SQL> alter database archivelog;

SQL> alter database open;

SQL> archive log list;

2)Create RECO database and create user:

SQL> Conn sys/<pass>@RECODB as sysdba;

SQL> CREATE USER rman IDENTIFIED BY cat

TEMPORARY TABLESPACE temp

DEFAULT TABLESPACE users

QUOTA UNLIMITED ON users;  2    3    4

User created.

SQL> GRANT RECOVERY_CATALOG_OWNER TO rman;

Grant succeeded.

SQL> grant select on v_$instance to rman;

Grant succeeded.

SQL>

3)Create Recovery Catalog

C:\Users\Administrator>rman catalog rman/cat@RECODB

RMAN>  create catalog;

recovery catalog created

RMAN> connect target sys/dba@ORCL

connected to target database: ORCL (DBID=1702363306)

3)Register Recovery Catalog to database

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> exit