Database Software

Hi,

I try to implement a simple backup and restore process with rman. Ok, with rman it's not simple. ;-)

My aim is to backup a database with a full backup and restore it from this backup, for example when it crashes.

Ok, for creating the backup I use this rman script:
run
{
allocate channel t1 type disk;
backup incremental level 0 format 'PATHTOBAKFILE' database;
release channel t1;
}

The result is a 1GB large backupfile.

Now I delete the whole database and create a new one to simulate a crash.
After this is done, I want to restore the state of the database which is frozen in the backupfile.

Therefor I use the following rman script:
run
{
allocate channel t1 type disk format 'PATHTOBACKUPFILE';
shutdown immediate;
startup mount;
restore database;
recover database;
alter database open resetlogs;
release channel t1;
}

Now rman tells me an error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: Fehler bei restore Befehl auf 04/09/2008 10:24:59
RMAN-06026: Einige Ziele nicht gefunden - Recovery wird abgebrochen
RMAN-06023: Kein Backup bzw. keine Kopie der Datendatei 4 zum Wiederherstellen gefunden
RMAN-06023: Kein Backup bzw. keine Kopie der Datendatei 3 zum Wiederherstellen gefunden
RMAN-06023: Kein Backup bzw. keine Kopie der Datendatei 2 zum Wiederherstellen gefunden
RMAN-06023: Kein Backup bzw. keine Kopie der Datendatei 1 zum Wiederherstellen gefunden

In english: No backup or copy of datafile X where found for restore.

I think the backup/restore possibilities with rman are very complex and I don't exactly understand which is the right backup strategie. I'm not an oracle specialist. Maybe someone can give me a hint.

My program should backup the database full, differential and incremental and also restore only by using the given backupfiles. So I want somethink like Point-In-Time recovery, but rman should use the time-point of the given backupfile. And this backupfiles are stored outside oracle, e.g. on a server or somethink like this.

Thanks a lot for help.
Best regards,
Ronny