Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rman Configuration Steps

879605Sep 7 2011 — edited Sep 8 2011
Hi ,

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;
This post has been answered by Kamran Agayev A. on Sep 8 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2011
Added on Sep 7 2011
4 comments
226 views