Re: RMAN Log only Backup/Restore

Uso,

RMAN will find these archivelog files automatically when performing a restore if you leave them on the hard drive where they got written by RMAN.

I have a similar script I use for this task: http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/in stallgen_win901_85_.html

I use the Installgen application to generate these scripts automatically when I create a database (so I don't have any typos): http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

David Simpson
www.dotcomsolutionsinc.net
"Uso" <usofwd_at_gmx.net> wrote in message
news:acvpd9$t2m5_at_news.emirates.net.ae...
> Hi,
>
> I want to do a log files only backup with RMAN.
>
> I do the Backup with this script:
>
> connect target 'internal/oracle'
> run {
> allocate channel t1 type 'SBT_TAPE';
> allocate channel t2 type 'SBT_TAPE';
> sql 'alter system archive log current';
> # backup all archive logs
> backup
> filesperset 20
> format 'al_%s_%p_%t'
> (archivelog all
> delete input);
> }
>
> How do I the restore of the logs? Can I use the same restore command as
for
> the database?
>
> connect target 'internal/oracle_at_abd'
> run {
> # Restore all datafiles, and recovers them completely.
> allocate channel t1 type 'SBT_TAPE';
> allocate channel t2 type 'SBT_TAPE';
> restore
> (database);
> recover database;
> }
>
> regards
> Uso
>
>
>
>
Received on Tue May 28 2002 - 09:18:13 CDT