Recover database to a different
host using legato & EBU
Install legato client only (server not needed)
on the new node and copy usr/opt/networker/bin/libobk.so to /usr/shlib/libobk.so
. NSR_CLIENT should be set up to the name of host whose data is being restored.
For ex. If Database is on HOST_A and it has been backed up to tapes on
HOST_B and the restore is being done to HOST_C, then NSR_CLIENT should
be A (called client in legato jargon). NSR_SERVER should be set up to the
name of host that backed up the data of the client. Thus in above example
NSR_SERVER would be B (called server in legato jargon). C must be defined
in remote access list of client A on HOST_B.
Create the directories where datafiles will be
restored. Set up the OFA structure on new host and copy the init.ora, config.ora
files. Create the link in ORACLE_HOME/dbs directory for init.ora file.
Add entry in /etc/oratab and /etc/ORACLE.PROFILE for the database. Change
init.ora and config.ora to reflect new directories. If link is not created
then startup_pfile parameter should be specified to give the location of
parameter file to be used
EBU scipt should be as folows for latest cold
database restore. db_name is not used to determine the database to be restored.
ORACLE_SID determines that.
db_name = "DTSPD"
remap_path = "/dts/oradata/DTSPD" to "/disk3/oradata/DTSPD","/its/oradata/DTSPD"
archivelog = "/disk3/oradata/DTSPD"
log = "/users/oracle/dba/legato/log/restore_dtspd.log"
remap_path parameter should be used to
specify the directories where files are to be restored. One target directory
can be specified for each source directory.
rename parameter should be used for automatic
renaming of data and logfiles in the controlfile. As EBU renamed online
redo logs first and datafiles next so if dummy (because neither EBU nor
Rman backs up online redo logs) online redo logs are not created prior
to restore then the automatic renaming will fail. In that case either created
a new controlfile using backup create controfile script or rename all the
datafiles manually using ‘alter database rename file ’ command.
backup_host parameter should be used to
specify the host which had done the backup, which is being restored. Thus
in our example it would be HOST_B. (Test this one)
Have a Oracle Question
Do you have
an Oracle Question?
Database Administration, SQL, Application, Programming Reference Books
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.