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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you redefine a table online?

667


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1995


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1742


what is the use of ocr?

593


what is a user-defined lock?

585






What is dcl? : sql server DBA

643


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

589


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601


What are the commands used in dcl? : sql server DBA

575


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1642


what is the use of recording information about current session?

566


how can you connect from 10g user to 11g user??

1681


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

1969


how can you process messages in order asynchronously?

555


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

558