How to restore FCM Tape Backup?

PLAN OF ACTION for Restoration from FCM Server to UAT Server. 

We are restoring PROD production database from direct FCM Tape backup, as a first step we are restoring latest control file manually from UAT Server, after that we are running the restoration script on UAT Server. When we fired the restoration script, we got the following errors....

Later, we have tried restoring manually from the catalog in UAT Server.

We tried below steps as well when suggested by IBM team:

RMAN>catalog DEVICE TYPE 'SBT_TAPE' BACKUPPIECE '"pesguqus_1_1"';

After running this command, we are getting following error:

ORA_19511: Error received from media manager Layer, error text:

ANS1302E (RC2) No objects on server match query.

Basically Our FCM Backup will be happening as follows:

In Production Database, we will take control file backup manually with RMAN, post which we connect Production Database with active IP address i.e. xx.xx.xx.xx.

Once we connect xx.xx.xx.xx, we execute the following two commands to take Backup of Production database through FCM.

Follow the below commands:

bash-4.4$ cd $ORACLE_HOME/acs

bash-4.4$ fcmcli -f unmount 

IBM Tivoli Storage FlashCopy(R) Manager offload agent

- Version 4, Release 1, Level 3.0 for AIX LF 64-bit -

Build: 763 generated on Jul 31 2015

(c) Copyright IBM Corporation, 2000, 2015, All Rights Reserved.

FMM0005I Start of program at: Thu Jul 13 16:47:56 IST 2017.

FMM8800I The command is: unmount

FMM6501I Initializing 'unmount' request.

FMM6502I Executing 'unmount' request.

FMM6503I Terminating 'unmount' request.

FMM6518I No snapshot backup is currently mounted. ----------------->>(this line should be present)

FMM0020I End of program at: Thu Jul 13 16:47:58 IST 2017.

FMM0021I Elapsed time: 02 sec.

FMM0024I Return code is: 0.

bash-4.4$ pwd

/oracle/app/oradata/product/11.2.0/dbhome_1/acs

bash-4.4$ acsora -f backup ------------------------>>>(this is the command to start the backup)

Backup initiating process:

1. Initially it will take snapshot of the production database.
2. Then it will connect to FCM Server (XX.XX.XX.XX), in that we have catalog database (catdb).
3. Once it is connected to catalog database, in cat database we have one script (rman.sh) to take backup, the script consist TSM Tape path ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4. Then backup will happen in TAPE.

NOTE:

ISSUE

All the backup that happens through FCM Server (XX.XX.XX.XX), backup information will always be stored in catalog database’s control file only. Hence, while trying restoration direct from UAT server (xx.xx.xx.xx), it’s not happening because of missing backup information.

SOLUTION:

Therefore, we have planned the restoration to happen from XX.XX.XX.XX (PROD FCM server) with the help of CATALOG database and restore it to xx.xx.xx.xx (UAT Server) .

Following Steps: 

STEP 1:

1. In UAT Server (10.0.2.133), first we will configure LISTNER file:

$ cd $ORACLE_HOME/network/admin

$ vi listener.ora

UATPROD1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1531))

)

SID_LIST_UATPROD1 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PROD1)

(ORACLE_HOME = /oracle/app/oradata/product/11.2.0/dbhome_1)

(ENVS = 'EPC_DISABLED=TRUE')

)

1. Then start the listener: UATPROD1.

$ lsnrctl start UATPROD1

STEP 2:

1. Configure TNSNAMES entry in FCM Server (XX.XX.XX.XX).

$ cd $ORACLE_HOME/network/admin

$vi tnsnames.ora

UATPROD1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1531))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PROD1)

)

)

STEP 3: 

In UAT Server (xx.xx.xx.xx),

1. First we have to export Oracle instance:

$ export ORACLE_SID=PROD1

Then connect RMAN

$ rman target /

1. set DBID

RMAN> set DBID=1971255728;

RMAN> startup nomount pfile='/oracle/app/oradata/product/11.2.0/dbhome_1/initPROD1.ora';

RMAN> restore controlfile from

'/home/oracle/15OCT2017/bkctrl_dPROD1_ut2sh3osk_s36770_p1_t957473684';

Once we restore control file manually, then connect FCM Server (XX.XX.XX.XX)

STEP 4:

$ export ORACLE_SID=catdb

1. Then, we will connect catalog database and UAT database through RMAN.

$ rman catalog RCAT/rcat target sys/oracle123@UATPROD1

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Oct 17 14:19:44 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to target database: PROD1 (not mounted)

Connected to recovery catalog database

RMAN> alter database mount;

RMAN> crosscheck backup;

RMAN> delete noprompt expired backup;

RMAN>@RRB1_Final_Script.sql

run

{

allocate channel 'c1' type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

set newname for datafile 1 to '/PROD1_dbrestfiles/PROD1/datafile/system_01.dbf';

set newname for datafile 2 to '/PROD1_dbrestfiles/PROD1/datafile/sysaux_01.dbf';

set newname for datafile 3 to '/PROD1_dbrestfiles/PROD1/datafile/users01.dbf';

set newname for datafile 4 to '/PROD1_dbrestfiles/PROD1/datafile/tab_01.dbf';

set newname for datafile 5 to '/PROD1_dbrestfiles/PROD1/datafile/hr_tblsp_01.dbf';

set newname for tempfile 1 to '/PROD1_dbrestfiles/PROD1/tempfile/temp_sort_tblspc_01.dbf';

restore database;

switch datafile all;

switch tempfile all;

recover database;

release channel c1;

}

STEP 5:

Login in to UAT Server:

$ Sqlplus / as sysdba

SQL> select NAME,LOG_MODE,OPEN_MODE,CONTROLFILE_TYPE from v$database;

SQL> recover database until cancel using backup controlfile;

AUTO

SQL> alter database open resetlogs;

SQL> select NAME,LOG_MODE,OPEN_MODE,CONTROLFILE_TYPE from v$database;

Thanks and Comments Please..............!