Solved

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

Posted on 2004-03-26
1
572 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
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

786 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