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: 48
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
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: 64103
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
Re: missing archivelog [message #362371 is a reply to message #362370] Tue, 02 December 2008 01:19 Go to previous message
suresh.wst
Messages: 48
Registered: June 2008
Location: Hyderabad
Member
Thankyou.
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:
  


Current Time: Sun Dec 04 02:40:50 CST 2016

Total time taken to generate the page: 0.06150 seconds