Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Which command do I use to restore database backup from tape drive & from disk?

Re: Which command do I use to restore database backup from tape drive & from disk?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 3 Jan 2004 18:21:12 +0100
Message-ID: <3ff6f9a8$0$29067$636a55ce@news.free.fr>

"David" <dt_146_at_yahoo.co.in> a écrit dans le message de news:d5840ebd.0401030853.3f83fd84_at_posting.google.com...
> Hello Every one,
>
> Following are the commands, which I would like to use for taking RMAN
> backup to tape drive and disk:
>
>
> TAPE:
>
> Run {allocate channel t1 type 'SBT_TAPE';
> backup
> database;}
>
> DISK:
>
> Run {
> allocate channel d1 type disk
> format = 'c:\disk1\d_%s_%t_%p';
> backup
> database ;}
>
>
>
> In this regard when I want to restore database from the backup which
> resides on tape or on disk, what commands should I issue for restoring
> the database from each device Tape or Disk.
> Could someone send the restore commands for both TAPE AND DISK.
>
> Thanks
>
> David

Allocate all necessary channels for recovery, something like:

Run {
allocate d1...
allocate t1...
restore database;
recover database;
}

Regards
Michel Cadot Received on Sat Jan 03 2004 - 11:21:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US