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 runni=
ng
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 co=
py
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>=3D<archive dest>" to restore the needed archi=
ve
logs (note you only need the =3D<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'l=
l
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
|