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
which background process invoke at the time of upgradation tell me???
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how can you initialize log miner?
Why does Oracle not permit the use of PCTUSED with indexes?
Can you redefine a table online?
What are the operating modes in which database mirroring runs? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Which autogrowth database setting is good? : 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?
when does an alert gets signaled?
what are the benefits of flashback feature?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
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?