Home » RDBMS Server » Backup & Recovery » Unable to register database in recovery catalog in RMAN (10.2.0.3.0)
Unable to register database in recovery catalog in RMAN [message #422097] Mon, 14 September 2009 07:06 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

I have created catalog database for taking RMAN backup pieces.
This database is created manually and version is 10.2.0.3.0

Then i tried to connect to database of version 10.2.0.4.0(on other server), but when connected to this server it giva message as:

rman target / catalog=rman/rman@rman

connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.03 in RCVCAT database is not current

OS - Sun Solaris


When tried to register in catalog database, it gave as:
RMAN> register database;

database registered in recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 0 on line 2138 column 12: Statement ignored
RMAN-10014: PL/SQL error 306 on line 2138 column 12: wrong number or types of arguments in call to 'CHECKPROXYARCHIVEDLOG'
RMAN-10014: PL/SQL error 0 on line 1970 column 12: Statement ignored
RMAN-10014: PL/SQL error 306 on line 1970 column 12: wrong number or types of arguments in call to 'CHECKBACKUPREDOLOG'
RMAN-10014: PL/SQL error 0 on line 1810 column 12: Statement ignored
RMAN-10014: PL/SQL error 306 on line 1810 column 12: wrong number or types of arguments in call to 'CHECKBACKUPREDOLOG'
RMAN-10014: PL/SQL error 0 on line 1618 column 15: Statement ignored
RMAN-10014: PL/SQL error 306 on line 1618 column 15: wrong number or types of arguments in call to 'CHECKARCHIVEDLOG


Can anybody help me out,what should i have to do now????
Re: Unable to register database in recovery catalog in RMAN [message #422102 is a reply to message #422097] Mon, 14 September 2009 07:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.03 in RCVCAT database is not current

You need to upgrade.
Re: Unable to register database in recovery catalog in RMAN [message #422103 is a reply to message #422102] Mon, 14 September 2009 07:36 Go to previous messageGo to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

thanks for your reply,

But i have little confusion,

My catalog database is on 10.2.0.3.0,

My other database (target) is on 10.2.0.4.0

Both database are on different solaris server.

Shall i have to fire command by connecting in 10.2.0.4.0 server
and from here fireing command like :
rman target / catalog=rman/rman@rman
RMAN>upgrade catalog;(twice have to fire it)

My that little confusion is that,
Will my catalog version of existing database on 10.2.0.3.0(other than the catalog, which is already there before creating catalog)
is also get affected??





Re: Unable to register database in recovery catalog in RMAN [message #422123 is a reply to message #422103] Mon, 14 September 2009 09:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Upgrade catalog from RMAN prompt will affect only the rman catalog.
Re: Unable to register database in recovery catalog in RMAN [message #422135 is a reply to message #422123] Mon, 14 September 2009 10:23 Go to previous message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

Thanks,
It works.




Previous Topic: Partial schema replication without DBA privs
Next Topic: recovery Of the database when a data file of undo table-space is deleted (merged 3)
Goto Forum:
  


Current Time: Fri Mar 29 08:55:04 CDT 2024