1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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?

Question Posted / narmada


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

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

Why would you use sql agent? : sql server DBA

0 Answers  

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

What is the default fill factor value? : sql server DBA

0 Answers  

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  




What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

What purpose does the model database server? : sql server DBA

0 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

How many memory layers are in the shared pool?

3 Answers  

what is grd?

0 Answers   Oracle,

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

Explain the concept of the DUAL table.

3 Answers  

For more DB Administration Interview Questions Click Here
Categories