Originally posted by coolboy
Hi jeff,

Sorry to disturb u again

suppose sunday I took one backup.

Again wednesday I took another one.

Later I came to know I had some problem with wednesday backup

In this case I want to restore it from sunday backup.

How is it possible with RMAN?

Cool

Coolboy: Your question is really valid. But better don't get into the trap of argument.

Check it out this.

1. First ensure that your backup is taken with a tag every day. example

Backup 1
Backup database format '/ora1/RMANBKUP/full_db_old_%d_%s_%p' tag = 'old';

Backup 2
Backup database format '/ora1/RMANBKUP/full_db_new_%d_%s_%p' tag = 'new';

2. While restoring mention the unique tag to identify the backup set which you are refering. example
RMAN> run
{
sql "alter session set nls_date_format=''MON DD YY HH24:MI:SS''";
sql "alter session set nls_language=american";
set until time 'JULY 19 01 17:58:45';
allocate channel recodb1 type disk;
restore controlfile;
restore database from tag = 'old';
alter database mount;
recover database;
release channel recodb1;
}

Will restore from the 'old' backup and the latest backup is 'new'.

Version tested: oracle 9i (9.2.0)

I think this will solve your doubt.

Note: RTFM is applicable to everybody. ....


Regards

Thomas