Recovering a NOARCHIVELOG Database with Incremental Backups

STARTUP FORCE MOUNT;

RESTORE DATABASE FROM TAG “consistent_whole_backup”;

RECOVER DATABASE NOREDO;

ALTER DATABASE OPEN RESETLOGS;

Restoring the Server Parameter File

STARTUP FORCE NOMOUNT;

RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS …;
SET UNTIL TIME ‘SYSDATE-7’;
SET CONTROLFILE AUTOBACKUP FORMAT
FOR DEVICE TYPE sbt TO ‘/disk1/control_files/autobackup_%F’;
SET DBID 123456789;
RESTORE SPFILE TO ‘/tmp/spfileTEMP.ora’ FROM AUTOBACKUP MAXDAYS 10;
}

Restoring the Server Parameter File from a Control File Autobackup

SET DBID 320066378;
RUN
{
SET CONTROLFILE AUTOBACKUP FORMAT
FOR DEVICE TYPE DISK TO ‘autobackup_format’;
RESTORE SPFILE FROM AUTOBACKUP;
}

 

RESTORE SPFILE TO PFILE ‘/tmp/initTEMP.ora’;

STARTUP FORCE PFILE=’/tmp/initTEMP.ora’;