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

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1640

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1491

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1541

what is a user-defined lock?

584

Why would you call update statistics? : sql server DBA

573




how can you connect from 10g user to 11g user??

1681

What are the steps you will take to improve performance of a poor performing query?

2415

What happens on checkpoint? : sql server DBA

562

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

555

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1969

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1551

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?

2385

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?

1651

How do you troubleshoot errors in a sql server agent job? : sql server DBA

561

what is the use of ocr?

593