March 1999
Intermediate to advanced
528 pages
14h 39m
English
Content preview from Oracle SQL*Plus: The Definitive GuideBecome 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.
Database Backup and Recovery
Beginning with version 8.1, SQL*Plus implements commands to manage the archiving of redo log files and to perform point-in-time recovery of a database. In order to understand how these commands work, and to place them in their proper context, you need to understand something of how backup and recovery work in an Oracle environment.
This section explains the two fundamental approaches to backing up an Oracle database, and shows you how SQL*Plus may fit into your backup process. Archive logging will be explained, and you will see how SQL*Plus can be used to start, stop, and monitor that process. Finally, you will see how the SQL*Plus RECOVER command can be used to apply archive logs to a restored database in order to get up-to-the-minute recovery.
If you are responsible for backing up an Oracle database, please do not depend on just this one chapter to show you how to do that properly. There are several excellent books on the subject. One you should become very familiar with is the Oracle8 Backup and Recovery Guide — it’s one of the manuals in the Oracle documentation set. Another book worth looking at is the Oracle8 Backup and Recovery Handbook, by Rama Velpuri and Anand Adkoli (Oracle Press, 1998). In addition, Oracle offers the three-day-long Oracle8 Backup and Recovery Workshop.
Tip
Of all the things that a database administrator is responsible for, protecting the data is probably first on the list.
The discussion of backup and recovery in this chapter ...
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.