| incremental backups not taking place ? [message #403291] |
Thu, 14 May 2009 11:15  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
Incremental backup not taking place.
As can be seen below I took level 0 backup.
Then a incremental level 1 (but it seems all datafiles have been backed-up, and not only the datafile where block change took place)
--
FYI : I made a change in either system or users tablesapce/datafile. (9i database)
--
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Incr 0 192M DISK 00:05:27 14-MAY-09
BP Key: 10 Status: AVAILABLE Tag: INCR0
Piece Name: C:\ORACLE\ORA92\DATABASE\0CKF1EF3_1_1
SPFILE Included: Modification time: 30-APR-09
List of Datafiles in backup set 11
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 307716 14-MAY-09 C:\ORACLE\ORA92\ORCL\SYSTEM01.DBF
2 0 Incr 307716 14-MAY-09 C:\ORACLE\ORA92\ORCL\UNDOTBS01.DBF
3 0 Incr 307716 14-MAY-09 C:\ORACLE\ORA92\ORCL\INDX01.DBF
4 0 Incr 307716 14-MAY-09 C:\ORACLE\ORA92\ORCL\TOOLS01.DBF
5 0 Incr 307716 14-MAY-09 C:\ORACLE\ORA92\ORCL\USERS01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Incr 1 1M DISK 00:03:57 14-MAY-09
BP Key: 11 Status: AVAILABLE Tag: INCR1
Piece Name: C:\ORACLE\ORA92\DATABASE\0DKF1FFN_1_1
SPFILE Included: Modification time: 30-APR-09
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 308535 14-MAY-09 C:\ORACLE\ORA92\ORCL\SYSTEM01.DBF
2 1 Incr 308535 14-MAY-09 C:\ORACLE\ORA92\ORCL\UNDOTBS01.DBF
3 1 Incr 308535 14-MAY-09 C:\ORACLE\ORA92\ORCL\INDX01.DBF
4 1 Incr 308535 14-MAY-09 C:\ORACLE\ORA92\ORCL\TOOLS01.DBF
5 1 Incr 308535 14-MAY-09 C:\ORACLE\ORA92\ORCL\USERS01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13 Incr 2 1M DISK 01:23:44 14-MAY-09
BP Key: 12 Status: AVAILABLE Tag: INCR2
Piece Name: C:\ORACLE\ORA92\DATABASE\0EKF1FRM_1_1
SPFILE Included: Modification time: 30-APR-09
List of Datafiles in backup set 13
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 2 Incr 308836 14-MAY-09 C:\ORACLE\ORA92\ORCL\SYSTEM01.DBF
2 2 Incr 308836 14-MAY-09 C:\ORACLE\ORA92\ORCL\UNDOTBS01.DBF
3 2 Incr 308836 14-MAY-09 C:\ORACLE\ORA92\ORCL\INDX01.DBF
4 2 Incr 308836 14-MAY-09 C:\ORACLE\ORA92\ORCL\TOOLS01.DBF
5 2 Incr 308836 14-MAY-09 C:\ORACLE\ORA92\ORCL\USERS01.DBF[Updated on: Thu, 14 May 2009 21:14] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
