Home » RDBMS Server » Backup & Recovery » incremental backups not taking place ?
incremental backups not taking place ? [message #403291] Thu, 14 May 2009 11:15 Go to next message
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

Re: incremental backups not taking place ? [message #403294 is a reply to message #403291] Thu, 14 May 2009 11:36 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Messages: 142
You choose to NOT follow Posting Guideline.

http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Therefore we choose to ignore your posts.

[Updated on: Thu, 14 May 2009 11:43]

Report message to a moderator

Previous Topic: purpose of incremental backup
Next Topic: Need your assitance to CREATE an 10g RMAN level 1 backup script
Goto Forum:
  


Current Time: Sat Dec 03 01:06:38 CST 2016

Total time taken to generate the page: 0.18085 seconds