Re: RMAN Restore Question

From: JSchneider <jeremypaulschneider_at_gmail.com>
Date: 23 Jun 2005 08:08:02 -0700
Message-ID: <1119539282.742782.215440@g44g2000cwa.googlegroups.com>

amerar_at_iwc.net wrote:
> Well, the need has arrisen for us to mine to logs. I assume that I can
> restore the archive logs without applying them right? We are running
> Oracle 8.1.7. Is there a way to specify the log sequence or time span
> of logs to restore?

according to the docs...

RESTORE command:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rmansy37.htm#7697

archivelogRecordSpecifier:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rmansyn5.htm#51049

RMAN> restore archivelog from logseq=100 until logseq=110; RMAN> restore archivelog from time='15-JUN-05' until time='20-JUN-05';

(use NLS_LANG and NLS_DATE_FORMAT to specify date format) Received on Thu Jun 23 2005 - 10:08:02 CDT