| >How about: I don't know what version you are using,
I tested it on pre V7.0-01, V6.0-15, V6.1-04
>but it works just FINE for me with Rdb7.
?!? what does it mean, you got the RMU-F ?
?!? is "aij_file.aij.version" allowed ?
/Jean-Luc
--------------- script in .0 with set verify --------------
$ set ver
$ mc sql$
sho ver
Current version of SQL is: Oracle Rdb SQL V7.0-01
drop data filenam tst;
%RDB-E-BAD_DB_FORMAT, tst does not reference a database known to Rdb
-RMS-E-FNF, file not found
crea data filenam tst;
crea table t1 (col1 int, col2 int);
crea unique index y1 on t1 (col1);
commit;
exit;
$ delete/noconfirm/log tst_aij.aij.*
%DELETE-W-SEARCHFAIL, error searching for RDB$ROOT2:[70]TST_AIJ.AIJ;*
-RMS-E-FNF, file not found
$!
$! file=tst_aij.aij;1 including version number.
$! **
$ rmu/set after/enable/add=(name=tst,file=tst_aij.aij;1,allo=512) tst
%RMU-W-AIJDEVDIR, AIJ filename "TST_AIJ.AIJ;1" does not include a device/directory
%RMU-I-LOGCREAIJ, created after-image journal file _CHSR36$DKA500:[JSUBRI.70]TST_AIJ.AIJ;1
%RMU-I-LOGMODSTR, added after-image journal definition "TST"
%RMU-I-LOGMODSTR, activated after-image journal "TST"
%RMU-I-LOGMODFLG, enabled after-image journaling
%RMU-W-DOFULLBCK, full database backup should be done to ensure future recovery
$ rmu/backup tst tst
%RMU-I-BCKTXT_01, Thread 1 uses devices RDB$ROOT2:
%RMU-I-BCKTXT_08, Thread 1 was assigned file RDB$ROOT2:[70]TST.RDB;1
%RMU-I-BCKTXT_00, Backed up root file
%RMU-I-BCKTXT_02, Full backup of storage area (RDB$SYSTEM) RDB$ROOT2:[70]TST.RDB;1
%RMU-I-BCKTXT_02, Full backup of storage area (RDB$SYSTEM) RDB$ROOT2:[70]TST.RDB;1
%RMU-I-BCKTXT_04, ignored 1 space management page
%RMU-I-BCKTXT_05, backed up 3 inventory pages
%RMU-I-BCKTXT_06, backed up 144 logical area bitmap pages
%RMU-I-BCKTXT_07, backed up 456 data pages
%RMU-I-BCKTXT_11, backup data compression ratio: 0.46
$ mc sql$
attach 'f tst';
set transaction read write;
begin
declare :n integer ;
set :n = 0;
while :n < 10
loop
insert into t1 (col1,col2) values (:n , :n+1 );
set :n = :n + 1;
end loop;
commit;
end;
exit;
$ rmu/back/after/log tst tst_aij.aij_bck ! backup OK
%RMU-I-AIJBCKBEG, beginning after-image journal backup operation
%RMU-I-OPERNOTIFY, system operator notification: Oracle Rdb Database RDB$ROOT2:[70]TST.RDB;1 Event Notification
AIJ backup operation started
%RMU-I-AIJBCKSEQ, backing up after-image journal sequence number 0
%RMU-I-LOGBCKAIJ, backing up after-image journal TST at 09:44:12.59
%RMU-I-LOGCREBCK, created backup file RDB$ROOT2:[70]TST_AIJ.AIJ_BCK;1
%RMU-I-QUIETPT, waiting for database quiet point
%RMU-I-AIJMODSEQ, next AIJ file sequence number will be 1
%RMU-I-LOGAIJBCK, backed up 1 committed transaction at 09:44:13.28
%RMU-I-OPERNOTIFY, system operator notification: Oracle Rdb Database RDB$ROOT2:[70]TST.RDB;1 Event Notification
AIJ backup operation completed
%RMU-I-AIJBCKEND, after-image journal backup operation completed successfully
%RMU-I-LOGAIJJRN, backed up 1 after-image journal at 09:44:13.35
%RMU-I-LOGAIJBLK, backed up 6 after-image journal blocks at 09:44:13.35
%RMU-I-LOGAIJBCK, backed up 1 committed transaction at 09:44:13.35
$ mc sql$
alter database filename tst journal is enable (fast commit is enable);
exit;
$ rmu/backup tst tst
%RMU-I-BCKTXT_01, Thread 1 uses devices RDB$ROOT2:
%RMU-I-BCKTXT_08, Thread 1 was assigned file RDB$ROOT2:[70]TST.RDB;1
%RMU-I-BCKTXT_00, Backed up root file
%RMU-I-BCKTXT_02, Full backup of storage area (RDB$SYSTEM) RDB$ROOT2:[70]TST.RDB;1
%RMU-I-BCKTXT_02, Full backup of storage area (RDB$SYSTEM) RDB$ROOT2:[70]TST.RDB;1
%RMU-I-BCKTXT_04, ignored 1 space management page
%RMU-I-BCKTXT_05, backed up 3 inventory pages
%RMU-I-BCKTXT_06, backed up 144 logical area bitmap pages
%RMU-I-BCKTXT_07, backed up 456 data pages
%RMU-I-BCKTXT_11, backup data compression ratio: 0.46
$ rmu/back/after/log tst tst_aij.aij_bck ! backup KO
%RMU-I-AIJBCKBEG, beginning after-image journal backup operation
%RMU-I-OPERNOTIFY, system operator notification: Oracle Rdb Database
RDB$ROOT2:[70]TST.RDB;1 Event Notification
AIJ backup operation started
%RMU-I-AIJBCKSEQ, backing up after-image journal sequence number 1
%RMU-I-LOGBCKAIJ, backing up after-image journal TST at 09:44:26.66
%RMU-I-LOGCREBCK, created backup file RDB$ROOT2:[70]TST_AIJ.AIJ_BCK;2
%RMU-W-AIJDEVDIR, AIJ filename "TST_AIJ.AIJ;1" does not include a device/directory
%RMU-I-AIJBCKSTOP, backup of after-image journal TST did not complete
%RMU-I-OPERNOTIFY, system operator notification: Oracle Rdb Database
RDB$ROOT2:[70]TST.RDB;1 Event Notification
AIJ manual backup operation failed
%RMU-F-FILACCERR, error creating after-image journal file
_CHSR36$DKA500:[JSUBRI.70]TST_AIJ.AIJ;1
-RMS-E-FEX, file already exists, not superseded
%RMU-F-FTL_BCK, Fatal error for BACKUP operation at 19-FEB-1997 09:44:27.10
|