RE: RMAN duplicate question regarding archivelog file locations on different server

  • From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
  • To: 'Don Granaman' <granaman@xxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>, ChrisDavid.Taylor@xxxxxxxxxxxxxxx
  • Date: Tue, 5 Oct 2010 13:35:44 -0700 (PDT)

"Pardon me if this is showing up thrice or so.  I sent this reply from another 
account yesterday and against today - and haven't seen it yet"
 
You mean I'm not the only one who has Oracle L email that goes to Limbo??  (Or 
simply doesn't show up for a day and seems oblivious at that point... :))



Kellyn Pedersen
Sr. Database Administrator
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.blogspot.com
 

--- On Tue, 10/5/10, Taylor, Chris David <ChrisDavid.Taylor@xxxxxxxxxxxxxxx> 
wrote:


From: Taylor, Chris David <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
Subject: RE: RMAN duplicate question regarding archivelog file locations on 
different server
To: "'Don Granaman'" <granaman@xxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" 
<oracle-l@xxxxxxxxxxxxx>
Date: Tuesday, October 5, 2010, 1:30 PM






Nope, I don’t think you missed anything.  
 
That SET command came up from someone else as well.  I haven’t had a chance to 
look into it, but thanks for pointing it out!
 
 
 

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx
 
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.
 


From: Don Granaman [mailto:granaman@xxxxxxx] 
Sent: Tuesday, October 05, 2010 2:12 PM
To: Taylor, Chris David; oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN duplicate question regarding archivelog file locations on 
different server
 

Unless I am missing something obvious, within the run{} section of the 
duplicate script, try:

 

SET ARCHIVELOG DESTINATION TO '/somefilesystem/somedir/';

 

Pardon me if this is showing up thrice or so.  I sent this reply from another 
account yesterday and against today - and haven't seen it yet.


----- Original Message ----- 

From: Taylor, Chris David 

To: 'oracle-l@xxxxxxxxxxxxx' 

Sent: Monday, October 04, 2010 10:55 AM

Subject: RMAN duplicate question regarding archivelog file locations on 
different server

 
I’m running a duplicate command to clone a database over to a dev server and 
the disk drive letters are different on the secondary server for the 
archivelogs.  My backup disk location is the same on both servers.
 
Is there a way when doing a duplicate to tell RMAN to look in an alternate 
location than where the primary sends its archivelogs?  
 
I’m receiving the RMAN-06025: no backup of log thread 1 seq 93814 lowscn 
8775725044 found to restore error since the archivelog paths are different.
 
To get around this, I’ve backed up the archivelogs on the primary and copied 
those backups and I believe the restore will work from that point but it seems 
like there should be an easy way to have alternate file locations when doing a 
duplicate.
 
Thanks,
 
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx
 
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.
 


      

Other related posts: