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 / s. manzoor ahamed
1. Type of Backups option in oracle are
Cold backup / Hot (Online) backup, Logical backups
using Exp and imp client utilities, RMAN Backups.
2. Only Cold backup can be taken and no other options.
3. No. Need to take full consistent backup.
4. No. You can't take online backup if the db is configured
in Noarchivelog mode.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
how can you connect from 10g user to 11g user??
What is fill factor? : sql server DBA
what are the differences of where and if in SAS?
what is asm?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What is replication? : sql server DBA
what is the use of ocr?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what do you understand by flashback feature of oracle?