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
Answer / vaishnav
4. No. B'coz for online Backups database should be in
ARCHIVELOG mode.
Is This Answer Correct ? | 54 Yes | 5 No |
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 |
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 |
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 |
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 |
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 |
Answer / srihari macha
1. Backup are Cold and Hot.
2. Cold Backup
3. No.
4. No.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / harshith
1.logical backup
expdp
2.physical backup
rman
hot backup
cold backup
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
What is the difference between the SQL Loader and IMPORT utilities?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
How do you trace the traffic hitting a sql server? : sql server DBA
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?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
What is the importance of a recovery model? : sql server DBA
What authentication modes does sql server support? : sql server DBA
orra 1555 what is this error,why it is occur?
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
what is the difference between hot backup n rman backup?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?