Home » RDBMS Server » Backup & Recovery » restore archivelog (Linux, 10.2.0.4)
restore archivelog [message #520079] Thu, 18 August 2011 08:26 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello All,

I need to restore few archivelog from one of stage database to refresh dev database.

Stage database got refreshd before try to restore the arch files.

Now stage database does not contain arch sequence information.

I tried to restore arch fiels from tape using catalog connection. Is not helping me. Is there any way to restore

Thanks

channel c1: sid=521 devtype=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2007071006)

Starting restore at 18-AUG-11
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/18/2011 09:20:21
RMAN-06004: ORACLE error from recovery catalog database: 
RMAN-20242: specification does not match any archive log in the recovery catalog

[Updated on: Thu, 18 August 2011 08:28]

Report message to a moderator

Re: restore archivelog [message #520080 is a reply to message #520079] Thu, 18 August 2011 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Manually recatalog the missing archived log backup.

Regards
Michel
Re: restore archivelog [message #520082 is a reply to message #520080] Thu, 18 August 2011 08:52 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thank you Michel.

Could you please share me oracle link for manual recatalog.

Thanks
Re: restore archivelog [message #520083 is a reply to message #520080] Thu, 18 August 2011 09:00 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thank you again.

I got the solution for my quesiton based on michel response.

- Babu
Previous Topic: Creating Archivelog in Network drive
Next Topic: How to get all the archive logs in a backup piece
Goto Forum:
  


Current Time: Fri Apr 19 18:45:30 CDT 2024