英语课程虚心12C Rman.docxVIP

Overview ?Purpose In this tutorial you configure your database for backup and recovery operations. You use Recovery Manager (RMAN) to perform backups and recover the database. You also use Oracle Flashback Table to rewind changes to a table and Oracle Flashback Drop to recover a dropped table. Time to Complete Approximately 1 hour Introduction This tutorial shows you how to perform Oracle Database backup and recovery operations by using Oracle Recovery Manager (RMAN). After completing this tutorial, you should be familiar with the basic concepts of Oracle Database backup and recovery operations, know how to implement a disk-based backup strategy, and use Oracle Flashback features. Software Requirements The following is a list of hardware and software requirements: Oracle Database 12c Prerequisites Before starting this tutorial, you should: Have Installed the sample schemas Have completed the other tutorials in this series Connecting to the Target Database ?To perform backup and recovery operations, or to configure backup and recovery settings, you must invoke RMAN and connect to the target database. ? Unlocking the SYSBACKUP User Account ?In this section you connect to the target database as the SYSBACKUP user. If your SYSBACKUP user account is locked, perform the following steps to unlock it: Launch Enterprise Manager Database Express 12c. Login in as the SYSTEM user. Select Users in the Security menu. Select the SYSBACKUP user. In the Actions menu, select Alter Account. Enter a password for the SYSBACKUP user in the Password and Confirm Password fields. Deselect Account Locked. Click OK. Click OK on the Confirmation page. The Users page shows that the SYSBACKUP user account is now unlocked. Invoking RMAN Open a terminal window. Execute the oraenv utility to set the environment variables for the orcl database. Log in to RMAN as the SYSBACKUP user by entering the rman target sysbackup command. Enter the password for the SYSBACKUP user when prompted. Configuring R