RE: Restore old backup to new database name
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <kat.axe@xxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>
- Date: Tue, 9 Mar 2010 15:25:27 -0500
Yes duplicating I understand. 'restoring to a different name' is what
I was referring too.
Duplicating is the easier way to go as it will duplicate right into a
new database name and structure. But it's not working and I'm trying
to figure out why. See last response to Allen.
Joel Patterson
Database Administrator
904 727-2546
________________________________
From: kathryn axelrod [mailto:kat.axe@xxxxxxxxx]
Sent: Tuesday, March 09, 2010 3:21 PM
To: Brandon.Allen@xxxxxxxxxxx
Cc: Patterson, Joel; oracle-l@xxxxxxxxxxxxx
Subject: Re: Restore old backup to new database name
And, (unless Brandon and I are misunderstanding), if changing the
directory structure is the issue, when doing the duplicate as below, use
the parameter:
db_file_name_convert
I would point you to the OTN doc that shows using this parameter for
duplicates, but OTN seems to be down at the moment (or at least it is
for me)..Nonetheless, Google should point you in the right direction if
you have questions about it.
On Tue, Mar 9, 2010 at 12:11 PM, Allen, Brandon
<Brandon.Allen@xxxxxxxxxxx> wrote:
I'm not sure I understand you correctly, but it sounds like all you need
is something like this:
duplicate target database to <new_database_name> until time
'26-FEB-10 <whatever_time_you_want>';
Am I missing something?
-----Original Message-----
From: Joel.Patterson@xxxxxxxxxxx [mailto:Joel.Patterson@xxxxxxxxxxx]
I don't see in these documents how to restore to a different database
name.
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
