Showing posts with label Backing Up Backup Sets with RMAN. Show all posts
Showing posts with label Backing Up Backup Sets with RMAN. Show all posts

Upgrade Oracle Database 10g to 11g R1 (11.1.X)


Upgrade Oracle Database 10g to 11g R1 (11.1.X)
Posted in January 22nd, 2009
This post covers step by step upgrade of Oracle Database from version 10g (10.2.0.1) to 11g R1 (11.1.0.6) on Unix. You can use this document (with few additional steps mentioned in upgrade guide) to upgrade from 9i or for database on Windows Operating System.
.
Important points before you start 11g upgrade

1. Read Chapter 1, 2 & 3 of Database Upgrade Guide here 
here
2. Read 11g Installation Guide for your operating system from 
here
3. Direct Upgrade is possible from 10.2.0.1 and higher
4. There are two methods to upgrade database 

Backing Up Backup Sets with RMAN


Backing Up Backup Sets with RMAN
Use the BACKUP BACKUPSET command to back up backup sets produced by other backup jobs. This command is especially useful in the following scenarios:
  • Ensuring that all backups exist both on disk and on tape
  • Moving backups from disk to tape and then freeing the space on disk

Note:
You cannot duplex backups when running BACKUP BACKUPSET. RMAN always makes one and only one copy on the specified media when performing BACKUP BACKUPSET.

To back up backup sets from disk to tape:
  1. Assuming that you have configured an automatic sbt channel, issue the BACKUP BACKUPSET command at the RMAN prompt. This example backs up all disk backup sets to tape:
2. RMAN> BACKUP DEVICE TYPE sbt BACKUPSET ALL;
3.  
This example backs up all disk backup sets to tape and then deletes the input disk backups:
RMAN> BACKUP DEVICE TYPE sbt BACKUPSET ALL DELETE INPUT;

  1. Issue a LIST command to see a listing of backup sets and pieces.