Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

Shaikh Ziya

• Nov 22nd, 2011

Yes We can Take of Controlfile Online Mode Just
Fire The Command alter database backup controlfile trace And
alter database backup controlfile as trace '/Location where u want 2 take backup of ctlfile/';

sulbha singh

• Sep 22nd, 2011

No, we can not take backup of redo log files even database is running in archive log mode because of inconsistency

Answer Question  Select Best Answer

Can you take online backup of a Control file if yes, how? Explain about Logical Backup?

bapiora

 Profile Answers by bapiora Questions by bapiora

• Jun 29th, 2009

During database online you perform logical online backup for control file. ALTER DATABASE CONTROLFILE TO TRACE Through this command you perform  control file trace backup which is logical.

impalor

 Profile Answers by impalor Questions by impalor

• Dec 9th, 2008

You could use alter database backup controlfile for a binary copy of control file.

Answer Question  Select Best Answer

SHIMAR

• Apr 17th, 2012

DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop

Venki

• Dec 19th, 2011

DDL means "Data Definition Language". SELECT, UPDATE, INSERT belong to DML, which is "Data Modification Language". DDL is all the other commands -- for example, CREATE TABLE.

Answer Question  Select Best Answer