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

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,


How do you open a cluster administrator? : sql server DBA

0 Answers  


What is blocking and how would you troubleshoot it?

1 Answers  


What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  






Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,


How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  


A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,


why Datapump is faster than traditional export and import

4 Answers   Mphasis,


How to make a replica of existing oracle server to another server?

3 Answers  


Categories