we are using the following archive job to have weeklty backup for objects definitions:
ARCHIVE DICTIONARY TABLES
(DBC) ALL ,
RELEASE LOCK,
FILE=ARCHIVE;
Surprisingly it results in FULL DATA archive for tables, i see the archive size for huge tables simillar as it is on production.
From TaraGUI log displayed:
04/27/2012 13:59:36 ARCHIVE DICTIONARY TABLES
04/27/2012 13:59:36 (DBC) ALL ,
04/27/2012 13:59:36 RELEASE LOCK,
04/27/2012 13:59:36 FILE=ARCHIVE;
04/27/2012 13:59:37 EXCLUDED "DBC"
04/27/2012 13:59:37 EXCLUDED "SYSUDTLIB"
04/27/2012 13:59:37 UTILITY EVENT NUMBER - 1718327
04/27/2012 13:59:42 LOGGED ON 15 SESSIONS
04/27/2012 13:59:42 ARCHIVE MAPPED TO ...
.
...
04/27/2012 14:07:32 ARCHIVING DATABASE "DB1"
04/27/2012 14:07:43 TABLE "TABLE1" - 3,408 BYTES ARCHIVED
.....
04/27/2012 15:02:36
04/27/2012 15:02:36 STREAM TOTALS:
04/27/2012 15:02:36 TABLE "TABLE1" - 3,211,281,800,552 BYTES, 36,275,357,572 ROWS ARCHIVED TOTAL
Is there's something i'm missing here,
Regards
It's a problem with my archive script, dictionary archive require single stream while my mistake was specifying muliple streams.
we are using the following archive job to have weeklty backup for objects definitions:
ARCHIVE DICTIONARY TABLES
(DBC) ALL ,
RELEASE LOCK,
FILE=ARCHIVE;
Surprisingly it results in FULL DATA archive for tables, i see the archive size for huge tables simillar as it is on production.
From TaraGUI log displayed:
04/27/2012 13:59:36 ARCHIVE DICTIONARY TABLES
04/27/2012 13:59:36 (DBC) ALL ,
04/27/2012 13:59:36 RELEASE LOCK,
04/27/2012 13:59:36 FILE=ARCHIVE;
04/27/2012 13:59:37 EXCLUDED "DBC"
04/27/2012 13:59:37 EXCLUDED "SYSUDTLIB"
04/27/2012 13:59:37 UTILITY EVENT NUMBER - 1718327
04/27/2012 13:59:42 LOGGED ON 15 SESSIONS
04/27/2012 13:59:42 ARCHIVE MAPPED TO ...
.
...
.
.
04/27/2012 14:07:32 ARCHIVING DATABASE "DB1"
04/27/2012 14:07:43 TABLE "TABLE1" - 3,408 BYTES ARCHIVED
.....
04/27/2012 15:02:36
04/27/2012 15:02:36 STREAM TOTALS:
04/27/2012 15:02:36 TABLE "TABLE1" - 3,211,281,800,552 BYTES, 36,275,357,572 ROWS ARCHIVED TOTAL
Is there's something i'm missing here,
Regards