ADSM-L

Re: BACKINT - restoring to another host

1999-02-24 10:38:58
Subject: Re: BACKINT - restoring to another host
From: Ken Chamberlain <ken.chamberlain AT UTORONTO DOT CA>
Date: Wed, 24 Feb 1999 10:38:58 -0500
First edit dsm.sys so that "node blah" refers to the production system.
Secondly edit init<SID>.utl so that parameter BACKUPIDPREFIX is the same as
the production system.  backint_GUI should now see the backint created
backupsets.  You need the backup log from a successful backup.  Check in
$ORAHOME/sapbackup/back<SID>.log for its name.  Either copy the log from
your production system or take it from the appropriate backupidset via an
appropriate "backint -f restore" command.  Are you changing the SID?  If so
set environment variables ORACLE_SID_NEW and ORACLE_HOME_NEW before running
brrestore -b <backup log name>.  You also state that your backint style
backups are online backups.  You will need to do recovery so you need at a
minimum the archive logs spanning the   backup.  To restore archive logs on
this test machine you will need $ORAHOME/saparch/arch<SID>.log from your
production system.  Either copy from production or retrieve from ADSM via
appropriate "backint -f restore" command.  Note it needs to be a newer copy
than the time of the restored backup.  If you are changing SID, you need to
change the name of this dataset to reflect the new SID.  Run "brrestore -a
<SID>,<start log>-<end log>=<archive dest>" to restore the needed archive
logs (note you only need the =<archive dest> if you are changing SID so you
want the logs to come back in the standard place for the new SID). If you
are changing SID, and thus the location of your logs and datafiles, you'll
need to recreate your control files.  A backup controlfile to trace on
production will give you the source of a create controlfile statement for
you to use on this test system, editing for any SID related name changes and
possibly adding "set database <NEW SID>".  After recreating controlfiles,
run recovery:alter database recover automatic database until cancel using
backup controlfile; alter database recover cancel; alter database open
resetlogs;

Good luck!
Ken Chamberlain
University of Toronto
Phone:(416) 978-1582
Fax:  (416) 971-2085
E-mail: ken.chamberlain AT utoronto DOT ca

<Prev in Thread] Current Thread [Next in Thread>