Answer / sampath

archivelog mode:
archivelog mode means that online redlogfile
copied to another location before overwritten.mainly it use
for recover purpose.

noarchivelog mode:
noarchive logmode means online redlogfile
not copied to another location each time overwritten by lgwr.

Answer / basobdutta

Archivelog mode - In archivelog mode cold and hot backups
are possible. We can recover our database upto the last
point of failure.

Noarchivelog mode- Here we can only go for cold
backup.Generally in this mode complete recovery is not
possible

Answer / neha

in nonarchivelog mode the online redo log file are
overwritten each time a log switch occurs.LGWR does not
overwrite an online redo file group until the checkpoint
for that group is completed.ex-operating system crash
causes an instance crash.

Answer / pv bhaskar

Archivelog mode : We can recover the database at any point
in time.


No Archivelog mode : There is no Recovery Process.

Because Online Redologs are overwritten. so there is no
Archives in this mode.

If there is Media Failure(loss of Disks or files) in this
mode we can restore from a backup but we will loss all
changes made to the database,After the backup was performed.

Answer / niraj chilka

In Archivelog mode we can perform both hot and cold
backup.In this mode we can restore+recover the data.There is
no need to worry about the losing the data.But all it comes
about the performance then we should place the redo log
files on faster disk to avoid performance loss.Try to put
archive on faster disk and also try to commit less.If you
write PL/SQL program that commits after every DML,then your
database will work slow.

In NON archivelog mode we cant recover the database when the
instance crash.Therefore upgrade database to 11g and there
are some has new feature called fast increment
backup.Because of this would loss some instance amount of
data.In non archivelog mode the performance of database is
high.

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  

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

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?

0 Answers  

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

Name two files used for network connection to a database.

5 Answers  

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

0 Answers  

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

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