• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • Last Modified:

How do I create a catalog to use with the 9i recovery manager?

Hi Oracle Expert...
I have set up the RMAN account with the recovery_catalog_owner role, default tablespace is TOOLS, temporary tablespace is TEMP.  

I login to SQL Plus with the RMAN account.

My impression of the literature is that in SQL Plus, all I have to do is type CREATE CATALOG; at the SQL> prompt and it should set up the CATALOG in RMAN's default tablespace.  I get on error ORA-00901: invalid CREATE command.

Is there syntax that I require to complete this command?

Thanx,

TH
0
GnarlyGuy
Asked:
GnarlyGuy
1 Solution
 
baonguyen1Commented:
GnarlyGuy, you have to issue "CREATE CATALOG" from RMAN command prompt, not in SQL*plus :

RMAN>create catalog;

0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now