Home » RDBMS Server » Backup & Recovery » SYS.DBMS_BACKUP_RESTORE in TARGET database is not current
SYS.DBMS_BACKUP_RESTORE in TARGET database is not current [message #245715] Mon, 18 June 2007 11:11 Go to next message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
Hi All,

I just upgrade my rman catalog database to 10.2.0.3. I dropped the catalog and recreated it because nothing was in there, I'm still setting up the catalog.

After I created the catalog I registered a database but I got following messages:

rman catalog rman/<password> target sys/<password>@gvpdbacc

Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jun 18 18:04:50 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.02 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 10.02.00.02 in TARGET database is not current
connected to target database: GVPDBACC (DBID=2781514934)
connected to recovery catalog database


The target database is a 10.2.0.2 database, I just wonder do these messages harm or should I just ignore them? Upgrading the target database is not an option.

Regards,
Martin


icon5.gif  Re: SYS.DBMS_BACKUP_RESTORE in TARGET database is not current [message #251356 is a reply to message #245715] Fri, 13 July 2007 03:08 Go to previous messageGo to next message
perrierp
Messages: 1
Registered: July 2007
Location: Toulouse - FRANCE
Junior Member
Hi,
I have exactly the same problem.
Does anybody has a solution Question ?
regards
Pascal
Re: SYS.DBMS_BACKUP_RESTORE in TARGET database is not current [message #254743 is a reply to message #251356] Fri, 27 July 2007 15:30 Go to previous messageGo to next message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
I found by documentation the target database should be backed up with the same rman client version as the oracle database version.
In fact there is an copatabilitie matrix somewhere in the rman documentation about this.

Oracle advises to use the rman client in the oracle home of the database, so use the rman executable on the database server and connect with it to the catalog.
Re: SYS.DBMS_BACKUP_RESTORE in TARGET database is not current [message #256221 is a reply to message #254743] Fri, 03 August 2007 08:05 Go to previous messageGo to next message
milledj
Messages: 1
Registered: August 2007
Location: Athens, AL
Junior Member
Hm...attempting to use RMAN on my database server results in a hung session.

(I get the same original error from my OAS server)
Re: SYS.DBMS_BACKUP_RESTORE in TARGET database is not current [message #256325 is a reply to message #256221] Fri, 03 August 2007 16:52 Go to previous message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
this is how it should work.

1.on the target database server make sure you're able to connect to the rman repos. database
2.on the target database connect with the repos:
export ORACLE_SID=<your sid>
rman target / catalog catalog_owner/password@net_service_name
3.RMAN> register database.

Now you should be able to backup your database.
I've seen a hang ones before while registering the database.
I unregistered the database and reregistered it again and it works fine.

regards,
Martin
Previous Topic: RMAN error
Next Topic: central catalog management with RMAN
Goto Forum:
  


Current Time: Wed May 15 22:19:02 CDT 2024