From oracle-l-bounce@freelists.org Fri Jun 24 19:17:59 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5P0HxSn031089 for ; Fri, 24 Jun 2005 19:17:59 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180] (may be forged)) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5P0HxNi031085 for ; Fri, 24 Jun 2005 19:17:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A56481C479B; Fri, 24 Jun 2005 18:14:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27181-03; Fri, 24 Jun 2005 18:14:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 213AC1C4840; Fri, 24 Jun 2005 18:14:31 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C57912.3937E6DC" Subject: Re: database duplication Date: Fri, 24 Jun 2005 19:12:42 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: database duplication Thread-Index: AcV4wBYFRFKsN9hXTlSqDkTLjkGRmgAUiMjN From: To: Cc: , X-OriginalArrivalTime: 24 Jun 2005 23:12:43.0073 (UTC) FILETIME=[397C0B10:01C57912] X-CanItPRO-Stream: default X-Spam-Score: undef - License key expired X-Scanned-By: CanIt (www . roaringpenguin . com) on 167.78.2.22 X-archive-position: 21685 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Paula_Stankus@doh.state.fl.us Precedence: normal Reply-To: Paula_Stankus@doh.state.fl.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, NO_REAL_NAME autolearn=no version=2.63 ------_=_NextPart_001_01C57912.3937E6DC Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Did a few. Successfully but this one.... -------------------------- Sent from my BlackBerry Wireless Handheld -----Original Message----- From: Dennis Williams To: Stankus, Paula G CC: tjambu_freelists@yahoo.com.au ; = Oracle-L@freelists.org Sent: Fri Jun 24 09:24:39 2005 Subject: Re: database duplication Paula I have seen character set errors quite a bit in RMAN recoveries. If you are using OEM, it may be that the character set on your PC differs from the character set on the server. If not, examine the character set of each of the databases involved. I have also ended up completing the recovery of a database without using RMAN more than once. It probably means that somehow the archive logs were not available to RMAN at the point it tried to perform the recovery. You may be able to complete the recovery by putting the archive logs where they are expected by the new database and issuing a recover database from sqlplus. Database duplication with RMAN works really slick, but there are some details that are difficult to work out. Once you get it going in your environment, take careful notes and you should have no difficulty the next time. Dennis Williams --=20 BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ Teach CanIt if this mail (ID 36206578) is spam: Spam: = https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D36206578&m=3Da605= fb605e86 Not spam: = https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D36206578&m=3Da605= fb605e86 Forget vote: = https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D36206578&m=3Da605= fb605e86 ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS ------_=_NextPart_001_01C57912.3937E6DC Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Re: database duplication

Did a few. Successfully but this one....
--------------------------
Sent from my BlackBerry Wireless Handheld


-----Original Message-----
From: Dennis Williams <oracledba.williams@gmail.com>
To: Stankus, Paula G <Paula_Stankus@doh.state.fl.us>
CC: tjambu_freelists@yahoo.com.au <tjambu_freelists@yahoo.com.au>; = Oracle-L@freelists.org <Oracle-L@freelists.org>
Sent: Fri Jun 24 09:24:39 2005
Subject: Re: database duplication

Paula

I have seen character set errors quite a bit in RMAN recoveries. If
you are using OEM, it may be that the character set on your PC = differs
from the character set on the server. If not, examine the character
set of each of the databases involved.
    I have also ended up completing the recovery of a = database without
using RMAN more than once. It probably means that somehow the = archive
logs were not available to RMAN at the point it tried to perform the
recovery. You may be able to complete the recovery by putting the
archive logs where they are expected by the new database and issuing = a
recover database from sqlplus.
    Database duplication with RMAN works really slick, = but there are
some details that are difficult to work out. Once you get it going = in
your environment, take careful notes and you should have no = difficulty
the next time.

Dennis Williams


--
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 36206578) is spam:
Spam:        https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D= 36206578&m=3Da605fb605e86
Not spam:    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D= 36206578&m=3Da605fb605e86
Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D= 36206578&m=3Da605fb605e86
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

------_=_NextPart_001_01C57912.3937E6DC-- -- http://www.freelists.org/webpage/oracle-l