5.1 I just discovered that a database that is used infrequently is missing its root file. I can not find a copy on any backup tape. I do have a good schema. Is there anything I can do to recover this database?
You can replace the root file if you are careful. If you have a schema that matches the data sets EXACTLY then do the following:
1. create a separate group called dbtemp, and home yourself to that group then,
file dbstext=dbschema
run dbschema.pub.sys;parm=1
run dbutil.pub.sys
create dbname
Now you should have an empty data base with a good root file, but in the wrong group.
2. store the root file to tape
3. restore the root file using the group= option
At this point you should have a good root file in the correct group.
As a final point: Like running BULDACCT to get an alternative directory source in the full backup, it is also a good idea to run Adager, DBGeneral or some other utility to create a known good schema on a periodic basis.