Rman issues

I have a Oracle 10.2.0.3 Target database which is being backed up through RMAN
However the catalog being used is on a Oracle 9.2.0.8 database

The problems that I am having are
The target database level zero backup is being done daily and archive log backup is being done 6 times a day.

The Target database backup was working fine for the last 3.5 months. So I guess the records in the catalog database will be approx 100 records for Zero level backup and 600 records for archive log backup

The archive log backup failed yesterday
I tried to give the following command
list backup of controlfile

This took more than 30 minutes

I tried
show all;
This took a very very long time.
Hence I tried the following

1. create new tablespace, new user on RCVCAT 9.2.0.8 database (same one being used earlier) and tried to register the database again. ....This did not work.....could you shed some light on this ????
2. I created a user (recovery_catalog_owner) on another 10.2.0.3 database and registered the target database and backed up the archive logs and everything worked fine

I am not sure that a target database of 10.2.0.3 should be backed up to a Recovery catalog database on Oracle 9.2.0.8

How do I count the number of records in the recovery catalog database. Is there some method to export records based on a query and then delete them to trim the recovery catalog database

Also The same recovery catalog database is being used by other databases also

Please respond Received on Fri Aug 31 2007 - 10:45:51 CDT