Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ontape /onarchive troubleshooting 1

Status
Not open for further replies.

mynwo

Technical User
Jul 12, 2003
75
IN
Hi all,

ontape /onarchive troubleshooting...
I have ids 9.4 installed on win nt and ids 9.21 installed on unix on sun solaris. I want to use ontape to backup & restore data. I do not have any tape device. In win nt we cannot specify a file as a tape device, but in unix we can give a file path. Ontape -s takes the entire backup. I would like to know how can i do troubleshooting, like i take a backup and then i restore and see if the backup was done properly. After taking a backup can i drop a database or a dbspace and run ontape -r will it restore the database / dbspace for me or not. In case of dbspace will i have to create it first or it will be done automatically. For eg. I have 2 database demo and stores, now i run ontape -s, it should backup the enitre instance, now i drop the demo database. Now if run ontape -r can i recover the demo database, samething for dbspaces too. Please advice.

Regards,

lloyd
 
Hi,

Forget now onarchive. This tool is no more supported.

Concerning backup and restore, you can choose between ontape and onbar.
Both tools are using the dbspace as the smaller unit to backup and restore.
You cannot backup and restore only one database or one table.
If you want to do this, look at tools like BMC SQL- Bactrack. It can restore only one table.
Ontape -r will only restore the dbspace specified.
This is true, of course, if you have your logical logs not backuped to /dev/null !!!
If you don't have the logical logs, then you can only perform a full restore !!!

regards,

Jean


Jean
Paris (France)
Visit our site :
 
Hi Jean,

Thanks for your prompt reply.

Regards,

lloyd
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top