| Subject | RE: [ib-support] Re: WRONG PAGE TYPE IB6 ODS10 |
|---|---|
| Author | Andy Goodchild |
| Post date | 2002-09-09T07:58:08Z |
Thanks Helen and Allan for your comments re backup.
I do understand the process and only make file system copies when I know
that the database is off line to all other users. As a rule though I do use
gbak to do the moving and I should have qualified that in my comments sorry.
Allan the article you referred me to was the same one I had used to in the
first place so thanks it�s good to know that I am looking in the right
places.
Helen you asked�What do you mean by "an IB agent"?
By that all I meant was backup software that can safely do an IB backup ala
Gbak or Dbak or IBBACKUP etc.
Helen you asked where does the error in the thread's title come in - "WRONG
PAGE TYPE IB6 ODS10"
It was an IB 6 database that had been upgraded from an IB 5.6 database about
a year ago.
Regards
Andy
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Sunday, September 08, 2002 11:03 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Re: WRONG PAGE TYPE IB6 ODS10
Some light reading
http://www.ibphoenix.com/main.nfs?a=ibphoenixApp&l=;IBPHOENIXAPP.KNOWLEDGEBA
<http://www.ibphoenix.com/main.nfs?a=ibphoenixApp&l=;IBPHOENIXAPP.KNOWLEDGEB
A>
SE;ID='320'
Now when the last person disconnects (and you are watching the filesystem
directory), you will notice the database receive the current datetime stamp.
It is always best practice IMHO and in my experience, even if you are sure
that noone is connected, to gbak the file and not copy the physical file.
When you say often move the location - how are you sure that noone is
connected?
As an "agent" if you have none, use
net stop "Interbase Guardian"
net stop "Interbase Server"
in a batch file before the scheduled tape backup, then net start "Interbase
Guardian" only command after the backup, you'll be sure of getting a file
copy of the gdb file without connections... BUT it's alway best practice to
instead do a gbak of the database before the scheduled backup and ignore the
gdb file in the backup routine. Only backup the gbak file.
When you say the backups have not been good - How do they know? Have they
ever tried to restore a backedup gdb file - Is that how they know? If so -
therein lies the reason for the corruption.
You should also think about scheduling regular (e.g. once a month) backups
and restores in the same operation, to flush the garbage out and restore
some nice shape to your database.
Alan
-----Original Message-----
From: goodieauk [mailto:andy@...]
Sent: Monday, 9 September 2002 6:55
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: WRONG PAGE TYPE IB6 ODS10
I do understand the process and only make file system copies when I know
that the database is off line to all other users. As a rule though I do use
gbak to do the moving and I should have qualified that in my comments sorry.
Allan the article you referred me to was the same one I had used to in the
first place so thanks it�s good to know that I am looking in the right
places.
Helen you asked�What do you mean by "an IB agent"?
By that all I meant was backup software that can safely do an IB backup ala
Gbak or Dbak or IBBACKUP etc.
Helen you asked where does the error in the thread's title come in - "WRONG
PAGE TYPE IB6 ODS10"
It was an IB 6 database that had been upgraded from an IB 5.6 database about
a year ago.
Regards
Andy
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Sunday, September 08, 2002 11:03 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Re: WRONG PAGE TYPE IB6 ODS10
Some light reading
http://www.ibphoenix.com/main.nfs?a=ibphoenixApp&l=;IBPHOENIXAPP.KNOWLEDGEBA
<http://www.ibphoenix.com/main.nfs?a=ibphoenixApp&l=;IBPHOENIXAPP.KNOWLEDGEB
A>
SE;ID='320'
Now when the last person disconnects (and you are watching the filesystem
directory), you will notice the database receive the current datetime stamp.
It is always best practice IMHO and in my experience, even if you are sure
that noone is connected, to gbak the file and not copy the physical file.
When you say often move the location - how are you sure that noone is
connected?
As an "agent" if you have none, use
net stop "Interbase Guardian"
net stop "Interbase Server"
in a batch file before the scheduled tape backup, then net start "Interbase
Guardian" only command after the backup, you'll be sure of getting a file
copy of the gdb file without connections... BUT it's alway best practice to
instead do a gbak of the database before the scheduled backup and ignore the
gdb file in the backup routine. Only backup the gbak file.
When you say the backups have not been good - How do they know? Have they
ever tried to restore a backedup gdb file - Is that how they know? If so -
therein lies the reason for the corruption.
You should also think about scheduling regular (e.g. once a month) backups
and restores in the same operation, to flush the garbage out and restore
some nice shape to your database.
Alan
-----Original Message-----
From: goodieauk [mailto:andy@...]
Sent: Monday, 9 September 2002 6:55
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: WRONG PAGE TYPE IB6 ODS10
--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> out of interest -
> Does this mean you can not make any connections to the database at
this
> time?
Yes that is correct. If I could I would it is likely I cold do a
gbak of only the metadata and then datapump out the data to a new
database.
> Have you physically moved the gdb file at some stage?
This particular Gdb has stayed on the same drive in the same location
for at least 12 months.
I am intrested though why moving a GDB should be an issue as I
understand it a GDB is extremely portable and infact I often have to
move the physical location of GDB's on sites.
> Have you being doing regular backups and restores over this last
year?
Yes the Client has been doing backups. However against my advice
they have not been using backup software that has an IB Agent. The
result has been that the actual backups have not been good. Yes and
the Client does now except that the should be checking their backups.
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=221745.2287884.3710693.2225243/D=egroupweb/S=17051153
86:HM/A=1207826/R=0/*http://www.buywirelessnow.com/sonyericsson/handset_T68i
.asp>
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.384 / Virus Database: 216 - Release Date: 21/08/2002
[Non-text portions of this message have been removed]