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
what is asm?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is a system database and what is a user database? : sql server DBA
What is dcl? : sql server DBA
what is logical system in sap basis
which background process invoke at the time of upgradation tell me???
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What types of replication are supported in sql server? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
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?
What are the commands used in dcl? : sql server DBA
how can you implement fine-grained auditing?
what are the differences of where and if in SAS?