Re: RMAN duplicate question regarding archivelog file locations on different server
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>, ChrisDavid.Taylor@xxxxxxxxxxxxxxx
- Date: Mon, 4 Oct 2010 11:15:58 -0700 (PDT)
I'm working on little sleep, so hopefully I'm understanding the question
correctly, (that I remember my first name today is questionable... :))
If you are performing a standard clone, both the target and clone are using the
same backup directory, but the archive logs are located in different locations,
the location of the archive log listed in the log_archive_dest_1 for each
database should be all you need to have the logs "shipped" during the duplicate
from the target to the clone.
Unless logs have been moved from the dest directories, I've never had an issue
during the clone to locate the logs. Now I have had failures due to network
issues where logs haven't come over in the last step of the process.
Hope this helps,
Kellyn Pedersen
Sr. Database Administrator
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.blogspot.com
"Go away before I replace you with a very small and efficient shell script..."
--- On Mon, 10/4/10, Taylor, Chris David <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
wrote:
From: Taylor, Chris David <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
Subject: RMAN duplicate question regarding archivelog file locations on
different server
To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
Date: Monday, October 4, 2010, 9:55 AM
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:
