Home » RDBMS Server » Backup & Recovery » RMAN Log only Backup/Restore
RMAN Log only Backup/Restore [message #51536] Wed, 29 May 2002 01:09 Go to next message
Osama
Messages: 2
Registered: May 2002
Junior Member
I can restore the log files only using the:

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 can I restore the log files only?
Actually I am also wondering if it makes sense to backup logs only and restore the logs only, but I have been asked to do that.

thanks for your comments.

Report message to a moderator

Re: RMAN Log only Backup/Restore [message #51540 is a reply to message #51536] Wed, 29 May 2002 08:15 Go to previous message
Radek
Messages: 33
Registered: April 2002
Member
This should do the trick:

run {
allocate channel t1 type 'SBT_TAPE';
restore archivelog all;
}

More here:
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76990/rmansy37.htm#7697

Report message to a moderator

Previous Topic: what are the different ways available for backup
Next Topic: Re: data backup with oracle8i and vb6.0
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 25 04:08:55 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.