Muhammad Asif: Restore Oracle DB & FMW Cloning (Part1)

Part1

Restore Oracle DB on Cloning Server

Env: Oracle DB 11g , FMW + Weblogic, Oracle Linux 6.5

=======================================================================

Oracle Database Backup using RMAN (Online) + Forms + Reports move to Cloning server.

$ export LD_BIND_NOW=1

[Oracle@Clone]$./runInstaller

Installed only database software

SQL> startup nomount pfile='/u02/oradb/product/11.2.0/dbhome_1/dbs/initPROD.ora';

ORACLE instance started.

Total System Global Area 1002127360 bytes

Fixed Size 2259440 bytes

Variable Size 348128784 bytes

Database Buffers 645922816 bytes

Redo Buffers 5816320 bytes

SQL>

[oracle@oraerptest Desktop]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Dec 7 14:16:26 2019

connected to target database: PROD (not mounted)

RMAN> set DBID 351966818

executing command: SET DBID

RMAN> restore controlfile from '/u02/RmanDBbk/PRODc-351966818-20191206-00';

Starting restore at 07-DEC-19

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u02/oradb/proddata/control01.ctl

output file name=/u02/oradb/proddata/control02.ctl

Finished restore at 07-DEC-19

RMAN> startup mount;

database is already started

database mounted

released channel: ORA_DISK_1

RMAN-03002 Failure of duplicate Db command

RMAN-19505 failed to identify file "/u01/rmanbk/....."

RMAN> show all;

RMAN configuration parameters for database with db_unique_name PROD are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 7;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/rmanbkp/%d%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/rmanbkp/%U';

CONFIGURE MAXSETSIZE TO UNLIMITED;

CONFIGURE ENCRYPTION FOR DATABASE OFF;

CONFIGURE ENCRYPTION ALGORITHM 'AES128';

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/RmanDBbk';

RMAN>

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradb/product/11.2.0/dbhome_a/dbs/snapcf_PROD.f';

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/RmanDBbk';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradb/product/11.2.0/dbhome_a/dbs/snapcf_PROD.f';

new RMAN configuration parameters are successfully stored

RMAN> crosscheck backup;

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c9vhbin5_1_1 RECID=6292 STAMP=1058392807

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c8vhbin5_1_1 RECID=6293 STAMP=1058392827

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cavhbin5_1_1 RECID=6294 STAMP=1058392808

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c7vhbin5_1_1 RECID=6295 STAMP=1058392827

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c6vhbin5_1_1 RECID=6296 STAMP=1058392805

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cevhe734_1_1 RECID=6298 STAMP=1058479212

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cfvhe734_1_1 RECID=6299 STAMP=1058479210

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cgvhe735_1_1 RECID=6300 STAMP=1058479212

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cdvhe734_1_1 RECID=6301 STAMP=1058479237

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/ccvhe734_1_1 RECID=6302 STAMP=1058479210

Crosschecked 10 objects