Re: Large database backup with RMAN

Hi

You might want to include the control file in the backup script. Although rman will copy the control file I don't think the database recognises it for some reason when you do a restore. So take a copy of the control file after you've done the backup database command. When you restore the control file will know about the last backup and things should go okay - worked for me.

Alistair

"Andras Kovacs" <andkovacs_at_yahoo.com> wrote in message news:412ebb69.0211061745.6c6d2383_at_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 Thu Nov 07 2002 - 08:44:41 CST