How do I create a catalog to use with the 9i recovery manager?
Posted on 2004-03-26
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?