RE: RMAN problem

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 10 May 2004 13:49:56 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B005E8@EXCHMN3>

Patrick

Never encountered this one (not complaining). Just a guess. Since the problem as you describe it relates to a problem in a V$ table, has the database been bounced since then? If not, it might be worth a shot. Another thought might be to look in the initialization scripts for the script that creates this table, with the idea of dropping, recreating the table.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Patrick Van der Sande Sent: Monday, May 10, 2004 1:04 PM
To: oracle-l_at_freelists.org
Subject: RMAN problem

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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 14:05:37 CDT