I'm trying to create a recovery catlog and I get the following error message. Do you see what is wrong with instruction: (oracle version 8.1.5)
Recovery Manager: Release 188.8.131.52.0 - Production
RMAN-06005: connected to target database: SOLDB (DBID=2945300576)
RMAN> create catalog tablespace rman_ts;
== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-06002: command not allowed when not connected to a recovery catalog
Recovery Manager complete.
The Insructions I use are:
1. Create tablespace rman_ts
2. create user rman_dba
3. Grant the following permissions:
grant recovery_catalog_owner to rman_dba;
grant connect, resource to rman_dba;
4. Create rman catalog:
rman target rman_dba/rman_dba msglog=catalog.log
create catalog tablespace rman_dba;
and get the above error message.
Do you anything wrong
5. register the database for the catalog
From RMAN first try to connect to catalog.
RMAN>connect catalog rman_dba/password@connect_string
RMAN>create catalog tablespace rman_ts
What is the result?
The problem was that I registered once before. For new registration you should create e new user and register by that name.
Because you have already registered once just unregister it using the
dbms_rcvcat.unregisterdatabase procedure using Values you query from db;
You can just use
Rman> Create catalog;
without specifying the tablespace . It worked for me.
I dont think you have to create another user...
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Click Here to Expand Forum to Full Width