Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between off-line back up and on-line
back up in ibm db2 udb?
- 2 Answers
- 8921 Views
- Zenith, I also Faced
- E-Mail Answers
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
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you enable flashback feature?
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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What the different components in replication and what is their use? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you implement fine-grained auditing?
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 a session indicate its interest in receiving alerts?
Where would you look for errors from the database engine?
What is a system database and what is a user database? : sql server DBA
What is the importance of a recovery model? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the different ways you can create databases in sql server? : sql server DBA
