ARCHIVELOG mode

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

Questions by shanthiavari

Showing Answers 1 - 15 of 15 Answers

impalor

  • Dec 9th, 2008
 

Yes, because if an archived log file is corrupt and you need to recover your database, you will have to do incomplete recovery, until the time where archived logs file ar fine.

  Was this answer useful?  Yes

Take backup of redologfiles only when you are doing cold backup not when you are taking hot backup in that case take backup of datafiles and controlfiles (thru backup trace command) and archivelogs.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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/';

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions