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?
Answer Posted / gangaram
1- types of backup are cold backup and hot backup.
2-cold backup
3-no u cant take partial backup. but u can have a
tablespace back up . u need to make the tablespace offline
and then begin backup of tablespace.
4-no the database should be in archive log mode always.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
how can you find out if a table can be redefined?
What is dbcc? : sql server DBA
what are the performance views in an oracle rac environment?
What is the default fill factor value? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what is grd?
What are the different ways you can create databases in sql server? : sql server DBA
what are the differences of where and if in SAS?
what is a user-defined lock?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
what is asm?
What types of replication are supported in sql server? : sql server DBA
Query processing is slow(eg select query)how will u solve that
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?