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?

Answers were Sorted based on User's Feedback



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

Answer / girish k

1. HOT and COLD Backups
2. COLD Backup
3. NO
4. NO

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  


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.

0 Answers   Infosys,


How many packages we have in db

1 Answers   Tesco,


Name three advisory statistics you can collect.

1 Answers  


CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,


what is logical system in sap basis

0 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  


When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  


You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  


how will you see when the database was started using sql prompt?

2 Answers   IBM,


Categories