1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is the difference between online backup & offline backup?

Question Posted / suman

Answer Posted / suman

we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are statistics, under what circumstances they go out of date, how do you update them?

1808

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?

1559

What are the commands used in dcl? : sql server DBA

579

Explain about your sql server dba experience? : sql server DBA

549

what are the differences of where and if in SAS?

1664




What are the different ways you can create databases in sql server? : sql server DBA

599

what are the performance views in an oracle rac environment?

559

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?

2033

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2063

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

614

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1869

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

582

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1973

Where would you look for errors from the database engine?

2356

Why would you use sql agent? : sql server DBA

580