Solved

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

Posted on 2004-03-26
1
577 Views
Last Modified: 2013-12-11
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
Comment
Question by:GnarlyGuy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

by:
baonguyen1 earned 125 total points
ID: 10687948
GnarlyGuy, you have to issue "CREATE CATALOG" from RMAN command prompt, not in SQL*plus :

RMAN>create catalog;

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle differnce between two timestamps 5 53
PL/SQL: ORA-00979: not a GROUP BY expression 3 84
Performance Issue in Oracle 3 48
Oracle SQL_Error . 7 24
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question