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

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  


What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  


Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  


7. Where should you place Archive logfiles, in the same disk where DB is or another disk? 8. Can you take online backup of a Control file if yes, how? 9. What is a Logical Backup? 10. Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode? 11. Why do you take tablespaces in Backup mode? 12. What is the advantage of RMAN utility? 13. How RMAN improves backup time? 14. Can you take Offline backups using RMAN? 15. How do you see information about backups in RMAN? 21. Where RMAN keeps information of backups if you are using RMAN without Catalog? 22. You have taken a manual backup of a datafile using o/s. How RMAN will know about it? 23. You want to retain only last 3 backups of datafiles. How do you go for it in RMAN? 24. Which is more efficient Incremental Backups using RMAN or Incremental Export? 25. Can you start and shutdown DB using RMAN? 26. How do you recover from the loss of datafile if the DB is running in NOARCHIVELOG mode? 27. You loss one datafile and it does not contain important objects. The important objects are there in other datafiles which are intact. How do you proceed in this situation? 28. You lost some datafiles and you don't have any full backup and the database was running in NOARCHIVELOG mode. What you can do now? 29. How do you recover from the loss of datafile if the DB is running in ARCHIVELOG mode? 30. You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file? 31. You loss controlfile how do you recover from this? 32. The current logfile gets damaged. What you can do now? 33. What is a Complete Recovery? 34. What is Cancel Based, Time based and Change Based Recovery? 35. Some user has accidentally dropped one table and you realize this after two days. Can you recover this table if the DB is running in ARCHIVELOG mode? 36. Do you have to restore Datafiles manually from backups if you are doing recovery using RMAN? 37. A database is running in ARCHIVELOG mode since last one month. A datafile is added to the database last week. Many objects are created in this datafile. After one week this datafile gets damaged before you can take any backup. Now can you recover this datafile when you don't have any backups? 38. How do you recover from the loss of a controlfile if you have backup of controlfile? 39. Only some blocks are damaged in a datafile. Can you just recover these blocks if you are using RMAN? 40. Some datafiles were there on a secondary disk and that disk has become damaged and it will take some days to get a new disk. How will you recover from this situation? 41. Have you faced any emergency situation. Tell us how you resolved it? 42. At one time you lost parameter file accidentally and you don't have any backup. How you will recreate a new parameter file with the parameters set to previous values. 16. What is a Recovery Catalog? 17. Should you place Recovery Catalog in the Same DB? 18. Can you use RMAN without Recovery catalog? 19. Can you take Image Backups using RMAN? 20. Can you use Backupsets created by RMAN with any other utility?

1 Answers   IBM,


what is ora 600?

1 Answers  


How do you resize a data file?

2 Answers  


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  


Where would you look for errors from the database engine?

0 Answers   IBM,


Categories