what is the difference between off-line back up and on-line
back up in ibm db2 udb?
Answer Posted / 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 |
Post New Answer View All Answers
What purpose does the model database server? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what do you understand by fine-grained auditing?
What are statistics, under what circumstances they go out of date, how do you update them?
Where do you find the default index fill factor and how to change it? : sql server DBA
how to restore files with rman?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different ways you can create databases in sql server? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What the different components in replication and what is their use? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Why would you call update statistics? : sql server DBA
how can you enable flashback feature?
how can you record information about current session?
Why does Oracle not permit the use of PCTUSED with indexes?