What is the difference between online backup & offline backup?
Answer Posted / 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 |
Post New Answer View All Answers
what are the performance views in an oracle rac environment?
how can you communicate with operating system files from oracle?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What is the importance of a recovery model? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What happens on checkpoint? : sql server DBA
What is a system database and what is a user database? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
internal architecture
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the different types of indexes available in sql server? : sql server DBA
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.
What the different types of replication and why are they used? : sql server DBA