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
Can you redefine a table online?
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?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the use of ocr?
what is a user-defined lock?
What is dcl? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the commands used in dcl? : sql server DBA
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
what is the use of recording information about current session?
how can you connect from 10g user to 11g user??
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you process messages in order asynchronously?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA