X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 86669D1B19C for ; Mon, 28 Jun 2004 13:49:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76180-07 for ; Mon, 28 Jun 2004 16:49:30 +0000 (GMT) Received: from exchange_geral.intra.cet.pt (mailgestao.ptinovacao.pt [194.65.138.11]) by svr1.postgresql.org (Postfix) with ESMTP id E4D8DD1B289 for ; Mon, 28 Jun 2004 13:49:28 -0300 (ADT) Received: by EXCHANGE_GERAL with Internet Mail Service (5.5.2657.72) id ; Mon, 28 Jun 2004 17:55:42 +0100 Message-ID: From: Jose Almeida To: pgsql-admin@postgresql.org Subject: Recover from a media failure Date: Mon, 28 Jun 2004 17:49:21 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C45D2F.DC54045A" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/352 X-Sequence-Number: 14012 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C45D2F.DC54045A Content-Type: text/plain; charset="iso-8859-1" Can someone explain me how can i recover (media failure) until last transaction from a backup (something like archivelog in Oracle db)? In Oracle if i make a backup on instant t1 and a datafile be corrupt on instant t2 (t2>t1), then i can restore from backup and apply archivelogs to recover until t2. Thanks ------_=_NextPart_001_01C45D2F.DC54045A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Recover from a media failure

Can someone explain me how can i recover (= media failure) until last transaction from a backup (something like archive= log in Oracle db)?

In Oracle if i make a backup on instant t1= and a datafile be corrupt on instant t2 (t2>t1), then i can restore fro= m backup and apply archivelogs to recover until t2.

Thanks



------_=_NextPart_001_01C45D2F.DC54045A--