Hello
We make every night a rman backup from the production database with this rman script:
RUN
{
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oraback/sid/backup/temp/sid_SNAP.ctl';
ALLOCATE CHANNEL DISK_1 DEVICE TYPE DISK FORMAT '/oraback/sid/backup/%T_%s_%t_%p.dbf';
ALLOCATE CHANNEL DISK_2 DEVICE TYPE DISK FORMAT '/oraback/sid/backup/%T_%s_%t_%p.dbf';
ALLOCATE CHANNEL DISK_3 DEVICE TYPE DISK FORMAT '/oraback/sid/backup/%T_%s_%t_%p.dbf';
ALLOCATE CHANNEL DISK_4 DEVICE TYPE DISK FORMAT '/oraback/sid/backup/%T_%s_%t_%p.dbf';
BACKUP INCREMENTAL LEVEL 0 DATABASE FILESPERSET 1;
SQL 'BEGIN DBMS_LOGMNR_D.BUILD(OPTIONS=^>DBMS_LOGMNR_D.STORE_IN_REDO_LOGS); END;';
SQL 'CREATE RESTORE POINT SID_BACKUP';
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP ARCHIVELOG ALL;
BACKUP CURRENT CONTROLFILE;
RESTORE DATABASE VALIDATE;
}
EXIT;
Now I'd copy the dbf to a new host and restore the controlfile from the last dbf-file. After this i restore the database with rman "restore database". After this I want to start the database wie resetlogs. But I get this error message: "ORA-01152: file1 was not restored from a sufficiently old backup"
Whats wrong? How can I restore the controlfile from the rmanbackup? I use this command: "restore contfile from "last dbffile in the rman directory"". Is this correct?
Thanks for your support.
Best regards.
Roger