• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 542
  • Last Modified:

backup

what is the difference between..

Cumilative level 1 backup, cumulative level 2 backup, cumulative level 0 backup
0
dev_dba
Asked:
dev_dba
  • 2
1 Solution
 
Geert GOracle dbaCommented:
level 0 backup is a full backup of the datafiles
level 1 backup is a backup of all the change since the last level 0 backup or the last level 1 backup

here is a full explanation of the different ways of cumulative backups
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#sthref707

i've never heard of a level 2
0
 
dev_dbaAuthor Commented:
level1 backup under stood..
backup of till last transaction from the level 0 backup..
0
 
Geert GOracle dbaCommented:
well you can actually ask rman to backup from a certain point in time (scn) to a certain point in time
rman> backup incremental level 1 database from scn xxxx;

this backups the database from that change number
> handy if archivelogs get lost and you need to apply them on a standby
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now