Content-Type: Text/Plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dear,=0D
=0D
My client has aborted a snapmirror backup on HP-UX with RMAN on 28/04/200=
4.=0D
Due to the abort RMAN left junk in the V$DATAFILE_COPY on the target.=0D
One row contains a resetlogs SCN way above the other values and a reset t=
ime
at 2021.=0D
Another row has a NULL reset time.=0D
Each time the row corresponds with the backup of the control file.=0D
=0D
Since than, the RMAN catalog will not resync.=0D
I tried to drop the catalog user, recreate the catalog and register the
database.=0D
I also unregistered the database, still the same error.=0D
=0D
Now I get all the time :=0D
RMAN> register database;=0D
RMAN-03022: compiling command: register=0D
RMAN-03023: executing command: register=0D
RMAN-08006: database registered in recovery catalog=0D
RMAN-03023: executing command: full resync=0D
RMAN-08002: starting full resync of recovery catalog=0D
RMAN-03026: error recovery releasing channel resources=0D
RMAN-00571: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0D
RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE S=
TACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0D
RMAN-00571: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0D
RMAN-03008: error while performing automatic resync of recovery catalog=0D
RMAN-07004: unhandled exception during command execution on channel defau=
lt=0D
RMAN-20009: database incarnation already registered=0D
=0D
We have a database containing RMAN catalogs for each database off course
each catalog in the different schema.=0D
=0D
Does anybody know how I can fix the problem with the V$DATAFILE_COPY ??=0D
This is a production database, so I can not export /import it into a new =
one
easily !=0D
=0D
=0D
Rgds,=0D
=0D
Patrick Van der Sande=0D
Managing Director =0D
ANDES Consulting BVBA=0D
email : patrick.van.der.sande_at_skynet.be=0D
website :
http://www.andes-consulting.be
- Binary/unsupported file stripped by Ecartis --
- Type: image/gif
- File: IMSTP.gif
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon May 10 2004 - 13:18:34 CDT
