RMAN ? create catalog?

Printable View

03-29-2001, 04:29 PM
jlakhani

Hello. Before I was create RMAN for 8.05. I just installed 8.1.6 and got into the process of create rman. According to rman docs you have to run catrman.sql but in 8.1.6 cat rman doesnt exist. oracle note says to just create catalog command and I have referenced the backup/recovery guide for 8.1.6 and I cannot locate this create catalog. Anybody have the syntax?

thanks
Jigar
03-29-2001, 04:49 PM
bond_007

I need to create rman for 8.0.5. Any information with be greatly appreciated

Thanks,
Bond..
03-29-2001, 04:51 PM
chikkodi

I just did this yesterday, so its fresh in my memory !

%set ORACLE_SID=rmandb
%rman catalog rman/rmanpassword

rman>create catalog

Hope this helps
03-29-2001, 05:24 PM
dragon99

I did on 8.1.5
RMAN>connect catalog rman/rman@sid(which is different from the database you are going to backup)
RMAN>create catalog tablespace rcvcat;

Dragon
03-29-2001, 05:33 PM
jm

to use rman
805 you have to run catrman.sql
81x you don't need, just run rman
03-29-2001, 08:55 PM
oraka6

Create catalog

Here's what I had done, but it's in version 8.1.5.

1 CREATE TABLESPACE rman_ts DATAFILE 'd:\oratestdb\orafiles\rman_01.dbf'
2* SIZE 10M autoextend on next 10M maxsize 30M;

1 CREATE USER rman IDENTIFIED BY rman
2 TEMPORARY TABLESPACE temp
3 DEFAULT TABLESPACE rman_ts
4* QUOTA UNLIMITED ON rman_ts
SQL> /

User created.

SQL> GRANT recovery_catalog_owner TO rman;

Grant succeeded.

SQL> GRANT connect, resource TO rman;

Grant succeeded.
*****************************

D:\>rman

Recovery Manager: Release 8.1.5.0.0 - Production

RMAN> CREATE CATALOG tablespace rman_ts;

RMAN-06431: recovery catalog created

HTH.