Hi,
I created test databases as per application team request.Before releasing these databases i have taken offline backup .But for larger databases backup is running for very long.
Can i know reason why backup is running for long.
for Ex:
Database size is 65GB.
To take offline backup it is taken 5 Hours.
Our version is old 9.1e
We checked with OS team server side everything is fine
Server memory 3 GB used out of 3.5 GB and paging space is used 21% out of 4.6GB
Db.pf
======================
-B 65000 # Number of (8K) Blocks in database buffer
-bibufs 200 # Number of before-image buffers
-aibufs 300 # Number of after-image buffers
-Mi 1 # Min processes on a client server
-Ma 15 # Max number of REMOTE clients per db server
-Mn 30 # Max number of REMOTE client servers
-Mxs 32768 # Shared memory overflow size (override)
-spin 15000 # Number of spin lock retries
-L 56000 # Lock Table entries
db.lg
09:07:33 BROKER 0: Multi-user session begin. (333)
09:07:33 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
09:07:46 BROKER 0: Physical Redo Phase Completed at blk 833 off 2628 upd 0. (7161)
09:07:46 BROKER 0: Started for tstslc using tcp, pid 198472. (5644)
09:07:46 WDOG 31: Started. (2518)
09:07:47 BROKER 0: Progress OpenEdge Release 9.1E on AIX. (4234)
09:07:47 BROKER 0: Server started by pgresdba on batch. (4281)
09:07:47 BROKER 0: Started using pid: 1864. (6574)
09:07:47 BROKER 0: Physical Database Name (-db): /dbadmin/tst/db. (4235)
09:07:47 BROKER 0: Database Type (-dt): PROGRESS. (4236)
09:07:47 BROKER 0: Force Access (-F): Not Enabled. (4237)
09:07:47 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
09:07:47 BROKER 0: Number of Database Buffers (-B): 55000. (4239)
09:07:47 BROKER 0: Maximum private buffers per user (-Bpmax): 64. (9422)
09:07:47 BROKER 0: Excess Shared Memory Size (-Mxs): 33554432. (4240)
09:07:47 BROKER 0: The shared memory segment is not locked in memory. (10014)
09:07:47 BROKER 0: Current Size of Lock Table (-L): 56000. (4241)
09:07:47 BROKER 0: Hash Table Entries (-hash): 18289. (4242)
09:07:47 BROKER 0: Current Spin Lock Tries (-spin): 15000. (4243)
09:07:47 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
09:07:47 BROKER 0: Crash Recovery (-i): Enabled. (4244)
09:07:47 BROKER 0: Database Blocksize (-blocksize): 8192. (6573)
09:07:47 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
09:07:47 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
09:07:47 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
09:07:47 BROKER 0: Before-Image Cluster Size: 4194304. (4250)
09:07:47 BROKER 0: Before-Image Block Size: 8192. (4251)
09:07:47 BROKER 0: Number of Before-Image Buffers (-bibufs): 200. (4252)
09:07:47 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
09:07:47 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
09:07:47 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
09:07:47 BROKER 0: Number of After-Image Buffers (-aibufs): 300. (4256)
09:07:47 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
09:07:47 BROKER 0: Maximum Number of Clients Per Server (-Ma): 15. (4257)
09:07:47 BROKER 0: Maximum Number of Servers (-Mn): 31. (4258)
09:07:47 BROKER 0: Minimum Clients Per Server (-Mi): 5. (4259)
09:07:47 BROKER 0: Maximum Number of Users (-n): 76. (4260)
09:07:47 BROKER 0: Host Name (-H): TEST. (4261)
09:07:47 BROKER 0: Service Name (-S): dbtest. (4262)
09:07:47 BROKER 0: Network Type (-N): tcp. (4263)
09:07:47 BROKER 0: Character Set (-cpinternal): iso8859-1. (4264)
09:07:47 BROKER 0: Parameter File: /dbadmin/tst/db.pf. (4282)
09:07:47 BROKER 0: Minimum Port for Auto Servers (-minport): 18001. (5648)
09:07:47 BROKER 0: Maximum Port for Auto Servers (-maxport): 23000. (5649)
09:07:47 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
I created test databases as per application team request.Before releasing these databases i have taken offline backup .But for larger databases backup is running for very long.
Can i know reason why backup is running for long.
for Ex:
Database size is 65GB.
To take offline backup it is taken 5 Hours.
Our version is old 9.1e
We checked with OS team server side everything is fine
Server memory 3 GB used out of 3.5 GB and paging space is used 21% out of 4.6GB
Db.pf
======================
-B 65000 # Number of (8K) Blocks in database buffer
-bibufs 200 # Number of before-image buffers
-aibufs 300 # Number of after-image buffers
-Mi 1 # Min processes on a client server
-Ma 15 # Max number of REMOTE clients per db server
-Mn 30 # Max number of REMOTE client servers
-Mxs 32768 # Shared memory overflow size (override)
-spin 15000 # Number of spin lock retries
-L 56000 # Lock Table entries
db.lg
09:07:33 BROKER 0: Multi-user session begin. (333)
09:07:33 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
09:07:46 BROKER 0: Physical Redo Phase Completed at blk 833 off 2628 upd 0. (7161)
09:07:46 BROKER 0: Started for tstslc using tcp, pid 198472. (5644)
09:07:46 WDOG 31: Started. (2518)
09:07:47 BROKER 0: Progress OpenEdge Release 9.1E on AIX. (4234)
09:07:47 BROKER 0: Server started by pgresdba on batch. (4281)
09:07:47 BROKER 0: Started using pid: 1864. (6574)
09:07:47 BROKER 0: Physical Database Name (-db): /dbadmin/tst/db. (4235)
09:07:47 BROKER 0: Database Type (-dt): PROGRESS. (4236)
09:07:47 BROKER 0: Force Access (-F): Not Enabled. (4237)
09:07:47 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
09:07:47 BROKER 0: Number of Database Buffers (-B): 55000. (4239)
09:07:47 BROKER 0: Maximum private buffers per user (-Bpmax): 64. (9422)
09:07:47 BROKER 0: Excess Shared Memory Size (-Mxs): 33554432. (4240)
09:07:47 BROKER 0: The shared memory segment is not locked in memory. (10014)
09:07:47 BROKER 0: Current Size of Lock Table (-L): 56000. (4241)
09:07:47 BROKER 0: Hash Table Entries (-hash): 18289. (4242)
09:07:47 BROKER 0: Current Spin Lock Tries (-spin): 15000. (4243)
09:07:47 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
09:07:47 BROKER 0: Crash Recovery (-i): Enabled. (4244)
09:07:47 BROKER 0: Database Blocksize (-blocksize): 8192. (6573)
09:07:47 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
09:07:47 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
09:07:47 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
09:07:47 BROKER 0: Before-Image Cluster Size: 4194304. (4250)
09:07:47 BROKER 0: Before-Image Block Size: 8192. (4251)
09:07:47 BROKER 0: Number of Before-Image Buffers (-bibufs): 200. (4252)
09:07:47 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
09:07:47 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
09:07:47 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
09:07:47 BROKER 0: Number of After-Image Buffers (-aibufs): 300. (4256)
09:07:47 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
09:07:47 BROKER 0: Maximum Number of Clients Per Server (-Ma): 15. (4257)
09:07:47 BROKER 0: Maximum Number of Servers (-Mn): 31. (4258)
09:07:47 BROKER 0: Minimum Clients Per Server (-Mi): 5. (4259)
09:07:47 BROKER 0: Maximum Number of Users (-n): 76. (4260)
09:07:47 BROKER 0: Host Name (-H): TEST. (4261)
09:07:47 BROKER 0: Service Name (-S): dbtest. (4262)
09:07:47 BROKER 0: Network Type (-N): tcp. (4263)
09:07:47 BROKER 0: Character Set (-cpinternal): iso8859-1. (4264)
09:07:47 BROKER 0: Parameter File: /dbadmin/tst/db.pf. (4282)
09:07:47 BROKER 0: Minimum Port for Auto Servers (-minport): 18001. (5648)
09:07:47 BROKER 0: Maximum Port for Auto Servers (-maxport): 23000. (5649)
09:07:47 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)