Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 31725 Views
- I also Faced
- E-Mail Answers
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 type of index should you use on a fact table?
Explain the concept of the DUAL table.
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
What questions might be they ask in managerial round in capgemini.
how will you see when the database was started using sql prompt?
how can you implement fine-grained auditing?
What is the difference between clustered and non-clustered index? : sql server DBA
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
What is dcl? : sql server DBA
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
what is a crs resource?
What is the recommended interval at which to run statspack snapshots, and why?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
