RMAN backup & Restoration for Database Upgrade

Steps for RMAN backup & Restoration for Database Upgrade. This document is only to verify Backup & Restoration activity.

How to check oracle version ?

[oracle@ ~]$ sqlplus /nolog

SQL*Plus: Release Production on Wed Oct 5 20:15:33 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Here shows Oracle version is else if is shown Oracle version is

Backup Activity:

Below steps should be performed on Oracle version Oracle Home.

1. $ export ORACLE_SID={instance_name}

2. $ rman "target / nocatalog"

3. RMAN> run {
  shutdown immediate;
startup mount;
backup database format '{Backup Path}/%d_before_upgrade_%U' tag=Before_upgrade;
backup current controlfile tag = Before_upgrade format '{Backup Path}/cf_%u';
shutdown immediate;
startup ;

4. sq> shutdown immediate

Upgrade Activity:

Copy spfile, password  files from Oracle to Oracle home.

1. Go to ORACLE_HOME for Oracle using.

   $ export ORACLE_HOME={Path_Oracle_home}

2. $ export ORACLE_SID={instance_name}

3. $ cd $ORACLE_HOME/bin

   $ ./sqlplus sys as sysdba

4. sql> startup upgrade

5. sql> $ORACLE_HOME/rdbms/admin/catupgrd.sql

   Note: This Upgrade process will take around 45 to 50 Minutes. When successfully done database will be down. Please start
   the database and check for its version. The database version must be and shutdown the database.

Restore activity:

In case of failed upgradation, database needs to bring back to its lower version (Oracle We need to do restoration of database.

1. Go to Oracle version Oracle Home.

2. $ export ORACLE_SID={instance_name}

3. $ rman "target / nocatalog"

4. rman> startup nomount;

5. rman> run {
  restore controlfile from '{Backup Path}/{control_file_backup}' ;
alter database mount;
alter database open resetlogs;

6. Check database is opened in Oracle version.

No comments:

Post a Comment