Re: Rman issues

newbie wrote:

> 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
>
>
> a) 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 ????
>
> b) 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

1. Look for Doc-Id 378234.1 at Metalink, there are an increasing ROUT table, which is only useful for EM GUI
2. 10g catalog on 9.2.0.8 database is supported, but sometimes it helps to gather statics for the catalog schema.

Eberhard Niendorf Received on Fri Aug 31 2007 - 17:19:27 CDT