GnarlyGuy
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.