RE: The minimum size of the devspaces for backups.

[Heinrich, Tilo]

Hello Dmitri,

 

>There are two output lines of the backup prorgam that I'm curious about. The

>first one is "Pages transfered" and the second one is the "Max page number"

>mentioned above.

 

"Pages Transferred" is the size of the backup (minus an RTE block per used backup medium). "Max Page number" alias "MAX USED DATA PNO" represents the highest used data page number and determines in SAP DB up to version 7.3 the size of the needed converter. Up to SAP DB 7.3 data pages kept their page number and therefore "MAX USED DATA PNO" of a backup defined the minimal size of a database, where that backup could be restored to.

 

>The actual problem is that sometimes the "Max page number" really greater than

>the "Page transferred". Therefore it's resulted in the situation than to hold 6 GB

>of data I have to create the database of about 18 GB. Sometimes it works better

>and "Max page number" is just a bit greater than "Pages transferred". Is there any

>way to ensure before backup that these two numbers will be close enough to avoid

>of allocation of enormous extra space while restoring the database. Is there any params

>that affect this? Does the heavy use of the temporary space before the backup causes

>this situation (the temporary space might be ~8-10 times bigg! ! er than

>RESERVER_REDO_SIZE in my situation).

 

The only solution to that problem is the usage of SAP DB 7.4, as the "MAX USED DATA PNO" restriction is not longer relevant in that version.

 

Best Regards,

Tilo Heinrich

SAP Labs Berlin

 

-----Original Message-----
From: Dmitri Lyssenko [mailto:[EMAIL PROTECTED]
Sent: Dienstag, 25. M�rz 2003 00:27
To: [EMAIL PROTECTED]
Subject: The minimum size of the devspaces for backups.

Hi all,

According to the documentation the minimum size of the database should be determined based on the "Max page number" reported by the backup command (plus 1/2 log devspace * number of devspaces)

There are two output lines of the backup prorgam that I'm curious about. The first one is "Pages transfered" and the second one is the "Max page number" mentioned above. It sounds logical that the minimum size of the devspaces should be determined based on the actual size of the transferred data. However in SAP DB it works differently. The actual problem is that sometimes the "Max page number" really greater than the "Page transferred". Therefore it's resulted in the situation than to hold 6 GB of data I have to create the database of about 18 GB. Sometimes it works better and "Max page number" is just a bit greater than "Pages transferred". Is there any way to ensure before backup that these two numbers will be close enough to avoid of allocation of enormous extra space while restoring the database. Is there any params that affect this? Does the heavy use of the temporary space before the backup causes this situation (the temporary space might be ~8-10 times bigg! ! er than RESERVER_REDO_SIZE in my situation).

I appreciate any advice. Thanks in advance.

Dmitri Lyssenko,

Nuix Pty. Ltd.

 

 

 

 

---

With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs