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 supporting issues GL AP and AR?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is the disk migration? what is the steps involved in oracle disk migration?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
Name a tablespace automatically created when you create a database.
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
How do you switch from an init.ora file to a spfile?