1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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?

Question Posted / sree

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the commands used in dcl? : sql server DBA

576

What are the different ways you can create databases in sql server? : sql server DBA

599

Explain about your sql server dba experience? : sql server DBA

545

How do you trace the traffic hitting a sql server? : sql server DBA

843

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

592




What is replication? : sql server DBA

622

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?

2389

What would you do with an "in-doubt" distributed transaction?

1417

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1589

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1655

What is fill factor? : sql server DBA

644

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2191

What is the default port no on which sql server listens? : sql server DBA

556

What is transparent data encryption? : sql server DBA

562

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1500