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
- 31220 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what functionality does oracle provide to secure sensitive information?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What happens on checkpoint? : sql server DBA
What is replication? : sql server DBA
how can you create a user-defined lock?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how can you process messages in order asynchronously?
What are the different ways you can create databases in sql server? : sql server DBA
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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
