Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to restore archivelog from backupset?

taohikoDec 4 2009 — edited Dec 5 2009
Hi All,

I backup datafile and archivelog to tape with below command;

RMAN> RUN
2> {
3> allocate channel kt type 'sbt_tape' maxpiecesize=8G parms 'ENV=(xxxxxxx.opt)';
4> sql 'alter system archive log current';
5> backup current controlfile format='CAT_Controlfile_%T_%s_%p.ctl';
6> BACKUP DATABASE;
7> BACKUP ARCHIVELOG ALL;
8> backup spfile;
9> release channel kt;
10> }

And now I restore all datafile to new server completed and next step I will restore archivelog file from backupset but I don't know how to do.

Please suggest me.

Regards,

Hiko
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2010
Added on Dec 4 2009
10 comments
5,205 views