Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
4. Can you take Online Backups if the the database is
running in NOARCHIVELOG mode?
Answer Posted / s. manzoor ahamed
1. Type of Backups option in oracle are
Cold backup / Hot (Online) backup, Logical backups
using Exp and imp client utilities, RMAN Backups.
2. Only Cold backup can be taken and no other options.
3. No. Need to take full consistent backup.
4. No. You can't take online backup if the db is configured
in Noarchivelog mode.
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What are the different types of indexes available in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is a correlated sub-query? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
what is the use of ocr?
How can you control the amount of free space in your index pages? : sql server DBA
What happens on checkpoint? : sql server DBA
what is asm?
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.
Which autogrowth database setting is good? : sql server DBA
what are the types of connection load-balancing?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the commands used in dcl? : sql server DBA