what is the difference between off-line back up and on-line
back up in ibm db2 udb?

Answers were Sorted based on User's Feedback



what is the difference between off-line back up and on-line back up in ibm db2 udb?..

Answer / guest

online backup:

1.Inconsistent
2.database in open state.
3.Archive mode must set

offline:

1.consistent
2.db in close
3.No need archive mode

Is This Answer Correct ?    21 Yes 4 No

what is the difference between off-line back up and on-line back up in ibm db2 udb?..

Answer / vishal sharna

offline backup is the traditional backup in which we cannot
take the backup untill the application is closed but its
quite consistent,but as we know its very cost effective to
close all the application and then take the backup,so we
will take the online backup.in this case we an take the
backup of running aplication but set the recovery log mod
to rollforward,with the help of it we can restore our
database to the most recent state.

Is This Answer Correct ?    5 Yes 4 No

Post New Answer

More DB Administration Interview Questions

what are the benefits of flashback feature?

0 Answers   Oracle,


Can we take incremental backups in datapump?

1 Answers  


How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  


Which environment variables are absolutely critical in order to run the OUI?

2 Answers  


A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,


WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,


How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  


What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,


Where in the Oracle directory tree structure are audit traces placed?

1 Answers  


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  


What the different topologies in which replication can be configured? : sql server DBA

0 Answers  


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  


Categories