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?

Answers were Sorted based on User's Feedback



Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / vaishnav

4. No. B'coz for online Backups database should be in
ARCHIVELOG mode.

Is This Answer Correct ?    54 Yes 5 No

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / muhammad masood

1-HOT BACKUP AND COLD BACKUP
2- Cold
3- No... Should take complete backup as no incarnation
level is defined.
4- No without Archive loging.

Is This Answer Correct ?    34 Yes 1 No

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / guest

2.cold backup
4.No

Is This Answer Correct ?    24 Yes 2 No

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / 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

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / 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

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / vinay prakash

1.cold backup, hot backup

2.cold backup

3.No

4. no (in Archivelog mode backup is in online)

Is This Answer Correct ?    10 Yes 2 No

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / ashok

logical backups:... exp imp datapump
physical backup:... cold,hot rman

2)cold only

3)no

4) no

Is This Answer Correct ?    7 Yes 1 No

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / srihari macha

1. Backup are Cold and Hot.
2. Cold Backup
3. No.
4. No.

Is This Answer Correct ?    5 Yes 1 No

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / harshith

1.logical backup
expdp

2.physical backup
rman
hot backup
cold backup

Is This Answer Correct ?    1 Yes 1 No

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then..

Answer / sree

1. physical and Logical backup
2.cold backup
3.No.. we can't take partial backup in no archivelog mode
4.No... we can't take online backups if the database running in noarchivelog mode.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what r the types of backup?

5 Answers   CSC,


by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,


suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,


what is rebuild index??

2 Answers   IBM, Sapient,


You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  


i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,


What are the different types of indexes available in sql server? : sql server DBA

0 Answers  


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  


How can you enable a trace for a session?

1 Answers  


how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,


An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  


What's the benefit of "dbms_stats" over "analyze"?

1 Answers  


Categories