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 / ashok
logical backups:... exp imp datapump
physical backup:... cold,hot rman
2)cold only
3)no
4) no
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
suppose you want to audit specific activities on sensitive data. How can you achieve that?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What the different components in replication and what is their use? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Why would you use sql agent? : sql server DBA
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.
how can a session indicate its interest in receiving alerts?
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
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
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 would you do with an "in-doubt" distributed transaction?
What are statistics, under what circumstances they go out of date, how do you update them?
Which autogrowth database setting is good? : sql server DBA