Large database backup with RMAN

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 6 Nov 2002 17:45:13 -0800
Message-ID: <412ebb69.0211061745.6c6d2383@posting.google.com>

We are running a 8.1.7 on MS advanced server. I am trying to implement a backup and recovery strategy. I have tried to use RMAN but it looks like a nightmare.

Our datebase is very large. A part of it is only read only. So I use the following command to back it up.

run {

   SHUTDOWN IMMEDIATE;
   STARTUP MOUNT pfile=L:\Oracle\admin\inst1\pfile\init.ora    allocate channel ch1 type disk format 'M:\temp\inst1_full_%U';    backup database skip readonly;
   release channel ch1;
   ALTER DATABASE OPEN;
}

Regarding the backup all went perfectly. However I never managed to restore the database .... Whenever I use the command "backup database skip readonly;" I can't restore the database from the backup.
Oracle complains about

ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\INST1\SYSTEM01.DBF'

Anybody knows what command I should use to restore the database ?

Thanks. Received on Wed Nov 06 2002 - 19:45:13 CST