Re: test restore

cptkirkh wrote:
On Apr 11, 3:08 pm, "cptkirkh" <k...@xxxxxxxx> 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
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: "Correct" term for a 1:1 relationship between a "database" and an "instance" where > 1 such thin
    ... Nearly all the Oracle docs and books define a database something like ... unpartitioned physical server? ...
    (comp.databases.oracle.server)
  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver.odbc)
  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver)
  • RE: Vulnerability analysis tools
    ... Definitely you want your Oracle database behind a firewall. ... tell you the database is not meant to be exposed to the internet directly. ... 1- A web server hosted at an IDC ...
    (Security-Basics)
  • Re: problem connecting to db.
    ... Have you checked the listener log file on the database server? ... client is correct, and that the connection string that you are ... the Oracle client would be looking for a server ...
    (comp.databases.oracle.misc)