Hi! This is the ezmlm program. I'm managing the
suse-oracle suse.com mailing list.
I'm working for my owner, who can be reached
at suse-oracle-ownersuse.com.
Messages to you from the suse-oracle mailing list seem to
have been bouncing. I've attached a copy of the first
bounce
message I received.
If this message bounces too, I will send you a probe. If the
probe bounces,
I will remove your address from the suse-oracle mailing
list,
without further notice.
I've kept a list of which messages from the suse-oracle
mailing list have
bounced from your address.
Copies of these messages may be in the archive.
To retrieve a set of messages 123-145 (a maximum of 100 per
request),
send an empty message to:
<suse-oracle-get.123_145suse.com>
To receive a subject and author list for the last 100 or so
messages,
send an empty message to:
<suse-oracle-indexsuse.com>
Here are the message numbers:
13283
13284
13285
13286
13287
13288
13289
13290
13291
13292
13293
13294
13295
--- Enclosed is a copy of the bounce message I received.
Return-Path: <>
Received: (qmail 476 invoked from network); 26 Apr 2007
00:16:29 -0000
Received: from unknown (HELO Relay1.suse.de)
(195.135.221.8)
by 0 with SMTP; 26 Apr 2007 00:16:29 -0000
Received: from Relay1.suse.de (localhost [127.0.0.1])
by Relay1.suse.de (Postfix) with ESMTP id 49DCBD8DED
for <suse-oracle-return-13283-bond=yahoo.comlists.suse.com>; Thu, 26 Apr 2007 00:12:52 +0200
(CEST)
Received: from Relay1.suse.de ([127.0.0.1])
by Relay1.suse.de (Relay1 [127.0.0.1]) (amavisd-new, port
10026) with ESMTP
id 15023-09 for
<suse-oracle-return-13283-bond=yahoo.comlists.suse.com>;
Thu, 26 Apr 2007 00:12:51 +0200 (CEST)
Received: from mx1.suse.de (mx1.suse.de [195.135.220.2])
(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256
bits))
(No client certificate requested)
by Relay1.suse.de (Postfix) with ESMTP id 42918CFB73
for <suse-oracle-return-13283-bond=yahoo.comlists.suse.com>; Thu, 26 Apr 2007 00:12:51 +0200
(CEST)
Received: from starfire.yahoo.com (starfire.yahoo.com
[66.98.192.98])
by mx1.suse.de (Postfix) with ESMTP id DC849122F9
for <suse-oracle-return-13283-bond=yahoo.comsuse.com>; Thu, 26 Apr 2007 00:12:50 +0200 (CEST)
Received: by starfire.yahoo.com (Postfix)
id EFD48150AA7; Wed, 25 Apr 2007 17:12:54 -0500 (CDT)
Date: Wed, 25 Apr 2007 17:12:54 -0500 (CDT)
From: MAILER-DAEMONyahoo.com (Mail Delivery System)
Subject: Undelivered Mail Returned to Sender
To: suse-oracle-return-13283-bond=yahoo.comsuse.com
Auto-Submitted: auto-replied
MIME-Version: 1.0
Content-Type: multipart/report;
report-type=delivery-status;
boundary="D2583150A64.1177539174/starfire.yahoo.com&qu
ot;
Content-Transfer-Encoding: 8bit
Message-Id: <20070425221254.EFD48150AA7starfire.yahoo.com>
X-Virus-Scanned: by amavisd-new at Relay1.suse.de
X-Spam-Status: No, hits=1.5 tagged_above=-20.0 required=5.0
tests=BAYES_50,
MY_SUSE, RAZOR2_CF_RANGE_51_100, RAZOR2_CF_RANGE_E4_51_100,
RAZOR2_CHECK,
SPF_HELO_PASS
X-Spam-Level: *
This is a MIME-encapsulated message.
--D2583150A64.1177539174/starfire.yahoo.com
Content-Description: Notification
Content-Type: text/plain; charset=us-ascii
This is the mail system at host starfire.yahoo.com.
I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached
below.
For further assistance, please send mail to postmaster.
If you do so, please include this problem report. You can
delete your own text from the attached returned message.
The mail system
<bondyahoo.com>: cannot update mailbox /var/mail/bond
for user bond. error
writing message: File too large
--D2583150A64.1177539174/starfire.yahoo.com
Content-Description: Delivery report
Content-Type: message/delivery-status
Reporting-MTA: dns; starfire.yahoo.com
X-Postfix-Queue-ID: D2583150A64
X-Postfix-Sender: rfc822;
suse-oracle-return-13283-bond=yahoo.comsuse.com
Arrival-Date: Wed, 25 Apr 2007 17:12:54 -0500 (CDT)
Final-Recipient: rfc822; bondyahoo.com
Original-Recipient: rfc822;bondyahoo.com
Action: failed
Status: 5.2.2
Diagnostic-Code: x-unix; input/output error
--D2583150A64.1177539174/starfire.yahoo.com
Content-Description: Undelivered Message
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: amavisd-new at yahoo.com
Received: from starfire.yahoo.com ([127.0.0.1])
by localhost (starfire.yahoo.com [127.0.0.1]) (amavisd-new,
port 10024)
with ESMTP id tnoFMpTf7uBg for <bondyahoo.com>;
Wed, 25 Apr 2007 17:12:48 -0500 (CDT)
Received: from lists.suse.com (lists.suse.de
[195.135.221.131])
by starfire.yahoo.com (Postfix) with SMTP id 94BD9150AA3
for <bondyahoo.com>; Wed, 25 Apr 2007 17:12:45
-0500 (CDT)
Received: (qmail 31378 invoked by alias); 26 Apr 2007
00:16:07 -0000
Mailing-List: contact suse-oracle-helpsuse.com; run by ezmlm
Precedence: bulk
List-Post: <mailto:suse-oraclesuse.com>
List-Help: <mailto:suse-oracle-helpsuse.com>
List-Unsubscribe:
<mailto:suse-oracle-unsubscribe-bond=yahoo.comsuse.com>
List-Subscribe: <mailto:suse-oracle-subscribesuse.com>
X-MIME-Notice: attachments may have been removed from this
message
X-Mailinglist: suse-oracle
X-Message-Number-for-archive: 13283
Delivered-To: mailing list suse-oraclesuse.com
Received: (qmail 31369 invoked from network); 26 Apr 2007
00:16:07 -0000
Message-ID: <462FD23F.4090506ehotel.ag>
Date: Thu, 26 Apr 2007 00:12:15 +0200
From: Arno Seidel <a.seidelehotel.ag>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: suse-oraclesuse.com
Content-Type: text/plain; charset=ISO-8859-15;
format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at Relay1.suse.de
Subject: [suse-oracle] RMAN - Recovery Question
Hi there,
i hope someone out there can help me out of the problem:
Following situation:
Oracle Backups with rman
and these settings:
RMAN without recovery catalog
configure channel device type disk format
'/opt/rmanbackup/rman_%t_%s_%p.dbf';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO
'/opt/rmanbackup/%F';
from monday till friday with following command:
backup as compressed backupset incremental level = 1
database plus
archivelog delete input tag ='INCREMENTAL-$DATE';
on saturday i ran this command:
backup as compressed backupset incremental level = 0
database noexclude
plus archivelog delete input tag ='Full-$DATE';
my problem now is, that when i try to restore and recover
the wohle
database (after a complete loss of controllfiles / datafiles
/
archived_logs)
what i have is the full backup from saturday and the
incremental ones
till today
i would issue following commands:
rman target / nocatalog
SET DBID 2356179800
STARTUP FORCE NOMOUNT
PFILE='/opt/oracle/product/R2/dbs/initLNCL.ora';
run {
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/opt/rmanbackup/%F';
restore controlfile from autobackup maxdays 1;}
shutdown immediate;
startup mount;
restore database;
till now every thing is ok ... but if i do the
"final" step
recover database;
rman stops after some time and says:
RMAN-06025: no backup of log thread 1 seq found to restore
several times ... these requested log sequences are older
than 3 weeks
and i don?t have them any more.
Why does Rman want this old logs???
And how can i recover the database without these old logs?
any help would be great.
regards from germany
Arno Seidel
--
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting
--D2583150A64.1177539174/starfire.yahoo.com--
|