tailieunhanh - Oracle® Database Express Edition Getting Started Guide

Control Files The control files include information about the file structure of the database and the current log sequence number being written by LGWR. During normal recovery procedures, the information in a control file guides the automatic progression of the recovery operation. Database Backups Because one or more files can be physically damaged as the result of a disk failure, media recovery requires the restoration of the damaged files from the most recent operating system backup of a database. You can either back up the database files with Recovery Manager (RMAN), or use operating system utilities. RMAN is. | Oracle Database Express Edition Getting Started Guide 10g Release 2 B25610-01 February 2006 Welcome to Oracle Database Express Edition Oracle Database XE This tutorial gets you quickly up and running using Oracle Database XE by creating a simple application. This guide covers the following topics Logging in as the Database Administrator Unlocking the Sample User Account Logging in as the Sample User Account Creating a Simple Application Running Your New Application Using the Oracle Database XE Menus Learning More About Oracle Database XE Documentation Accessibility 1 Logging in as the Database Administrator The first thing you need to do is to log in as the Oracle Database XE Administrator. Follow these steps 1. Open the Database Home Page login window On Windows from the Start menu select Programs or All Programs then Oracle Database 10g Express Edition and then Go To Database Home Page. On Linux click the Application menu on Gnome or the K menu on KDE then point to Oracle Database 10g Express Edition and then Go To Database Home Page. 2. At the Database Home Page login window enter the following information Username Enter system for the user name. Password Enter the password that was specified when Oracle Database XE was installed. 3. Click Login. The Oracle Database XE home page appears. ORACLE 1 2 Unlocking the Sample User Account To create your application you need to log in as a database user. Oracle Database XE comes with a sample database user called HR. This user owns a number of database tables in a sample schema that can be used to create applications for a fictional Human Resources department. However for security reasons this user s account is locked. You need to unlock this account before you can build a sample application. To unlock the sample user account 1. Make sure you are still logged on as the database administrator as described in the previous section. 2. Click the Administration icon and then click Database Users. 3. Click the HR schema