rman catalogt: how to register and check registration of a DB? [message #407982] |
Fri, 12 June 2009 12:23 |
Mast
Messages: 5 Registered: June 2009
|
Junior Member |
|
|
Ipm having a problem in a customer with oracle databases and backusp, i'm a total newbie concerning oracle bu since i'm at the site i need to get this solved now, here it goes:
Server1 has the rman catalog instance named "rmanrep"
sysdba user and rmanrep owner is "userA"
server2 has the database to backup called "mountain"
sysdba is "userB"
I want to check and register the "mountain" database with the rman catalog, so doing some reading i got to:
Execute:
ORACLE_SID=mountain; export ORACLE_SID
then
rman target / catalog userA/[password userA]@rmanrep
it connects succesfully showing the DBSID and all,
then i do: list backup of database;
and fails with:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 06/12/2009 13:31:38
RMAN-06428: recovery catalog is not installed
if i try to do a "register database;" i get the same error.
What am i doing wrong?, how do i check if it's registered and how do i register it?(it doesn't help that i'm not too familiar with the oracle terminology hence i posted the names so that you can give me a hand).
thanks in advance
whi
|
|
|
|
Re: rman catalogt: how to register and check registration of a DB? [message #407985 is a reply to message #407982] |
Fri, 12 June 2009 13:05 |
Mast
Messages: 5 Registered: June 2009
|
Junior Member |
|
|
Thanks a million Rahesh!
i followed the instructions and first it returned "recovery catalog already exists"(which is ok as it does exist).
so i went and followed to register the database(connected with sqlplus on serverB) and what do you know! it registered!(i could swear i tired to do the exact same thing previously whilst inkering and it failed).
Anyway, now to continue with the main course of action....
|
|
|
|
Re: rman catalogt: how to register and check registration of a DB? [message #408553 is a reply to message #407994] |
Tue, 16 June 2009 14:25 |
Mast
Messages: 5 Registered: June 2009
|
Junior Member |
|
|
Babu,
i'm not at the site right now, but according to what i've said in the original post(i think), the recovery catalog was already created and populated, the only thing missing was that the instance i was sitting on wasn't registered in it
what i did was a:
RMAN> REGISTER DATABASE;
and with that the DB registered and everything worked ok
|
|
|
|