FBDataGuard Help!!
Добавлено: 05 мар 2009, 11:18
Поставил на локальной машине FBDataGuard Community Edition. Решил попробовать использовать для резервного копирования БД.
Добавил сервер, добавил в нем базу данных, прописал пути к fbserver и утилитам gbak и nbackup.
Теперь вот пытаюсь увидеть чтоб эта штука сделала копию базы, а она в назначенное ей время нифига не делает!! Логи по серверу по памяти и cpu ведутся...
Вот параметры сервера:
Server: localhost
State: Enabled
Access interval: 2 min
Delay if error: 600000 msec (10 min)
Start time: 8:00:00
Finish time: 21:59:59
Output path: "\localhost\"
Monitor CPU load
Monitor free memory
Check server process "C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe" for :
Handle Count
Thread Count
Page Faults
PageFile Usage
WorkingSet Size
Virtual Size
Private Page Count
Read Operation Count
Read Transfer Count
Write Operation Count
Write Transfer Count
Other Operation Count
Other Transfer Count
Kernel Mode Time
User Mode Time
Check firebird.log ("C:\Program Files\Firebird\Firebird_2_0\firebird.log") for errors.
Warn if firebird.log file grow larger than 5 MBytes.
And rename log file after this.
Warn if system disk free space became less than 104857600 bytes
Warn if disk free space for system temporary files became less than 104857600 bytes
Warn if disk free space for firebird/interbase host became less than 104857600 bytes
Warn if disk free space for firebird/interbase logfile became less than 104857600 bytes
Вот базы:
Database: localhost:C:\DB\TestBase\ZOP-ARM.fdb
State: Enabled
Parameters of connection:
Using library: C:\WINDOWS\system32\GDS32.DLL
User: SYSDBA
Password: ***hidden***
SQL dialect: 3
charset: WIN1251
-------
Transaction monitor is enabled!
Monitor transactions by Services API
Access interval: 2 min
Delay if error: 600 sec (10 min)
-------
Metadata monitor is enabled!
RDB$Format will be checked.
Indexes will be checked.
Access interval: 15 min
Delay if error: 600 sec (10 min)
-------
Space monitor is enabled!
Access interval: 10 min
Delay if error: 600 sec (10 min)
-------
Scheduled backup by gbak.exe is enabled. Start gbak at 11:09:00 on
Monday
Tuesday
Wednesday
Thursday
Friday
Place backup files to: C:\DB\TestFolder
Inhibit garbage collection
Transportable backup -- data in XDR format
Perform test restore
Skip "localhost:" in database name for gbak.exe
Path to gbak.exe: C:\Program Files\Firebird\Firebird_2_0\bin\gbak.exe
Path to nbackup.exe: C:\Program Files\Firebird\Firebird_2_0\bin\nbackup.exe
Timeout for gbak.exe: 60 minutes.
-------
Scheduled nbackup is not enabled.
-------
Getting database statistic is not enabled.
Подскажите в чем может быть дело, pls.
Добавил сервер, добавил в нем базу данных, прописал пути к fbserver и утилитам gbak и nbackup.
Теперь вот пытаюсь увидеть чтоб эта штука сделала копию базы, а она в назначенное ей время нифига не делает!! Логи по серверу по памяти и cpu ведутся...
Вот параметры сервера:
Server: localhost
State: Enabled
Access interval: 2 min
Delay if error: 600000 msec (10 min)
Start time: 8:00:00
Finish time: 21:59:59
Output path: "\localhost\"
Monitor CPU load
Monitor free memory
Check server process "C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe" for :
Handle Count
Thread Count
Page Faults
PageFile Usage
WorkingSet Size
Virtual Size
Private Page Count
Read Operation Count
Read Transfer Count
Write Operation Count
Write Transfer Count
Other Operation Count
Other Transfer Count
Kernel Mode Time
User Mode Time
Check firebird.log ("C:\Program Files\Firebird\Firebird_2_0\firebird.log") for errors.
Warn if firebird.log file grow larger than 5 MBytes.
And rename log file after this.
Warn if system disk free space became less than 104857600 bytes
Warn if disk free space for system temporary files became less than 104857600 bytes
Warn if disk free space for firebird/interbase host became less than 104857600 bytes
Warn if disk free space for firebird/interbase logfile became less than 104857600 bytes
Вот базы:
Database: localhost:C:\DB\TestBase\ZOP-ARM.fdb
State: Enabled
Parameters of connection:
Using library: C:\WINDOWS\system32\GDS32.DLL
User: SYSDBA
Password: ***hidden***
SQL dialect: 3
charset: WIN1251
-------
Transaction monitor is enabled!
Monitor transactions by Services API
Access interval: 2 min
Delay if error: 600 sec (10 min)
-------
Metadata monitor is enabled!
RDB$Format will be checked.
Indexes will be checked.
Access interval: 15 min
Delay if error: 600 sec (10 min)
-------
Space monitor is enabled!
Access interval: 10 min
Delay if error: 600 sec (10 min)
-------
Scheduled backup by gbak.exe is enabled. Start gbak at 11:09:00 on
Monday
Tuesday
Wednesday
Thursday
Friday
Place backup files to: C:\DB\TestFolder
Inhibit garbage collection
Transportable backup -- data in XDR format
Perform test restore
Skip "localhost:" in database name for gbak.exe
Path to gbak.exe: C:\Program Files\Firebird\Firebird_2_0\bin\gbak.exe
Path to nbackup.exe: C:\Program Files\Firebird\Firebird_2_0\bin\nbackup.exe
Timeout for gbak.exe: 60 minutes.
-------
Scheduled nbackup is not enabled.
-------
Getting database statistic is not enabled.
Подскажите в чем может быть дело, pls.