Rman Configuration Steps
879605Sep 7 2011 — edited Sep 8 2011Hi ,
This first time to me to applying RMAN on Oracle DB , I'm already reading some papers and watching some videos and do like below without alert ,
I would appreciate checking the steps below for me , cause I'm not sure from what I doing , and if that enough to me or not or If I missed some thing ?
--1-
create user rcat_orcl identified by orcl123;
--2- -
grant connect,resource,recovery_catalog_owner to rcat_orcl;
--3-
create tablespace rcat_orcl datafile '/u01/app/oracle/oradata/orcl/rcat_orcl0.dbf'
Size 2G
autoextend on MAXSIZE UNLIMITED;
--4--
alter user rcat_orcl default tablespace rcat_orcl;
--5--
alter user rcat_orcl quota unlimited on rcat_orcl;
--6--
$ rman catalog=rcat_orcl/orcl123@orcl
--7 ---
RMAN> CREATE CATALOG;
--8
SQL> SELECT table_name from dba_tables where tablespace_name='RCAT_ORCL';
SQL> SELECT VIEW_name from dba_views where view_name like 'RC%';
--9--
$ rman target / catalog=rcat_orcl/orcl123@orcl
--10--
RMAN> REGISTER DATABASE;
--11--
sql> desc rcat_orcl.rc_database;
SQL> select name from rcat_orcl.rc_database;
--12---
$ rman target / catalog=rcat_orcl/orcl123@orcl
RMAN> backup database;