Re: backup & recovery between different server
Date: 21 Feb 2002 08:12:37 -0600
Message-ID: <3c750055_3_at_spamkiller.newsgroups.com>
You can always restore a backup as another database. This means you can
restore the backup to another location. On the existing database you
should issue as system : alter database backup controlfile to trace;
Shutdown the existing database (if not done already) Edit the init.ora
file of the existing the database and change the settings of the db_name
and path values. Edit the trace file (made with alter database ...).
change the path variable to point to the restored location. Save the
file as an sql file for example. cr_db.sql On os set the SID to the
right value: set ORACLE_SID=<database name>
sqlplus> connect internal
sqlplus > startup nomount sqlplus > _at_cr_db.sql you get the message such
as cluster altered or controfile created depending on the version. Open
the database with: alter database open resetlogs
-- Ir. A.P. Djuly Gabon Straat 5 2622 Delft djuly_at_wanadoo.nl Ir. A.P. Djuly Gabon Straat 5 2622 Delft djuly_at_wanadoo.nl Ir. A.P. Djuly Gabon Straat 5 2622 Delft djuly_at_wanadoo.nl Posted via dBforums http://dbforums.comReceived on Thu Feb 21 2002 - 15:12:37 CET