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 commands used in dcl? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is a crs resource?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What is a correlated sub-query? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is a system database and what is a user database? : sql server DBA
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
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?