Should you take the backup of Logfiles if the database is
running in ARCHIVELOG mode?
Answers were Sorted based on User's Feedback
Answer / amit bhagat
yes, those backup will need during the time of recovery.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / amit bhagat
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 archivelogs
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vijay
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the Symbol use for Inner Join
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
Give two examples of how you might determine the structure of the table DEPT.
What is auto invoicing? : oracle accounts receivable
How to find locks exists in a table or not?
What view would you use to look at the size of a data file?
Where would you look for errors from the database engine?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
How would you go about increasing the buffer cache hit ratio?
what is diff between pre insert,on insert,post insert triggers?
Give the two types of tables involved in producing a star schema and the type of data they hold.