onbar restore problem
Dear
I have resotre problem using onbar.
-------------------------------------
<TEST1 >
Test that dbspace backup , nomal procedure table drop and dbspace restore
--> fail
1. # onbar -b insadbs
2. "test" table drop in "isadbs" dbspace. (using "dbaccess" command)
3. # onbar -r insadbs
or
3. # onbar -r -n 6 insadbs (number 6 is backup logical number)
or
3. # onbar -r -p insadbs
or
3. # onbar -r -t "POINT of BACKUP TIME"
No error messgae displayed.
But "test" table is not restored.
--------------------------
<TEST2>
Test that dbspace backup , nomal procedure dbspace drop and dbspace restore
--> fail
1. # onbar -b insadbs
2. "insadbs" dbspace drop all.
3. # onbar -r insadbs
No error message displayed.
"insadbs" dbspace restored.
But "tset" table is not restored.
----------------------
<TEST3>
Test that dbspace backup , abnormal procedure table drop and dbspace
restore
--> successful
1. # onbar -b insadbs
2. I removed chncuk of "isadbs" dbspace.
3. # onbar -r insadbs
No error message displayed.
"insadbs" dbspace restored.
"test" table restored.
-----------------------
<TEST4>
Test that full backup , nomal procedure table drop and full restore
--> successful
1. # onbar -b -w
2. "test" table drop in "isadbs" dbspace. (using "dbaccess" command)
3. informix db down
3. # onbar -r -w -p
-----------------------
I will summarize the problem.
I can't dbspace restore when data drop by nomal procedure.
In my opinion, this case is written to logical log even drop information.
When restore, real data is restored, and backup changed logical log, and
restore again.
So, data is removed again.
------------------------
I want know dbspace restore when data drop by nomal procedure.
-------------------------------------
Would you check this?