OraFAQ Forum: Backup & Recovery » how to extract the archive log backup set

Home » RDBMS Server » Backup & Recovery » how to extract the archive log backup set (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to extract the archive log backup set [message #556336]

Fri, 01 June 2012 23:15

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
There is a archive log backupset,and the backup set contains many archive log file,and now i want extract to a directory,how can i do?

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       86.20M     DISK        00:00:21     02-JUN-12      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20120602T113622
        Piece Name: /u02/rman_bak/20120602/archive_log_t784899382_s4_p1

Report message to a moderator

Re: how to extract the archive log backup set [message #556339 is a reply to message #556336]

Sat, 02 June 2012 00:10

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use RESTORE command.

Once again, it is DIRECTLY in the doc you refuse to read.
Is there any question you posted that was not ansered (ou could be answered) by a link to the documentation? Is so, please a link to the topic.

Regards
Michel

[Updated on: Sat, 02 June 2012 00:11]

Report message to a moderator

Re: how to extract the archive log backup set [message #556356 is a reply to message #556339]

Sat, 02 June 2012 06:18

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel,There is a backupset of archive log in Primary,but some archive log files is not send to Standby in that backupset,now i want to extract the backupset file and copy the archve log file to Standby,how can i do?

Report message to a moderator

Re: how to extract the archive log backup set [message #556357 is a reply to message #556356]

Sat, 02 June 2012 06:41

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel, it can do!

RUN
{ 
  SET ARCHIVELOG DESTINATION TO '/u02/archive_log';
  RESTORE ARCHIVELOG ALL;
}

Report message to a moderator

Re: how to extract the archive log backup set [message #556364 is a reply to message #556357]

Sat, 02 June 2012 10:46

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can alsoo restore the specific archived log from the specific backup set you found.
Search the syntax and test it, it is a good exercise.

Regards
Michel

Report message to a moderator

Re: how to extract the archive log backup set [message #556656 is a reply to message #556364]

Tue, 05 June 2012 22:22

andy huang
Messages: 498
Registered: July 2011

Senior Member

Hi,
Michel, Maybe the flowing command is run well.

RUN
{ 
  SET ARCHIVELOG DESTINATION TO '/u02/archive_log';
  RESTORE ARCHIVELOG FROM TAG 'your_tag';
}

Report message to a moderator

Re: how to extract the archive log backup set [message #556663 is a reply to message #556656]

Tue, 05 June 2012 23:17

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is but it does not fulfil the requirement: "restore the specific archived log from the specific backup [set].

Regards
Michel

Report message to a moderator

Previous Topic:	how to stop rman incrementalbackup job
Next Topic:	delete backupset issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:51:07 CST 2025