If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Oracle redo logs
Only if you want to ever recover anything.
You should also be backing up the database every day as well. --- W. Curtis Preston Author of O'Reilly's Backup & Recovery and Using SANs and NAS VP Data Protection GlassHouse Technologies -----Original Message----- From: ] On Behalf Of Sent: Tuesday, December 19, 2006 5:55 PM To: Subject: [C.A.S.] Oracle redo logs Hi.. I recently ran into a company that archives (daily) their Oracle redo logs... each log is around 100MB... they have heavy transactions and run 3 rotational logs. So thats about 300MB per day. My question is, do they need to do this? Do they need to archive onto secondary every day's redo log files? I am not a DBA, so I cannot advise them on this topic, but trying to get a feel for standard practices here Jon. _______________________________________________ Subscribe or Unsubscribe to this mailing list he http://backupcentral.com/mailman/lis...e_backupcentra l.com |
#3
|
|||
|
|||
Oracle redo logs
|
#4
|
|||
|
|||
Oracle redo logs
|
#5
|
|||
|
|||
Oracle redo logs
usual (easy) approach is to have a scheduled hard shutdown and backup
of the database at some regular interval (weekly, monthly), Why shutdown? MSSQLServer and Oracle can do hot database backups. More complicated is doing a snapshot backup of the live database. Oracle certainly can do that All database backups in MSSQLServer are such, since version 4.2 of early 90ies. I think Oracle can do this too. -- Maxim Shatskih, Windows DDK MVP StorageCraft Corporation http://www.storagecraft.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Oracle redo logs | [email protected] | Storage & Hardrives | 1 | December 20th 06 05:07 AM |
Determining if there is an IO bottleneck | [email protected] | Storage & Hardrives | 6 | December 6th 06 02:09 PM |
synchronisation of oracle database using snapmirror | flyingleon | Storage & Hardrives | 3 | June 28th 06 12:23 AM |
snap servers and suitability for oracle databases | [email protected] | Storage & Hardrives | 2 | January 5th 06 02:44 PM |
1 dedicated drive (mirrored), or thin stripe for redo filesystems? | [email protected] | Storage & Hardrives | 1 | February 28th 05 05:03 PM |