Re: How to restore Archive files from old Rman backup.

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 22 Jul 2008 11:30:51 -0700
Message-ID: <bf46380807221130j37e6deb5ud165d9ffad30d3ee@mail.gmail.com>

On Mon, Jul 21, 2008 at 4:54 PM, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:

> Yep, I think it's MAXSEQ you're thinking of, and you set it to a number <
> 255. ML # 393947.1 has the details.
>

Yes, that was one of them. I looked up some notes on it:

---

...without RCAT, the FROM AUTOBACKUP clause is required RMAN starts searching backup media for file of c-<DBID>-YYYYMMDD-FF. then FE, FD, FC all the way to 00.

starts over at the previous day if not found

this can take a long time!

can be mitigated with MAXSEQ and MAXDAYS options

restore controlfile from autobackup maxdays 10 maxseq 20

can also just specify name – go for c-<DBID>-YYYYMMDD-00 if you are desperate!

---

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 22 2008 - 13:30:51 CDT