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
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 |
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 |
what are the benefits of flashback feature?
Can we take incremental backups in datapump?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Which environment variables are absolutely critical in order to run the OUI?
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?
WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.
How will u copy the objects of one schema to another schema in datapump & export/import?
What would you use to improve performance on an insert statement that places millions of rows into that table?
Where in the Oracle directory tree structure are audit traces placed?
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?
What the different topologies in which replication can be configured? : sql server DBA
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.