Solved

backup

Posted on 2013-11-14
3
517 Views
Last Modified: 2013-11-17
what is the difference between..

Cumilative level 1 backup, cumulative level 2 backup, cumulative level 0 backup
0
Comment
Question by:dev_dba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
Geert Gruwez earned 500 total points
ID: 39650465
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
 

Author Closing Comment

by:dev_dba
ID: 39655466
level1 backup under stood..
backup of till last transaction from the level 0 backup..
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 39655669
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

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Migration from sql server to oracle 5 51
Updating a temp table inside a PL/SQL block 3 64
What are the limitations of input parameters in oracle ? 5 85
replicate in oracle 13 45
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question