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?
- 11 Answers
- 30034 Views
- I also Faced
- E-Mail Answers
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
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
what are the differences of where and if in SAS?
Why would you call update statistics? : sql server DBA
Can you redefine a table online?
What would you do with an "in-doubt" distributed transaction?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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 system database and what is a user database? : sql server DBA
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?
What types of replication are supported in sql server? : sql server DBA
what do you understand by flashback feature of oracle?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is logical system in sap basis
what are the types of connection load-balancing?
