April 1999
Intermediate to advanced
584 pages
23h 17m
English
Content preview from Oracle Database Administration: The Essential RefeBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Disk failure
A disk failure is the most common form of database failure. With the cost of RAID solutions (including mirroring and parity solutions such as RAID-1 and RAID-5) coming down, most sites have moved to a hardware solution to prevent a single disk failure from impacting the database. If your site does not use these solutions, then at some point in your career you will have to perform a recovery from a disk failure.
We recommend multiple control files, separate disks for archive files, and mirroring redo logs either with redo log groups or operating system mirroring. With mirrored redo logs and multiple control files on separate disks, no single disk failure will cause a loss of the database. If you have only one control file or only one redo member per group, then losing the disk containing the control file or the active redo log would be catastrophic to the database. Placing archive files on a separate disk from the redo logs (if mirroring is not used) at least ensures that you can recover the database up to the point of the last archive file.
In the case of a disk failure, you have the following options:
Restore the datafile to a new disk, rename it using the ALTER DATABASE RENAME DATAFILE command, and recover the file using archive files and online redo logs.
If you are not running in archivelog mode, you can still use the tablespace point-in-time recovery procedure from a cold backup.
Recover the entire database using a cold backup.
Place the tablespace containing the missing ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.