rman problem

From: news.tpi.pl <rr_at_rr.pl>
Date: Thu, 27 Apr 2006 17:00:31 +0200
Message-ID: <e2qmc0$iq6$1@atlantis.news.tpi.pl>

Hi all

I have RMAN restore question.

How to restore from exact backup file?

For example I run script

RUN { ALLOCATE CHANNEL ch1 TYPE DISK FORMAT 'C:\oracle\kopia\%d_DB_%u_%s_%p';

BACKUP DATABASE plus archivelog;

RELEASE CHANNEL ch1;

}

EXIT; It creates backup copy file:

'C:\oracle\kopia\ORCL_DB_04HHIHCD_4_1'

How to restore exactly from that backup copy not from last one?

I try:

run {

allocate channel d1 type disk;

from 'C:\oracle\kopia\ORCL_DB_04HHIHCD_4_1';

restore database validate;

RELEASE CHANNEL d1;

}

But it doesn't work.

Thanks for help

t. Received on Thu Apr 27 2006 - 10:00:31 CDT