IDS Forum

Re: Imported Restore

Posted By: JACK PAPA
Date: Monday, 9 August 2010, at 4:57 a.m.

In Response To: Imported Restore (JACK PAPA)

got this documentation from the net and i followed all the steps but still wasn't able to restore:

------------------------------------------------------------

Using VERITAS NetBackup for Informix to restore an alternate client, also known as a redirected restore or an import restore to a different computer.
________________________________________
Details:
1. If possible, on the source host, back up the logical logs if the server is up. Salvage the logical logs if the source server is down.
2. Shut down the database servers on both hosts.
3. Copy the appropriate configuration files from the source host to the destination host as per Informix documentation.
ixbar.servernum
oncfg._servername.servernum
sqlhosts file
ONCONFIG file
4. Change the server name and server number to the values for the destination database server.
5. Set and export the environmental variable INFXBSA_CLIENT to the name of the source host as configured in NetBackup.

Note: Do not change the setting of CLIENT_NAME in either the client /usr/openv/netbackup/bp.conf file or the user bp.conf file to the backup source host name. The client Informix user bp.conf is located in the Infomix user home directory. CLIENT_NAME should be set in the client /usr/openv/netbackup/bp.conf file to the target client NetBackup configured name. If CLIENT_NAME is set in the client user bp.conf file, that setting will take precedence over the setting in the client /usr/openv/netbackup/bp.conf file. In this case, there is no reason to superseded the default setting in the /usr/openv/netbackup/bp.conf.

6. Set the appropriate entries in the NetBackup master server /usr/openv/netbackup/db/altnames directory to allow the target host to restore backups from the source host.
7. On the target host, ensure that you can now list the backup files from the source host. Enter the following command to see all such backups:

/usr/openv/netbackup/bin/bplist -C "source configured name" -t 6 -R /. Replace "source configured name" above with the NetBackup client name of the Informix host that is the source of the backups. If you can see the backup dbspaces and logs, you should now be ready to restore to the alternate client.
8. Perform the restore with the following commands:
onbar -r -p
onbar -r -l
The above sequence of two onbar commands will prevent the target server from trying to salvage its own logical logs prior to the restore as would be the case with a simple "onbar -r".

For example, if the Informix source host is configured in NetBackup with the name "production" and the target host is configured in NetBackup with the name "test", run the above NetBackup commands as follows.
On the master server, create a file /usr/openv/netbackup/db/altnames/test with the contents of the file "test" being the single entry "production", without the quotes.
On the host test, after preparing Informix for the restore, run the following commands for the Bourne shell:
INFXBSA_CLIENT = production ; export INFXBSA_CLIENT
/usr/openv/netbackup/bin/bplist -C production -t 6 -R /
# note the list of Informix backups from the host production
# the NetBackup client for Informix will pick up the variable INFXBSA_CLIENT, bplist will not.
onbar -r -p
onbar -r -l

The restore of the backup is now complete.

----------------------------------

What might be the problem???????? I'm stucked for 4 days now on doing this.. It looks simple but can't make it through...

Messages In This Thread

• Imported Restore
  JACK PAPA -- Sunday, 8 August 2010, at 11:27 p.m.
  • Re: Imported Restore
    JACK PAPA -- Monday, 9 August 2010, at 4:57 a.m.
    • Re: Imported Restore
      JACK PAPA -- Tuesday, 10 August 2010, at 3:52 a.m.
      • Re: Imported Restore
        WOLFGANG VOSS -- Monday, 23 August 2010, at 8:00 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.