R12.1 RESTORE WITH RMAN

 In this article will be explain how to restore R12.1 database and application tires to other host at the following situations

Server Migration

Disaster recovery situations

My environment

Server name                       oftest.xxxxxxx.xx

IP address                          192.168.1.56

R12 instance name             TEST

Here I’m going to migrate the server because of the hard drive space issue

Steps

1 Pre clone the apps and db tiers

2 Copy the R12 oracle home and apps folder to destination server 

3 Take RMAN Full backup and copy backup pieces to the destination server 

4 Install the oracle R12.1 binaries to destination host

5 Shutdown the primary server (oftest.xxxxxxxx.xx)

7 Change the destination server ip address and hostname as primary server     (oftest.xxxxxxx.xx)

 

Then follows the blow step for the complete the restoration

 

su oracle

cd $ORACLE_HOME

Run Environment variable for database

sqlpluse as / sysdba

startup nomount

rman  connect target /

restore controlfile from '/u01/backup/sada/ controlfiles_TEST_66nta5kf_198_20121220'

alter database mount;

crosscheck backup; 

Note: - if you can add expire  backups to RMAN with below command

catalog backuppiece ' /u01/backup/sada/df_prodt801630095_s122_p1.bak’;

catalog backuppiece  ' /u01/backup/sada/df_prodt801643562_s123_p1.bak’;

catalog backuppiece  '/u01/backup/sada/df_archive801436201_s115_p1.arc';

run

 {

restore database;

recover database;

alter database open resetlogs;

}

Start the listener service

su oracle

Run the dB tire environment variable

lsnrctl start TEST

sh adautocfg.sh

Check temp data files status

SQL>select * from v$tempfile;

Note:- If  there isn’t  temp table space create temp table space and assign to default table space

Add Temp table space

SQL>create temporary tablespace  TEMP01  tempfile '/u01/finsys/db/apps_st/data/TEMP01.dbf' size 1000M;

SQL>alter tablespace TEMP01 add tempfile '/u01/finsys/db/apps_st/data/TEMP02.dbf' size 1000M;

SQL>alter database default temporary tablespace temp01;

Run the autoconfig for the database tire

Su oracle

Run the dB tire environment variable

cd /u01/finsys/db/tech_st/11.1.0/appsutil/scripts/TEST_oftest

sh adautocfg.sh

Note :- Provide the apps password for the continue the process

Complete the database configuration

su oracle

Run the dB tire environment variable

sqlplus apps/apps

SQL>

select node_name

from FND_NODES;

It will gives the old instance name if there is  so however clean the FND NODS using below command and commit it

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

SQL> commit;

Run the autoconfig for the database tire

Su oracle

Run the dB tire environment variable

cd /u01/finsys/db/tech_st/11.1.0/appsutil/scripts/TEST_oftest

sh adautocfg.sh

Configure the target Application Tier

cd $COMMON_TOP/clone/bin

cd  /u01/finsys/apps/apps_st/comn/clone/bin

perl adcfgclone.pl appsTier

Start the apps tier