Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: test restore

Re: test restore

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 11 Apr 2007 20:03:11 -0700
Message-ID: <1176346985.592930@bubbleator.drizzle.com>


cptkirkh wrote:

> On Apr 11, 4:14 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> cptkirkh wrote:
>>> On Apr 11, 3:08 pm, "cptkirkh" <k..._at_scic.com> wrote:
>>>> I am testing a restore operation using Symantec Backup Exec to a
>>>> different server and have some questions. I have install oracle on a
>>>> different server. I then restored the database while the databse is
>>>> shutdown. I then mounted the database but when i run "alter databse
>>>> suning backup controlfile it keeps looking for the other archvile log
>>>> files form the original setup. How can i use oracle to recognize this
>>>> databse i restored and to start it up? Thanks for your help.
>>> Ok here is what I have done far. After reading the Veritas
>>> documentation. I found out that the files are restored with the
>>> original path in the file name. I renmaed these files and placed them
>>> in the location where the new server was located. I now want to
>>> recover this db but I don't want it to interfere with the production
>>> db. I would assume I need to edit the control file to point the db to
>>> where the new archive log files are located nd then run a recover
>>> database using backup controlfile. Is this correct?
>> Control files can not be edited.
>>
>> I'd recommend you put Veritas away and use RMAN.
>>
>> It has two things that make it far superior.
>> 1. It works.
>> 2. It is free.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>
>> - Show quoted text -

>
> What do I backup if I use veritas to backup the server?

I wouldn't use Veritas.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Apr 11 2007 - 22:03:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US