Home » RDBMS Server » Backup & Recovery » Archived Redo Logs not Multiplexed when Restoring
Archived Redo Logs not Multiplexed when Restoring [message #259535] Wed, 15 August 2007 22:16 Go to next message
sweetness
Messages: 10
Registered: May 2005
Location: Pasadena
Junior Member
Hi all,

For some reason when I issue the command

restore archivelog scn between xxxx and yyyy


only one of the two multiplexed groups of my archived redo logs is being restored -- the one that resides on /u03/archives/prod, but not the one that should be at /u02/archives/prod.

But two groups exist on my database, and both were backed up, as evidenced by my the output of the 'list archivelog all' statment issued *before* my restore:

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
9712    1    4856    A 23-JUL-07 /u03/archives/prod/1_4856_606497010.arc
10610   1    5229    A 13-AUG-07 /u03/archives/prod/1_5229_606497010.arc
10457   1    5229    A 13-AUG-07 /u02/archives/prod/1_5229_606497010.arc
10616   1    5230    A 13-AUG-07 /u03/archives/prod/1_5230_606497010.arc
10459   1    5230    A 13-AUG-07 /u02/archives/prod/1_5230_606497010.arc
10602   1    5231    A 13-AUG-07 /u03/archives/prod/1_5231_606497010.arc
10461   1    5231    A 13-AUG-07 /u02/archives/prod/1_5231_606497010.arc
10579   1    5232    A 13-AUG-07 /u03/archives/prod/1_5232_606497010.arc
10463   1    5232    A 13-AUG-07 /u02/archives/prod/1_5232_606497010.arc
10580   1    5233    A 13-AUG-07 /u03/archives/prod/1_5233_606497010.arc
10465   1    5233    A 13-AUG-07 /u02/archives/prod/1_5233_606497010.arc
10581   1    5234    A 13-AUG-07 /u03/archives/prod/1_5234_606497010.arc
10467   1    5234    A 13-AUG-07 /u02/archives/prod/1_5234_606497010.arc
10582   1    5235    A 13-AUG-07 /u03/archives/prod/1_5235_606497010.arc
10469   1    5235    A 13-AUG-07 /u02/archives/prod/1_5235_606497010.arc
10600   1    5236    A 13-AUG-07 /u03/archives/prod/1_5236_606497010.arc
10471   1    5236    A 13-AUG-07 /u02/archives/prod/1_5236_606497010.arc
10608   1    5237    A 13-AUG-07 /u03/archives/prod/1_5237_606497010.arc
10473   1    5237    A 13-AUG-07 /u02/archives/prod/1_5237_606497010.arc
10613   1    5238    A 13-AUG-07 /u03/archives/prod/1_5238_606497010.arc
10475   1    5238    A 13-AUG-07 /u02/archives/prod/1_5238_606497010.arc
10614   1    5239    A 13-AUG-07 /u03/archives/prod/1_5239_606497010.arc
10477   1    5239    A 13-AUG-07 /u02/archives/prod/1_5239_606497010.arc
10612   1    5240    A 13-AUG-07 /u03/archives/prod/1_5240_606497010.arc
10479   1    5240    A 13-AUG-07 /u02/archives/prod/1_5240_606497010.arc
10603   1    5241    A 13-AUG-07 /u03/archives/prod/1_5241_606497010.arc
10481   1    5241    A 13-AUG-07 /u02/archives/prod/1_5241_606497010.arc
10604   1    5242    A 13-AUG-07 /u03/archives/prod/1_5242_606497010.arc
10483   1    5242    A 13-AUG-07 /u02/archives/prod/1_5242_606497010.arc
10583   1    5243    A 13-AUG-07 /u03/archives/prod/1_5243_606497010.arc
10485   1    5243    A 13-AUG-07 /u02/archives/prod/1_5243_606497010.arc
10584   1    5244    A 13-AUG-07 /u03/archives/prod/1_5244_606497010.arc
10487   1    5244    A 13-AUG-07 /u02/archives/prod/1_5244_606497010.arc
10577   1    5245    A 13-AUG-07 /u03/archives/prod/1_5245_606497010.arc
10489   1    5245    A 13-AUG-07 /u02/archives/prod/1_5245_606497010.arc
10585   1    5246    A 13-AUG-07 /u03/archives/prod/1_5246_606497010.arc
10491   1    5246    A 13-AUG-07 /u02/archives/prod/1_5246_606497010.arc
10586   1    5247    A 13-AUG-07 /u03/archives/prod/1_5247_606497010.arc
10493   1    5247    A 13-AUG-07 /u02/archives/prod/1_5247_606497010.arc
10587   1    5248    A 13-AUG-07 /u03/archives/prod/1_5248_606497010.arc
10495   1    5248    A 13-AUG-07 /u02/archives/prod/1_5248_606497010.arc
10609   1    5249    A 14-AUG-07 /u03/archives/prod/1_5249_606497010.arc
10497   1    5249    A 14-AUG-07 /u02/archives/prod/1_5249_606497010.arc
10598   1    5250    A 14-AUG-07 /u03/archives/prod/1_5250_606497010.arc
10499   1    5250    A 14-AUG-07 /u02/archives/prod/1_5250_606497010.arc
10605   1    5251    A 14-AUG-07 /u03/archives/prod/1_5251_606497010.arc
10501   1    5251    A 14-AUG-07 /u02/archives/prod/1_5251_606497010.arc
10588   1    5252    A 14-AUG-07 /u03/archives/prod/1_5252_606497010.arc
10503   1    5252    A 14-AUG-07 /u02/archives/prod/1_5252_606497010.arc
10589   1    5253    A 14-AUG-07 /u03/archives/prod/1_5253_606497010.arc
10505   1    5253    A 14-AUG-07 /u02/archives/prod/1_5253_606497010.arc
10590   1    5254    A 14-AUG-07 /u03/archives/prod/1_5254_606497010.arc
10507   1    5254    A 14-AUG-07 /u02/archives/prod/1_5254_606497010.arc
10601   1    5255    A 14-AUG-07 /u03/archives/prod/1_5255_606497010.arc
10509   1    5255    A 14-AUG-07 /u02/archives/prod/1_5255_606497010.arc
10615   1    5256    A 14-AUG-07 /u03/archives/prod/1_5256_606497010.arc
10511   1    5256    A 14-AUG-07 /u02/archives/prod/1_5256_606497010.arc
10591   1    5257    A 14-AUG-07 /u03/archives/prod/1_5257_606497010.arc
10513   1    5257    A 14-AUG-07 /u02/archives/prod/1_5257_606497010.arc
10592   1    5258    A 14-AUG-07 /u03/archives/prod/1_5258_606497010.arc
10515   1    5258    A 14-AUG-07 /u02/archives/prod/1_5258_606497010.arc
10597   1    5259    A 14-AUG-07 /u03/archives/prod/1_5259_606497010.arc
10517   1    5259    A 14-AUG-07 /u02/archives/prod/1_5259_606497010.arc
10606   1    5260    A 14-AUG-07 /u03/archives/prod/1_5260_606497010.arc
10519   1    5260    A 14-AUG-07 /u02/archives/prod/1_5260_606497010.arc
10599   1    5261    A 14-AUG-07 /u03/archives/prod/1_5261_606497010.arc
10521   1    5261    A 14-AUG-07 /u02/archives/prod/1_5261_606497010.arc
10607   1    5262    A 14-AUG-07 /u03/archives/prod/1_5262_606497010.arc
10523   1    5262    A 14-AUG-07 /u02/archives/prod/1_5262_606497010.arc
10593   1    5263    A 14-AUG-07 /u03/archives/prod/1_5263_606497010.arc
10525   1    5263    A 14-AUG-07 /u02/archives/prod/1_5263_606497010.arc
10594   1    5264    A 14-AUG-07 /u03/archives/prod/1_5264_606497010.arc
10527   1    5264    A 14-AUG-07 /u02/archives/prod/1_5264_606497010.arc
10595   1    5265    A 14-AUG-07 /u03/archives/prod/1_5265_606497010.arc
10529   1    5265    A 14-AUG-07 /u02/archives/prod/1_5265_606497010.arc
10596   1    5266    A 14-AUG-07 /u03/archives/prod/1_5266_606497010.arc
10531   1    5266    A 14-AUG-07 /u02/archives/prod/1_5266_606497010.arc
10578   1    5267    A 14-AUG-07 /u03/archives/prod/1_5267_606497010.arc
10533   1    5267    A 14-AUG-07 /u02/archives/prod/1_5267_606497010.arc
10611   1    5268    A 15-AUG-07 /u03/archives/prod/1_5268_606497010.arc
10535   1    5268    A 15-AUG-07 /u02/archives/prod/1_5268_606497010.arc


What the hellsinki is going on?

TIA

Joe
Re: Archived Redo Logs not Multiplexed when Restoring [message #259536 is a reply to message #259535] Wed, 15 August 2007 22:24 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I don't sure but this may help you.
In rman use,
rman>run{
set archivelog destination to
'/u02/archives/prod/1_5229_606497010.arc'
restore archivelog scn between x and y;
}
Re: Archived Redo Logs not Multiplexed when Restoring [message #259577 is a reply to message #259535] Thu, 16 August 2007 00:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want it restores all copies?
One is sufficient to recover the database which is the purpose of restoring the archived logs.
RMAN restores the minimal data to recover the database, thanks to it.

Regards
Michel
Re: Archived Redo Logs not Multiplexed when Restoring [message #259584 is a reply to message #259535] Thu, 16 August 2007 00:53 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

thanks to it.


Thanks or thinks?
Re: Archived Redo Logs not Multiplexed when Restoring [message #259587 is a reply to message #259584] Thu, 16 August 2007 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I thank RMAN to restore only what it needs and not all what it can get.

Regards
Michel
Re: Archived Redo Logs not Multiplexed when Restoring [message #259810 is a reply to message #259587] Thu, 16 August 2007 10:30 Go to previous messageGo to next message
sweetness
Messages: 10
Registered: May 2005
Location: Pasadena
Junior Member
Michel,

I wasn't sure how many redo logs were necessary to restore back the database to the point of the last change. Theoretically, if a commit isn't issued for a REALLY long time, isn't it possible that one would need more than the latest archived redo log?

However, one fact that might support your theory (at least in the case of this particular RMAN backup), is that when I tried to execute RECOVER DATABASE, RMAN did restore one and only one archived redo log, the latest one.

Still, the question remains: why is only the /u03 group of archived redo logs restored when I issue the RESTORE ARCHIVELOG SCN BETWEEN xxxx AND yyyy command?

Joe
Re: Archived Redo Logs not Multiplexed when Restoring [message #259817 is a reply to message #259810] Thu, 16 August 2007 10:53 Go to previous message
sweetness
Messages: 10
Registered: May 2005
Location: Pasadena
Junior Member
OK. I just found out the answer to my own question. In the document Oracle Database Backup and Recovery Basics, 10g Release 2, I stumbled across this statement "Even if your redo logs are being archived to multiple destinations and you use RMAN to back up archived redo logs, RMAN selects only one copy of the archived redo log file to include in the backup set."

Thanks for everyone's help.
Previous Topic: Difference between control files
Next Topic: backup report
Goto Forum:
  


Current Time: Sat Dec 10 07:04:22 CST 2016

Total time taken to generate the page: 0.04413 seconds