Job output is no longer available

Tomas Helgi Johannsson
Tomas Helgi Johannsson used Ask the Experts™
on
Hi!

I did a planned switchover between primary and standby databases for maintenance reasons on the primary database. After that was done I issued a switchover to the orginal primary standby setup. Both actions went smoothly.
However when I looked into the BackupReports in the EM console (web) I noticed that instead of a regular job-output every backup has this in the job-output window : "Job output is no longer available in the database control file."
We are running Oracle 10.2.0.3.
What can have happend ? I don't see any errors in the alert.log pointing at the control file.
Please help.

Regards,
    Tomas Helgi
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Geert GOracle dba
Top Expert 2009

Commented:
do the standby and primary database have the same dbid ?

select dbid from v$database

the standby database is possibly not registered in the rman catalog
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Author

Commented:
Yes, they have the same dbid.

Regards,
    Tomas Helgi
Geert GOracle dba
Top Expert 2009

Commented:
can you connect with rman to the db and catalog from both databases ?

and also try a resync catalog ?
http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta052.htm#sthref834
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Database Administrator / Software Engineer
Commented:
Well I think I solved this.
This is most likely related to this BUG found in Metalink - 4659734
Solved temporarly by doing some obsolete cleanup in rman :)

Regards,
    Tomas Helgi
Geert GOracle dba
Top Expert 2009

Commented:
um yea, 10.2.0.3 has some rman bugs in it

you can also apply 4 or 5 fixes to speed things up
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Author

Commented:
That's now on my todo list :)

Regards,
    Tomas Helgi
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Author

Commented:
As stated in the comment then most likely we hit this bug 4659374 in Metalink.
And temporary solution was to do some backup cleanup :)

Regards,
    Tomas Helgi

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial