Rman issues
- From: newbie <rjngh2005@xxxxxxxxx>
- Date: Fri, 31 Aug 2007 08:45:51 -0700
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
.
- Prev by Date: Re: how to come out of "an incompatible media recovery is active" error
- Next by Date: Re: fine-grained auditing
- Previous by thread: how to come out of "an incompatible media recovery is active" error
- Next by thread: Re: Rman issues
- Index(es):
Relevant Pages
|
