Answer / vaishnav

4. No. B'coz for online Backups database should be in
ARCHIVELOG mode.

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.

Answer / guest

2.cold backup
4.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.

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.

Answer / vinay prakash

1.cold backup, hot backup

2.cold backup

3.No

4. no (in Archivelog mode backup is in online)

Answer / ashok

logical backups:... exp imp datapump
physical backup:... cold,hot rman

2)cold only

3)no

4) no

Answer / srihari macha

1. Backup are Cold and Hot.
2. Cold Backup
3. No.
4. No.

Answer / harshith

1.logical backup
expdp

2.physical backup
rman
hot backup
cold backup

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.

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

What is the importance of a recovery model? : sql server DBA

0 Answers  

How can you gather statistics on a table?

3 Answers  

How do you resize a data file?

2 Answers  

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

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.

0 Answers