Home » RDBMS Server » Backup & Recovery » how to extract the archive log backup set (10.2.0.1)
how to extract the archive log backup set [message #556336] Fri, 01 June 2012 23:15 Go to next message
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




Re: how to extract the archive log backup set [message #556339 is a reply to message #556336] Sat, 02 June 2012 00:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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?
Re: how to extract the archive log backup set [message #556357 is a reply to message #556356] Sat, 02 June 2012 06:41 Go to previous messageGo to next message
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;
}
Re: how to extract the archive log backup set [message #556364 is a reply to message #556357] Sat, 02 June 2012 10:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: how to extract the archive log backup set [message #556656 is a reply to message #556364] Tue, 05 June 2012 22:22 Go to previous messageGo to next message
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';
}
Re: how to extract the archive log backup set [message #556663 is a reply to message #556656] Tue, 05 June 2012 23:17 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: how to stop rman incrementalbackup job
Next Topic: delete backupset issue
Goto Forum:
  


Current Time: Thu Mar 28 15:10:38 CDT 2024