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?



Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / kittu

1. Logical Backups(traditional backups of oracle)export/import, datapump physical backup hot backup(online backup), cold backup(offline backup), RMAN backup

2. cold backup & logical backups

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what is meant by gateway

1 Answers   IBM,


What is the dataguard background process??

1 Answers   iGate,


What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  


How would you determine the time zone under which a database was operating?

2 Answers  


What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  






How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  


If CPU is very slow What can u do to speed up?

1 Answers  


What column differentiates the V$ views to the GV$ views and how?

3 Answers  


by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,


I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  


What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  


Categories