what is the difference between off-line back up and on-line
back up in ibm db2 udb?
Answer Posted / 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 View All Answers
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how can you find out if a table can be redefined?
what is the use of ocr?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is a correlated sub-query? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Where do you find the default index fill factor and how to change it? : sql server DBA
what is a crs resource?
What are the operating modes in which database mirroring runs? : sql server DBA
Where would you look for errors from the database engine?
What is the default port no on which sql server listens? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What is replication? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.