RMAN

Richard_Williams_Jr:
Here is the detailed procedure stepwise:

I have created a database to be my repository, I named it MyRepos. The following are the steps I used:

c:\set oracle_sid=MyRepos
c:\sqlplus /nolog
c:\connect sys as sysdba
sql>create user me identified by me;
"user created"
sql>grant recovery_catalog_owner to me;
"grant succeded"

--->it's ok so far, but you can avoid caommand "set oracle_sid=MyRepos" back and forth , instead use the full connnection string, something like "connect sys/password@<oracle_sid> as sysdba".
--->comment 2: also make sure that user "ME" have a separate default tablespace (necessary to avoid system tablespace fragmentation) and temp tablespace..
---->if "recovery_catalog_owner" is the only privilege you granted to user "me", you should also assign "connect, resource, create session' to "ME".



I then execute the exit command once to get to the c prompt. Next:
c:\set oracle_sid=MyRepos "to ensure I'm connected to MyRepos," next:
c:\rman

---->problems here. In order to connect to RMAN repository , you should use

--->c:\rman catalog=me/me@MyRepos

rman>create catalog "I do this because I know rcvcat and rcvman have not been installed.", next:


"Here I recieve the message that the command is illegal because I'm not connected to the recovery catalog, I do not understand this because it is the recovery catalog I'm trying to create.", next:


----> basically correct here... but you can specify the tablespace you want your repository to be...if you use the follwoing command:
----->create catalog tablespace "some tablespace but NO system tablespace"
------>after you create the catalog , you can exit the rman here
------>RMAN>exit
Recovery Manager complete.


"I would have continued this way", next:
c:\set oracle_sid=targetdb

--->unnecessary again, you should continue on in the RMAN window, you don't need to switch ORACLE_SID in the dos window


c:\rman rcvcat username/password@targetdb target /

------>wrong command , oracle9i does not use "rcvcat" any more

------>new, correct command and fulll connection string , replace <rman_catalog_db_sid>
 ----->and <backup_target_db_sid> with the real sid in your setting.
------->C:\rman catalog me/me@<rman_catalog_db_sid>      target sys/password@<backup_target_db_sid>


rman>register database

------>no problem


Where have I made a mistake. The Oracle release I'm using is Oracle 9.2
Thanks

you should be seeing all the good, happy message from oracle now.....