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
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Which autogrowth database setting is good? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you implement fine-grained auditing?
how can you find out if a table can be redefined?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Explain materialized views and how they are used.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is a user-defined lock?
What is the default fill factor value? : sql server DBA
how can you enable flashback feature?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?