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
- 29323 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
What is a system database and what is a user database? : sql server DBA
What is a correlated sub-query? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is the diffrence between core dba and apps dba?
What would you do with an "in-doubt" distributed transaction?
How would you extract DDL of a table without using a GUI tool?
how can you initialize log miner?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
