Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between online backup & offline backup?
- 3 Answers
- 10905 Views
- CSC, I also Faced
- E-Mail Answers
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
How do you open a cluster administrator? : sql server DBA
how can you process messages in order asynchronously?
What is replication? : sql server DBA
What is fill factor? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Which autogrowth database setting is good? : sql server DBA
how can you implement fine-grained auditing?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is a crs resource?
What is the difference between dropping a database and taking a database offline? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Why would you use sql agent? : sql server DBA
what do you understand by fine-grained auditing?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
