Re: Rman issues

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 31 Aug 2007 16:26:01 GMT
Message-ID: <46d84119$0$1445$79c14f64@nan-newsreader-07.noos.net>

On Fri, 31 Aug 2007 08:45:51 -0700, newbie wrote:

> The archive log backup failed yesterday I tried to give the following
> command list backup of controlfile
>
> This took more than 30 minutes

Could be because your catalog was not 'patched'. With some 9i releases you had to contact the support to add some indexes to the catalog to correct this sort of performance issues. Could be completely something else though, since we can't guess with so few pieces of information.

> 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 ????

No. Show us the error.

> 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

Refer to the compatibility matrix in the official doco.

> How do I count the number of records in the recovery catalog database.

Read about the RC_ views in the official doco.

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

Done.

Jerome Received on Fri Aug 31 2007 - 11:26:01 CDT