Recover database to a different host using legato & EBU

Legato Steps
Install legato client only (server not needed) on the new node and copy usr/opt/networker/bin/ to /usr/shlib/ . 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.

EBU Steps
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.
restore database
db_name = "DTSPD"
remap_path = "/dts/oradata/DTSPD" to "/disk3/oradata/DTSPD","/its/oradata/DTSPD" to "/disk3/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?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site 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 or the content authors.