Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between online backup & offline backup?
- 3 Answers
- 11065 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kittu_chintu2005
online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running
offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / mogal
as said above every thing is same but one more point. i.e
" in a hot backup it have fractured blocks and where as in
cold backup there is no fractured blocks"
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
What is replication? : sql server DBA
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
How can we know the exact updation date of a particular database?
what is the differnce between process and thread ?
What are the ways tablespaces can be managed and how do they differ?
who owns the operating system files created by the utl_file package?
What are statistics, under what circumstances they go out of date, how do you update them?
how can you initialize log miner?
What are the steps you will take to improve performance of a poor performing query?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
