Perform the Installing Oracle Database 10g on Windows tutorial.

Download and unzip the rman.zip file into your working directory (c:\wkdir).

Log in to Enterprise Manager Database Console by opening your browser and entering the following URL:

http://localhost:1158/em

Enter sys/oracle as SYSDBA and click Login.

The Oracle Database Home page allows you to view the current state of the database by displaying a series of metrics that portray the overall health of the database. The Oracle Database Home page provides a launch point for the database status and administration and configuration of the database environment. It contains four pages via subtabs with each page displaying subsections. Click on the Maintenance tab.

Under Backup/Recovery Settings, click Recovery Settings.

You need to put the database in archivelog mode. In the Media Recovery section, select the ARCHIVELOG Mode check box. Then scroll down to the Flash Recovery Area section.

Scroll down to the Flash Recovery Area region of the page and click Enable Flashback Database. Change the Flashback Retention Time to 6 hours, then click Apply.

Click Yes to restart the database.

Enter your Cluster Credentials as oracle/oracle and Database Credentials as sys/oracle as SYSDBA. Check the box to Save as Preferred Credentials and then click OK.

Click Yes to confirm.

Your database is being restarted. Wait about 10 minutes and click Refresh.

Once you click refresh, the DB Control Home Page appears and you are automatically logged in as the SYS user.

Click the Maintenance tab.

Select Backup Settings in the Backup/Recovery Settings region.

Click the Policy tab.

Check Enable block change tracking for faster incremental backups. For the name of the Block Change Tracking File enter <oracle_home>\oradata\<sid>\<filename>. Scroll to the bottom of the page.

Verify the host credentials are set. Check the Save as Preferred Credential option, then click OK.

On the Maintenance page, under Backup/Recovery Settings, click Backup Settings.

Change the Disk Backup Type to Image Copy. Then, to make sure the disk backup interface is working, click Test Disk Backup.

You will see the progress window.

After one minute or less, you see that your Disk Backup Test was successful. Scroll down.

Make sure your Host Credentials are set to oracle/oracle and click OK to save the settings.

Click Schedule Backup in the Backup/Recovery section on the Maintenance page.

To minimize the administrative tasks of performing backups, you will use the Oracle Suggested Backup method. This method schedules a daily backup job that backs up the entire database using the backup settings configured in the previous section.

Click Schedule Oracle-Suggested Backup for the Backup Strategy.

Make sure Disk is selected, then click Next.

Click Next.

Set the time to 5 minutes after the current time, then click Next. Note: you can identify the current time if you look at the DB Control Home Page.

Click Submit Job to schedule the backup.

Your backup job has been submitted. Click View Job .

Click on Reload or Refresh in your browser until the Page Refreshed time shows a time after the scheduled start time of the backup job.

Once your job starts, you can see its progress. Click on the Backup log to see more details about this execution.

Scroll down to see the details.

After the backup has completed successfully in about 7 minutes, click the Database tab at the bottom of the page.

Note: If the backup fails, increase the size of your flash recovery area and try the backup again.

Click Maintenance tab.

In the Backup/Recovery region, click Backup Reports.

A list of backup jobs currently scheduled within the database is displayed. Click on the entry for the full backup.

The report shows summary information for the backup job, such as the number of files backed up, the size of the backup, and the files contained within it. Scroll down to view the Inputs and Outputs sections.

These sections of the report provide more detailed information about the files that were backed up by this job. You can see the file numbers, file size, backup type, number of corrupt blocks and checkpoint SCN information. Scroll down to view the next three sections of the reports.

Now you see information regarding the Backup Sets, Backup Pieces, and Image Copies. Scroll back up to the top of the page.

Click the Database Instance: orcl link.

From the Maintenance tab, under Backup/Recovery Settings, click Recovery Settings.

Scroll down to the Flash Recovery section. You will see a pie chart which contains the usage of the flash recovery area. Notice that because you just performed a backup, the Image Copy is taking up the most space. Scroll up to the top of the page.

Click the Database Instance: orcl link.

Scroll down to the bottom of the page and click Jobs under Related Links.

Select RMAN Script from the Create Job pulldown list and click Go.

For the job name, enter DAILY_ARCH_BACKUP. Enter a description for this job, such as 'Backup archived log files in the flash recovery area'. For the RMAN script, you can either choose to have a saved script executed by typing in @c:\wkdir\backup_arch.rman or you can type in the RMAN script to run, such as the one listed here:

run {
  backup archivelog all delete input format 'c:\wkdir';
}

When finished typing in the information, click Add to specify a database target.

Click the Search button.

Select orcl and click Add.

On the Create 'RMAN Script' Job page, scroll down to the Host and Database Credentials region. Select Override Preferred Credentials and enter oracle/oracle for the Host User Name and Password and confirm the password. Enter sys/oracle for the Database User Name and password and confirm the password. Change the Database Role to SYSDBA then click the Schedule tab.

Select Later for the Start period and set the time to 11:30 pm. In the Repeat region, select Interval and set the Frequency to 1 Days. Then click Submit.

The job is then created and scheduled. To check the current status of the scheduled job, click the Database tab.

On the DB Control Home page, scroll down to the Job Activity region and click the linked number to the right of Scheduled Executions.

On the Job Activity page, you can see that the DAILY_ARCH_BACKUP job is scheduled to run at a later time. Click the Database tab at the top of the page.

Select Start > Programs > Oracle - OraDb10g_home1 > Application Development > SQL Plus. Enter hr/hr for User Name/Password and click OK.

Enter the following command to see the current number of Employees in the HR Schema:

SELECT count(*) FROM hr.employees;
exit

In order to delete a data file, you need to take the tablespace offline, then delete it. Using Enterprise Manager, logged in as a SYSDBA user, click the Administration tab.

To put the database in recovery mode, click the Perform Whole Database Recovery button.

Click Yes to shutdown the database.

The Recovery Wizard page is displayed. Wait about 8 minutes, then click Refresh.

The database was shutdown and started in mount state.

Flashback the database to the restore point created before the HR.JOBS_HIST table was truncated. Open a SQL Plus session and enter the following commands:

connect / as sysdba;
FLASHBACK DATABASE TO RESTORE POINT before_trunc;

When the FLASHBACK command completes, open the database using the following command:

ALTER DATABASE OPEN RESETLOGS;

After a few minutes, the database is opened. Enter the following commands to check the contents and structure of the HR.JOBS_HIST table. Notice that the rows are restored, but the recently added column no longer exists.

connect hr/hr
SELECT count(*) FROM hr.jobs_hist;
DESCRIBE hr.jobs_hist;
exit;

Switch back to Enterprise Manager and click the Database tab.

Enter sys/oracle as the User Name and Password. Select SYSDBA as the Connect As and click Login.

The database is now Open.