OTN Discussion Forums : Grid Control and Rman Catalog ...

This question is answered. Helpful answers available: 5. Correct answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

Replies: 3 - Pages: 1 - Last Post: Oct 13, 2009 12:00 PM Last Post By: gomcar

gomcar

Posts: 88
Registered: 10/05/07

Grid Control and Rman Catalog
Posted: Sep 30, 2009 5:46 AM

Hi all.
In the Home of my Production Database (10.2.0.4 and Red Hat) I see the date of last backup and see:
High Availability
Data Guard Primary
Last Backup Sep 4, 2009 8:09:21 PM
Flashback Logging n/a

When my last successful backup is Sep 29, 2009 8:09 PM
I click on the date and I get this error.

"The database is down, and is not configured with a recovery catalog."

Some times I click and get the backup report and other I have the error.
I have configured RMAN with catalog and Database is up.
and something like this is happend with flashback too.... Flashback is enabled and not shown the real status...
Someone have experienced this error?

Edited by: gomcar on Sep 30, 2009 9:50 AM

Satishbabu Gunu...

Posts: 316
Registered: 08/07/09

Re: Grid Control and Rman Catalog
Posted: Oct 2, 2009 12:32 PM

in response to: gomcar

It seems that recent stats are not showing in EM and it might be the issue with agent.

stop and start agent ( it may resovle the issue)

emctl stop agent
emctl start agent

and check weather agent uploading or not in the output of below command.

emctl status dbconsole

hope this solves.
Regards
Satishbabu Gunukula
Click here to see [Connect by nocycle query gives wrong results|http://www.oracleracexpert.com/2009/08/connect-by-nocycle-query-wrong-results.html]
Click here to learn [Upgrade 8i to 10g|http://www.oracleracexpert.com/2009/08/upgrade-oracle-8i-to-10g.html]
http://www.oracleracexpert.com

gomcar

Posts: 88
Registered: 10/05/07

Re: Grid Control and Rman Catalog
Posted: Oct 13, 2009 8:55 AM

in response to: Satishbabu Gunu...

hi, I try your commands and nothing change...

I connect to rman and do this:

unregister database;
( no problem with this...)

but,
RMAN> register database;

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 10/13/2009 12:50:11
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 10/13/2009 12:50:11
ORA-02291: integrity constraint (RMAN.RLH_F1) violated - parent key not found

Exist any package to repair this error on rman catalog?

How I move this thread to RMAN forum??

gomcar

Posts: 88
Registered: 10/05/07

Re: Grid Control and Rman Catalog
Posted: Oct 13, 2009 12:00 PM

in response to: gomcar

Hi all.
I found a solution to my two problems.

1) I execute this package to unregister my DB without errors.

select 'EXEC DBMS_RCVCAT.UNREGISTERDATABASE('||DB_KEY||','||DBID||');'||' '||resetlogs_time
from rc_database
where name = '&db_name'

then I can register my DB again.

2) I configure my DB with Grid Control to use the recovery catalog.
Cluster Database Home --> Maintenance --> Recovery Catalog Settings --> Use a recovery catalog...

And now the correct backup date and FRA Usage is shown.

Thanks.

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)