Database Software

How do I restore database(9i) using old full backup? I want to do this because my redo log group(current) has crashed and the database cannot be opened, its in mount state.

RMAN details
- no catalog used

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/rman-backup/cf%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/rman-backup/ora_df%t_s%s_s%p';
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/backup/rman-backup/snapcf_PROD.f';

I have run CROSSCHECK BACKUP and the DELETE OBSOLETE.


"List backup" gives the latest backup sets. I have deleted all the latest backup sets from '/backup/rman-backup/' and copied all the old full backup set to to '/backup/rman-backup/'. It looks like RMAN is aware of latest backup and not the old full backup files which I have copied to '/backup/rman-backup/'.

RMAN> restore validate database;

Starting restore at 24-MAY-10

using channel ORA_DISK_1
using channel ORA_DISK_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/24/2010 17:50:19
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 419 found to restore