Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Oracle Database XE 11gR2 Jump Start Guide

You're reading from  Oracle Database XE 11gR2 Jump Start Guide

Product type Book
Published in Jul 2012
Publisher Packt
ISBN-13 9781849686747
Pages 146 pages
Edition 1st Edition
Languages
Author (1):
Asif Momen Asif Momen
Profile icon Asif Momen

Table of Contents (20) Chapters

Oracle Database XE 11gR2 Jump Start Guide
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Database Editions and Oracle Database XE Installing and Uninstalling Oracle Database XE Connecting and Configuring Oracle Database 11g XE Accessing Table Data, DML Statements, and Transactions Creating and Managing Schema Objects Developing Stored Subprograms and Triggers Building a Sample Application with Oracle Application Express Managing Database and Database Storage Moving Data between Oracle Databases Upgrading Oracle Database 11g XE to Other Database Editions Backup and Recovery Tuning Oracle Database 11g XE Features Available with Oracle Database 11g XE

Backing up the ARCHIVELOG database


Let us first place the database in the ARCHIVELOG mode before backing up the database. We have already gone through the procedure of placing the database in the ARCHIVELOG mode earlier in this chapter.

Switch a few log files after opening the database using ALTER SYSTEM SWITCH LOGFILE and look for new archived redo log files in the C:\oraclexe\app\oracle\fast_recovery_area\XE\ARCHIVELOG\ folder.

Now our database is ready for the backup. Let us now take a manual backup instead of using the Oracle Database XE-supplied backup script. Log in to the RMAN session, connect to the target database, and run the backup command.

The following is the simple backup command that we will use to back up our database:

-- RMAN back command to backup database and archive logs
RMAN> backup database plus archivelog;

Alternatively, you can specify the backup location using the FORMAT clause. %U generates unique filenames for the backup pieces as follows:

RMAN> backup database...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}