Home » RDBMS Server » Backup & Recovery » missing archivelog (oracle10g, Linux AS4)
missing archivelog [message #362362] Tue, 02 December 2008 00:54 Go to next message
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
Member
Hi,

can anybody help me solving the following scenarios.

1) I lost a datafile and when I try to restore and recover using RMAN, I got message that archivelog is missing. I found an archivelog is missing in the available archivelogs?

Eg: let's say archivelogs started from 1,2,3 .. and 11 is missing and from 12 archivelogs are available.

2) If it is with the cold or hot backups, how the problem can be solved?

3) Due to disk space unavailability, I changed the archivelog destination. if a datafile is missing, how can I recover? Some archivelogs are available in another destination. How can we mention the destinations at the time of recovery?

Regards,
suresh

Report message to a moderator

Re: missing archivelog [message #362370 is a reply to message #362362] Tue, 02 December 2008 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2) You can't. You can only recover up to the last archived log before the missing one.

3) yes, change the parameter "log_archive_dest*" you use with "alter system".

Regards
Michel

Report message to a moderator

Re: missing archivelog [message #362371 is a reply to message #362370] Tue, 02 December 2008 01:19 Go to previous message
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
Member
Thankyou.

Report message to a moderator

Previous Topic: HOW TO CONNECT RMAN WITH PIPE ?
Next Topic: Oracle cold backup can be stored partly on Solaris 8 and Solaris 10?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 18:21:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.