In this article i will illustrate
all steps involved in cloning an Oracle E-Business suite environment using
online backup.
There are other ways also to do a clone of database with online backup. But in this article I am illustrating rman database cloning with nocatalog option.
- Database will be backed up using rman
- Application File system will be backed up when all services are up and running.
There are other ways also to do a clone of database with online backup. But in this article I am illustrating rman database cloning with nocatalog option.
- Database will be backed up using rman
- Application File system will be backed up when all services are up and running.
Source System – Exisiting system for which you want ot create a new copy
Target system – New system
on which clone is prepared
Source OS – OEL 5.9
x64 Source Architecture – Two Tier
Target OS – OEL 5.8 x64 Target Architecture - Single Tier
Application Ver. - R12.1.3
Database Ver. – 11.1.0.7Source DBNAME – PROD
Target DBNMAE – CLONE
High Level Steps :
1.
Run clone
preparation script (adpreclone.pl) on database and application Tier
2.
Perform full
database backup using rman
3.
Perform application
file system backup using tar/backup tool
4.
Copy RDBMS
ORACLE_HOME, rman backup pieces and Application FS on target node
5.
Create database
context file using clone configuration script (adcfgclone.pl)
6.
Restore and recover
database using rman
7.
Run autoconfig on
target database node
8.
Run clone
configuration script on application Tier on targte node.
9.
perform post clone
steps
Source System Application dash board:
Source System Details & DB Tier Clone Preparation
login as: root
root@10.0.0.68's
password:
Last login: Thu Aug 10
13:08:23 2017 from scr-eng-269.saudconsult.com
[root@RUH-ERPDB01 ~]# cat
/etc/issue
Oracle Linux Server
release 5.9
Kernel \r on an \m
[root@RUH-ERPDB01 ~]# lsb_release
-id
Distributor ID:
EnterpriseEnterpriseServer
Description: Enterprise Linux Enterprise Linux Server
release 5.9 (Carthage)
[root@RUH-ERPDB01 ~]#
[root@RUH-ERPDB01 ~]# arch
x86_64
[root@RUH-ERPDB01 ~]# hostname
RUH-ERPDB01.SAUDCONSULT.COM
[root@RUH-ERPDB01 ~]#
[root@RUH-ERPDB01 ~]# hostname -i
10.0.0.68
[root@RUH-ERPDB01 ~]#
[root@RUH-ERPDB01 ~]# su - oraprod
[oraprod@RUH-ERPDB01
PROD_ruh-erpdb01]$ pwd
/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_ruh-erpdb01
[oraprod@RUH-ERPDB01
PROD_ruh-erpdb01]$ ls
adautocfg.sh addbctl.sh
adexecsql.pl adpreclone.pl adstrtdb.sql
adchknls.pl addlnctl.sh
adlsnodes.sh adstopdb.sql show.log
[oraprod@RUH-ERPDB01
PROD_ruh-erpdb01]$
[oraprod@RUH-ERPDB01
PROD_ruh-erpdb01]$
[oraprod@RUH-ERPDB01
PROD_ruh-erpdb01]$ adpreclone.pl dbTier
Copyright (c) 2002 Oracle
Corporation
Redwood Shores,
California, USA
Oracle Applications
Rapid Clone
Version 12.0.0
adpreclone Version
120.20.12010000.2
Enter the APPS User
Password: apps password
Running:
perl
/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/bin/adclone.pl
java=/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/jre mode=stage stage=/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/clone
component=dbTier method=CUSTOM
dbctx=/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_ruh-erpdb01.xml
showProgress
APPS Password :
Beginning database
tier Stage - Thu Aug 10 13:12:45 2017
/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=false
-Doracle.installer.oui_loc=/u02/oracle/PROD/db/tech_st/11.1.0/oui
-classpath /u02/oracle/PROD/db/tech_st/11.1.0/lib/xmlparserv2.jar:/u02/oracle/PROD/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/java:/u02/oracle/PROD/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/u02/oracle/PROD/db/tech_st/11.1.0/oui/jlib/ewt3.jar:/u02/oracle/PROD/db/tech_st/11.1.0/oui/jlib/share.jar:/u02/oracle/PROD/db/tech_st/11.1.0/oui/jlib/srvm.jar:/u02/oracle/PROD/db/tech_st/11.1.0/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e
/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_ruh-erpdb01.xml -stage
/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/clone -tmp /tmp -method CUSTOM -showProgress
APPS Password :
Log file located at
/u02/oracle/PROD/db/tech_st/11.1.0/appsutil/log/PROD_ruh-erpdb01/StageDBTier_08101312.log
/
50% completed
Completed Stage...
Thu Aug 10 13:12:59
2017
[oraprod@RUH-ERPDB01
PROD_ruh-erpdb01]$
APPS Tier Clone Preparation
login as: root
root@10.0.0.67's
password:
Last login: Sun
Aug 6 09:28:24 2017 from
scr-eng-269.saudconsult.com
[root@RUH-ERPAP01 ~]# hostname
RUH-ERPAP01.SAUDCONSULT.COM
[root@RUH-ERPAP01 ~]# hostname -i
10.0.0.67
[root@RUH-ERPAP01 ~]# su -
applprod
[applprod@RUH-ERPAP01
scripts]$ pwd
/u02/oracle/PROD/inst/apps/PROD_RUH-ERPAP01/admin/scripts
[applprod@RUH-ERPAP01
scripts]$
[applprod@RUH-ERPAP01
scripts]$ ls
adalnctl.sh adforms-c4wsctl.sh adopmnctl.sh gsmstart.sh mwactl.sh
adapcctl.sh adformsctl.sh adpreclone.pl ieo mwactlwrpr.sh
adautocfg.sh adformsrvctl.sh adstpall.sh java.sh
sqlnet.log
adcmctl.sh adoacorectl.sh adstrtal.sh jtffmctl.sh
adexecsql.pl adoafmctl.sh CUSTOM.err msc
[applprod@RUH-ERPAP01 scripts]$
URL find for EBS using grep
[applprod@RUH-ERPAP01 scripts]$ grep login $CONTEXT_FILE
<login_page oa_var="s_login_page">http://RUH-ERPAP01.saudconsult.com:8005/OA_HTML/AppsLogin</login_page>
[applprod@RUH-ERPAP01 scripts]$
Port number Check for Oracle EBS
[applprod@RUH-ERPAP01 scripts]$
User wise Concurrent Count for User oratest
[oratest@RUH-ERPAT01 ~]$
[oratest@RUH-ERPAT01 ~]$ . fnd
[oratest@RUH-ERPAT01 ~]$
[oratest@RUH-ERPAT01 ~]$ ps -ef|grep -i oratest
[oratest@RUH-ERPAT01 ~]$ ps -ef|grep -i oratest|wc -l
133
[oratest@RUH-ERPAT01 ~]$ ps -ef|grep -i FNDLIBR|wc -l
65
[oratest@RUH-ERPAT01 ~]$ ps -fu oratest|grep -i fnd|wc -l
[oratest@RUH-ERPAT01 ~]$ ps -ef|grep -i oratest|wc -l
133
[oratest@RUH-ERPAT01 ~]$ ps -ef|grep -i FNDLIBR|wc -l
65
[oratest@RUH-ERPAT01 ~]$ ps -fu oratest|grep -i fnd|wc -l
97
[oratest@RUH-ERPAT01 ~]$
[oratest@RUH-ERPAT01 ~]$
Pkill all background process of OS User
[root@rac1 ~]# pkill -9 FNDLIBR ß to kill all multiple users Concurrent running on Server
[root@rac1 ~]# pkill -9 FND ß to kill Weblogic and Java Connections
[root@rac1 ~]# pkill -u applahc ß to kill All BP’s running with user
Watch Command for FND Process
[oratest@RUH-ERPAT01 ~]$
[oratest@RUH-ERPAT01 ~]$ watch -n 1 'ps -fu oratest|grep -i fnd|wc -l'
[applprod@RUH-ERPAP01 scripts]$ grep login $CONTEXT_FILE
<login_page oa_var="s_login_page">http://RUH-ERPAP01.saudconsult.com:8005/OA_HTML/AppsLogin</login_page>
[applprod@RUH-ERPAP01 scripts]$
Port number Check for Oracle EBS
[root@RUH-ERPAT01 ~]#
[root@RUH-ERPAT01 ~]# netstat -an |grep 8012
tcp 0 0 0.0.0.0:8012 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:22269 127.0.0.1:8012 TIME_WAIT
tcp 0 0 127.0.0.1:22248 127.0.0.1:8012 TIME_WAIT
tcp 0 0 127.0.0.1:22260 127.0.0.1:8012 TIME_WAIT
[root@RUH-ERPAT01 ~]#
Context File Check
Database Node Context File
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ . CLONE_rac1.env
[oracle@rac1 ~]$
[oracle@rac1 ~]$ env | grep .xml
CONTEXT_FILE=/u01/db_CLONE/12.1.0/appsutil/CLONE_rac1.xml
[oracle@rac1 ~]$
Check the Status of Application Services
[applprod@RUH-ERPAP01
scripts]$
[applprod@RUH-ERPAP01 scripts]$ adopmnctl.sh status
[applprod@RUH-ERPAP01 scripts]$ adopmnctl.sh status
You are running
adopmnctl.sh version 120.6.12010000.4
Checking status of
OPMN managed processes...
Processes in Instance:
PROD_RUH-ERPAP01.RUH-ERPAP01.saudconsult.com
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm |
49773 | Alive
OC4JGroup:default_group | OC4J:forms |
49698 | Alive
OC4JGroup:default_group | OC4J:oacore |
49535 | Alive
HTTP_Server | HTTP_Server |
49472 | Alive
adopmnctl.sh: exiting
with status 0
adopmnctl.sh: check
the logfile
/u02/oracle/PROD/inst/apps/PROD_RUH-ERPAP01/logs/appl/admin/log/adopmnctl.txt
for more information ...
[applprod@RUH-ERPAP01
scripts]$
[applprod@RUH-ERPAP01
scripts]$ adpreclone.pl appsTier
Copyright (c) 2002 Oracle
Corporation
Redwood Shores,
California, USA
Oracle Applications
Rapid Clone
Version 12.0.0
adpreclone Version 120.20.12010000.5
Running:
perl
/u02/oracle/PROD/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl
java=/u02/oracle/PROD/apps/tech_st/10.1.3/appsutil/jdk mode=stage
stage=/u02/oracle/PROD/apps/apps_st/comn/clone component=appsTier method=
appctx=/u02/oracle/PROD/inst/apps/PROD_RUH-ERPAP01/appl/admin/PROD_RUH-ERPAP01.xml
showProgress
APPS Password :
method defaulted to
CUSTOM
Beginning application
tier Stage - Thu Aug 10 12:43:11 2017
/u02/oracle/PROD/apps/tech_st/10.1.3/appsutil/jdk/bin/java
-Xmx600M -DCONTEXT_VALIDATED=false
-Doracle.installer.oui_loc=/oui -classpath
/u02/oracle/PROD/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/u02/oracle/PROD/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:/u02/oracle/PROD/apps/apps_st/comn/java/classes:/u02/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:/u02/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/u02/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/share.jar:/u02/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/u02/oracle/PROD/apps/tech_st/10.1.3/jlib/ojmisc.jar oracle.apps.ad.clone.StageAppsTier -e
/u02/oracle/PROD/inst/apps/PROD_RUH-ERPAP01/appl/admin/PROD_RUH-ERPAP01.xml
-stage /u02/oracle/PROD/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM -showProgress
Log file located at
/u02/oracle/PROD/inst/apps/PROD_RUH-ERPAP01/admin/log/StageAppsTier_08101243.log
\
80% completed
Completed Stage...
Thu Aug 10 12:43:53
2017
[applprod@RUH-ERPAP01
scripts]$
Now let’s perform RMAN backup for Database Tier
The following script is used for compressed RMAN backup
+++-----the following in Orange color is RMAN backup Script-----+++
sql 'alter system archive log current';
sql "alter session set
nls_date_format=''dd.mm.yyyy hh24:mi:ss''";
RUN
{
CONFIGURE CONTROLFILE AUTOBACKUP ON;
configure retention policy to recovery window
of 30 days;
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO
COMPRESSED BACKUPSET PARALLELISM 4;
set command id to 'SCGOnlineBackupFull';
backup AS COMPRESSED BACKUPSET full database
tag SC_FULL format '/u02/BACKUP/RMAN/%d_%T_%s_%p_FULL' ;
sql 'alter system archive log current';
backup tag SC_ARCHIVE format
'/u02/BACKUP/RMAN/%d_%T_%s_%p_ARCHIVE' archivelog all not backed up ;
backup tag SC_CONTROL current controlfile
format '/u02/BACKUP/RMAN/%d_%T_%s_%p_CONTROL';
crosscheck archivelog all;
delete noprompt archivelog until time
'SYSDATE-8';
delete noprompt obsolete device type disk;
}
+++----------------- END OF SCRIPT ----------------------+++
login as: root
root@10.0.0.68's
password:
Last login: Thu Aug 10
13:05:25 2017 from scr-eng-269.saudconsult.com
[root@RUH-ERPDB01 ~]# su - oraprod
[oraprod@RUH-ERPDB01
~]$ .
PROD_ruh-erpdb01.env
[oraprod@RUH-ERPDB01
~]$ echo
$ORACLE_SID
PROD
[oraprod@RUH-ERPDB01
~]$ sqlplus
/ as sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Thu Aug 10 13:09:23 2017
Copyright (c) 1982,
2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL> select
NAME,OPEN_MODE from v$database;
NAME OPEN_MODE
--------- ----------
PROD READ WRITE
SQL>
To check component list and last applied bundel patch
SQL> select comp_id,comp_name,version,status from dba_registry;
SQL>
SQL> select description from dba_registry_sqlpatch;
To check free space of Tablespace by percentage wise
=============================================================
select a.tablespace_name,
A.Allocated,
B.Freespace,round(b.freespace/a.allocated*100) "% Free"
from
(select tablespace_name ,sum(bytes)/1024/1024 Allocated from dba_data_files group by tablespace_name) A ,
(select tablespace_name,sum(bytes)/1024/1024 Freespace
from dba_free_space group by tablespace_name) B
where a.tablespace_name=b.tablespace_name(+)
ORDER BY "% Free";
ORDER BY "% Free";
SQL>
SQL> exit
SQL> exit
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
[oraprod@RUH-ERPDB01
~]$ rman
target /
Recovery Manager:
Release 11.1.0.7.0 - Production on Thu Aug 10 13:16:24 2017
Copyright (c) 1982,
2007, Oracle. All rights reserved.
connected to target
database: PROD (DBID=298384717)
RMAN> show all;
using target database
control file instead of recovery catalog
RMAN configuration
parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION
POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP
OPTIMIZATION OFF;
CONFIGURE DEFAULT
DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE
AUTOBACKUP ON;
CONFIGURE CONTROLFILE
AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/BACKUP/RMAN/%F';
CONFIGURE DEVICE TYPE
DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
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
'/u02/BACKUP/RMAN/backup_%U';
CONFIGURE MAXSETSIZE
TO UNLIMITED;
CONFIGURE ENCRYPTION
FOR DATABASE OFF;
CONFIGURE ENCRYPTION
ALGORITHM 'AES128';
CONFIGURE COMPRESSION
ALGORITHM 'BZIP2';
CONFIGURE ARCHIVELOG
DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT
CONTROLFILE NAME TO '/u02/BACKUP/RMAN/snapcf_PROD.f';
RMAN>
================================================================================================================
OTHER COMMANDS OF RMAN
_______________________________
To Check RMAN Configuration for Target Database:
RMAN> RMAN> show all;
_______________________________
To check previous backups performed by RMAN
RMAN> crosscheck backup;
RMAN> list backup;
RMAN> delete backup;
_______________________________
To Delete expired Backup
& Archive log
RMAN> crosscheck backup;
RMAN> list expired backup;
RMAN> list expired backup;
RMAN> delete expired backup;
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> LIST EXPIRED ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
_______________________________
To Crosscheck/Delete RMAN Archivelog/Backup older than 1 week
RMAN> crosscheck archivelog until time 'sysdate -8';
RMAN> delete archivelog until time 'SYSDATE-8';
RMAN> crosscheck backup completed before 'sysdate -8';
RMAN> delete backup completed before 'sysdate -8';
_______________________________
To create duplicate Database for Clone:
RMAN> duplicate database to TESTUAT from active database nofilenamecheck;
RMAN>
================================================================================================================
RMAN>
sql 'alter system archive log current';
sql
"alter session set nls_date_format=''dd.mm.yyyy hh24:mi:ss''";
RUN
{
CONFIGURE
CONTROLFILE AUTOBACKUP ON;
configure
retention policy to recovery window of 30 days;
CONFIGURE
DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
set
command id to 'SCGOnlineBackupFull';
backup
AS COMPRESSED BACKUPSET full database tag SC_FULL format
'/u02/BACKUP/RMAN/%d_%T_%s_%p_FULL' ;
sql
'alter system archive log current';
backup
tag SC_ARCHIVE format '/u02/BACKUP/RMAN/%d_%T_%s_%p_ARCHIVE' archivelog all not
backed up ;
backup
tag SC_CONTROL current controlfile format
'/u02/BACKUP/RMAN/%d_%T_%s_%p_CONTROL';
crosscheck
archivelog all;
delete
noprompt archivelog until time 'SYSDATE-8';
delete
noprompt obsolete device type disk;
}sql
statement: alter system archive log current
RMAN>
sql
statement: alter session set nls_date_format=''dd.mm.yyyy hh24:mi:ss''
RMAN>
2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
14>
old RMAN configuration
parameters:
CONFIGURE CONTROLFILE
AUTOBACKUP ON;
new RMAN configuration
parameters:
CONFIGURE CONTROLFILE
AUTOBACKUP ON;
new RMAN configuration
parameters are successfully stored
old RMAN configuration
parameters:
CONFIGURE RETENTION
POLICY TO RECOVERY WINDOW OF 30 DAYS;
new RMAN configuration
parameters:
CONFIGURE RETENTION
POLICY TO RECOVERY WINDOW OF 30 DAYS;
new RMAN configuration
parameters are successfully stored
old RMAN configuration
parameters:
CONFIGURE DEVICE TYPE
DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
new RMAN configuration
parameters:
CONFIGURE DEVICE TYPE
DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
new RMAN configuration
parameters are successfully stored
executing command: SET
COMMAND ID
Starting backup at
10-AUG-17
allocated channel:
ORA_DISK_1
channel ORA_DISK_1:
SID=2270 device type=DISK
allocated channel:
ORA_DISK_2
channel ORA_DISK_2:
SID=2293 device type=DISK
allocated channel:
ORA_DISK_3
channel ORA_DISK_3:
SID=2346 device type=DISK
allocated channel:
ORA_DISK_4
channel ORA_DISK_4:
SID=2281 device type=DISK
channel ORA_DISK_1:
starting compressed full datafile backup set
channel ORA_DISK_1:
specifying datafile(s) in backup set
input datafile file
number=00014 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data04.dbf
input datafile file
number=00031 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data010.dbf
input datafile file
number=00402 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data03.dbf
input datafile file
number=00025 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind08.dbf
input datafile file
number=00034 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data011.dbf
input datafile file
number=00406 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind05.dbf
input datafile file
number=00394 name=/u02/oracle/PROD/db/apps_st/data/a_ref01.dbf
input datafile file
number=00396 name=/u02/oracle/PROD/db/apps_st/data/a_summ01.dbf
input datafile file
number=00004 name=/u02/oracle/PROD/db/apps_st/data/system04.dbf
input datafile file
number=00295 name=/u02/oracle/PROD/db/apps_st/data/system06.dbf
input datafile file
number=00351 name=/u02/oracle/PROD/db/apps_st/data/system07.dbf
input datafile file
number=00033 name=/u02/oracle/PROD/db/apps_st/data/ctxd02.dbf
input datafile file
number=00314 name=/u02/oracle/PROD/db/apps_st/data/portal01.dbf
input datafile file
number=00007 name=/u02/oracle/PROD/db/apps_st/data/owad01.dbf
input datafile file
number=00011 name=/u02/oracle/PROD/db/apps_st/data/sysaux01.dbf
channel ORA_DISK_1:
starting piece 1 at 10-AUG-17
channel ORA_DISK_2:
starting compressed full datafile backup set
channel ORA_DISK_2:
specifying datafile(s) in backup set
input datafile file
number=00024 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data06.dbf
input datafile file
number=00029 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data09.dbf
input datafile file
number=00392 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data01.dbf
input datafile file
number=00405 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind04.dbf
input datafile file
number=00404 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind03.dbf
input datafile file
number=00013 name=/u02/oracle/PROD/db/apps_st/data/system12.dbf
input datafile file
number=00352 name=/u02/oracle/PROD/db/apps_st/data/system09.dbf
input datafile file
number=00407 name=/u02/oracle/PROD/db/apps_st/data/a_ref02.dbf
input datafile file
number=00001 name=/u02/oracle/PROD/db/apps_st/data/system01.dbf
input datafile file
number=00005 name=/u02/oracle/PROD/db/apps_st/data/system05.dbf
input datafile file
number=00288 name=/u02/oracle/PROD/db/apps_st/data/system10.dbf
input datafile file
number=00016 name=/u02/oracle/PROD/db/apps_st/data/a_ref03.dbf
input datafile file
number=00017 name=/u02/oracle/PROD/db/apps_st/data/a_int02.dbf
channel ORA_DISK_2:
starting piece 1 at 10-AUG-17
channel ORA_DISK_3:
starting compressed full datafile backup set
channel ORA_DISK_3:
specifying datafile(s) in backup set
input datafile file
number=00026 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data07.dbf
input datafile file
number=00030 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind10.dbf
input datafile file
number=00401 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data02.dbf
input datafile file
number=00022 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind07.dbf
input datafile file
number=00027 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind09.dbf
input datafile file
number=00020 name=/u02/oracle/PROD/db/apps_st/data/XXHRCUSTOM01.dbf
input datafile file
number=00353 name=/u02/oracle/PROD/db/apps_st/data/system08.dbf
input datafile file
number=00400 name=/u02/oracle/PROD/db/apps_st/data/a_media01.dbf
input datafile file
number=00395 name=/u02/oracle/PROD/db/apps_st/data/a_int01.dbf
input datafile file
number=00002 name=/u02/oracle/PROD/db/apps_st/data/system02.dbf
input datafile file
number=00021 name=/u02/oracle/PROD/db/apps_st/data/a_ref04.dbf
input datafile file
number=00008 name=/u02/oracle/PROD/db/apps_st/data/a_queue02.dbf
input datafile file
number=00012 name=/u02/oracle/PROD/db/apps_st/data/apps_ts_tools01.dbf
input datafile file
number=00018 name=/u02/oracle/PROD/db/apps_st/data/sysaux02.dbf
input datafile file
number=00010 name=/u02/oracle/PROD/db/apps_st/data/olap.dbf
channel ORA_DISK_3:
starting piece 1 at 10-AUG-17
channel ORA_DISK_4:
starting compressed full datafile backup set
channel ORA_DISK_4:
specifying datafile(s) in backup set
input datafile file
number=00019 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data05.dbf
input datafile file
number=00028 name=/u02/oracle/PROD/db/apps_st/data/a_txn_data08.dbf
input datafile file
number=00032 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind11.dbf
input datafile file
number=00403 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind02.dbf
input datafile file
number=00393 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind01.dbf
input datafile file
number=00379 name=/u02/oracle/PROD/db/apps_st/data/undo01.dbf
input datafile file
number=00015 name=/u02/oracle/PROD/db/apps_st/data/a_txn_ind06.dbf
input datafile file
number=00023 name=/u02/oracle/PROD/db/apps_st/data/sysaux03.dbf
input datafile file
number=00003 name=/u02/oracle/PROD/db/apps_st/data/system03.dbf
input datafile file
number=00398 name=/u02/oracle/PROD/db/apps_st/data/a_archive01.dbf
input datafile file
number=00354 name=/u02/oracle/PROD/db/apps_st/data/system11.dbf
input datafile file
number=00399 name=/u02/oracle/PROD/db/apps_st/data/a_queue01.dbf
input datafile file
number=00397 name=/u02/oracle/PROD/db/apps_st/data/a_nolog01.dbf
input datafile file
number=00006 name=/u02/oracle/PROD/db/apps_st/data/ctxd01.dbf
input datafile file
number=00009 name=/u02/oracle/PROD/db/apps_st/data/odm.dbf
channel ORA_DISK_4:
starting piece 1 at 10-AUG-17
channel ORA_DISK_3:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_345_1_FULL tag=SC_FULL comment=NONE
channel ORA_DISK_3:
backup set complete, elapsed time: 00:10:45
channel ORA_DISK_4:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_346_1_FULL tag=SC_FULL comment=NONE
channel ORA_DISK_4:
backup set complete, elapsed time: 00:11:05
channel ORA_DISK_1:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_343_1_FULL tag=SC_FULL comment=NONE
channel ORA_DISK_1:
backup set complete, elapsed time: 00:11:15
channel ORA_DISK_2:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_344_1_FULL tag=SC_FULL comment=NONE
channel ORA_DISK_2:
backup set complete, elapsed time: 00:11:45
Finished backup at
10-AUG-17
Starting Control File
Autobackup at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/c-298384717-20170810-00 comment=NONE
Finished Control File
Autobackup at 10-AUG-17
sql statement: alter
system archive log current
Starting backup at
10-AUG-17
current log archived
using channel
ORA_DISK_1
using channel
ORA_DISK_2
using channel
ORA_DISK_3
using channel
ORA_DISK_4
channel ORA_DISK_1:
starting compressed archived log backup set
channel ORA_DISK_1:
specifying archived log(s) in backup set
input archived log
thread=1 sequence=709 RECID=427 STAMP=950112501
input archived log
thread=1 sequence=710 RECID=428 STAMP=950185567
input archived log
thread=1 sequence=711 RECID=429 STAMP=950264440
input archived log
thread=1 sequence=712 RECID=430 STAMP=950367462
input archived log
thread=1 sequence=713 RECID=431 STAMP=950573164
input archived log
thread=1 sequence=714 RECID=432 STAMP=950743903
input archived log
thread=1 sequence=715 RECID=433 STAMP=950947693
input archived log
thread=1 sequence=716 RECID=434 STAMP=951009904
channel ORA_DISK_1:
starting piece 1 at 10-AUG-17
channel ORA_DISK_2:
starting compressed archived log backup set
channel ORA_DISK_2:
specifying archived log(s) in backup set
input archived log
thread=1 sequence=693 RECID=411 STAMP=947948947
input archived log
thread=1 sequence=694 RECID=412 STAMP=948212004
input archived log
thread=1 sequence=695 RECID=413 STAMP=948456044
input archived log
thread=1 sequence=696 RECID=414 STAMP=948640868
input archived log
thread=1 sequence=697 RECID=415 STAMP=948870325
input archived log
thread=1 sequence=698 RECID=416 STAMP=948887096
input archived log
thread=1 sequence=699 RECID=417 STAMP=949023894
input archived log
thread=1 sequence=700 RECID=418 STAMP=949180767
channel ORA_DISK_2:
starting piece 1 at 10-AUG-17
channel ORA_DISK_3:
starting compressed archived log backup set
channel ORA_DISK_3:
specifying archived log(s) in backup set
input archived log
thread=1 sequence=701 RECID=419 STAMP=949227461
input archived log
thread=1 sequence=702 RECID=420 STAMP=949336912
input archived log
thread=1 sequence=703 RECID=421 STAMP=949525750
input archived log
thread=1 sequence=704 RECID=422 STAMP=949657065
input archived log
thread=1 sequence=705 RECID=423 STAMP=949714170
input archived log
thread=1 sequence=706 RECID=424 STAMP=949850689
input archived log
thread=1 sequence=707 RECID=425 STAMP=950016538
input archived log
thread=1 sequence=708 RECID=426 STAMP=950108807
channel ORA_DISK_3:
starting piece 1 at 10-AUG-17
channel ORA_DISK_4:
starting compressed archived log backup set
channel ORA_DISK_4:
specifying archived log(s) in backup set
input archived log
thread=1 sequence=717 RECID=435 STAMP=951028391
input archived log
thread=1 sequence=718 RECID=436 STAMP=951225992
input archived log
thread=1 sequence=719 RECID=437 STAMP=951391163
input archived log
thread=1 sequence=720 RECID=438 STAMP=951490739
input archived log
thread=1 sequence=721 RECID=439 STAMP=951657422
input archived log
thread=1 sequence=722 RECID=440 STAMP=951658136
input archived log
thread=1 sequence=723 RECID=441 STAMP=951658141
channel ORA_DISK_4:
starting piece 1 at 10-AUG-17
channel ORA_DISK_4:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_351_1_ARCHIVE tag=SC_ARCHIVE comment=NONE
channel ORA_DISK_4:
backup set complete, elapsed time: 00:03:35
channel ORA_DISK_1:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_348_1_ARCHIVE tag=SC_ARCHIVE comment=NONE
channel ORA_DISK_1:
backup set complete, elapsed time: 00:05:45
channel ORA_DISK_2:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_349_1_ARCHIVE tag=SC_ARCHIVE comment=NONE
channel ORA_DISK_2:
backup set complete, elapsed time: 00:05:45
channel ORA_DISK_3:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_350_1_ARCHIVE tag=SC_ARCHIVE comment=NONE
channel ORA_DISK_3:
backup set complete, elapsed time: 00:05:55
Finished backup at
10-AUG-17
Starting backup at
10-AUG-17
using channel
ORA_DISK_1
using channel
ORA_DISK_2
using channel
ORA_DISK_3
using channel
ORA_DISK_4
channel ORA_DISK_1:
starting compressed full datafile backup set
channel ORA_DISK_1:
specifying datafile(s) in backup set
including current
control file in backup set
channel ORA_DISK_1:
starting piece 1 at 10-AUG-17
channel ORA_DISK_1:
finished piece 1 at 10-AUG-17
piece
handle=/u02/BACKUP/RMAN/PROD_20170810_352_1_CONTROL tag=SC_CONTROL comment=NONE
channel ORA_DISK_1:
backup set complete, elapsed time: 00:00:01
Finished backup at
10-AUG-17
Starting Control File
Autobackup at 10-AUG-17
piece handle=/u02/BACKUP/RMAN/c-298384717-20170810-01
comment=NONE
Finished Control File
Autobackup at 10-AUG-17
released channel:
ORA_DISK_1
released channel:
ORA_DISK_2
released channel:
ORA_DISK_3
released channel:
ORA_DISK_4
allocated channel:
ORA_DISK_1
channel ORA_DISK_1:
SID=2270 device type=DISK
allocated channel:
ORA_DISK_2
channel ORA_DISK_2:
SID=2293 device type=DISK
allocated channel:
ORA_DISK_3
channel ORA_DISK_3:
SID=2346 device type=DISK
allocated channel:
ORA_DISK_4
channel ORA_DISK_4:
SID=2281 device type=DISK
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_693_886546382.dbf RECID=411
STAMP=947948947
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_694_886546382.dbf RECID=412
STAMP=948212004
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_695_886546382.dbf RECID=413
STAMP=948456044
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_696_886546382.dbf RECID=414
STAMP=948640868
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_697_886546382.dbf RECID=415
STAMP=948870325
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_698_886546382.dbf RECID=416
STAMP=948887096
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_699_886546382.dbf RECID=417
STAMP=949023894
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_700_886546382.dbf RECID=418
STAMP=949180767
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_701_886546382.dbf RECID=419 STAMP=949227461
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_702_886546382.dbf RECID=420
STAMP=949336912
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_703_886546382.dbf RECID=421
STAMP=949525750
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_704_886546382.dbf RECID=422
STAMP=949657065
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_705_886546382.dbf RECID=423
STAMP=949714170
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_706_886546382.dbf RECID=424
STAMP=949850689
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_707_886546382.dbf RECID=425
STAMP=950016538
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_708_886546382.dbf RECID=426
STAMP=950108807
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_709_886546382.dbf RECID=427
STAMP=950112501
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_710_886546382.dbf RECID=428
STAMP=950185567
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_711_886546382.dbf RECID=429
STAMP=950264440
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_712_886546382.dbf RECID=430
STAMP=950367462
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_713_886546382.dbf RECID=431
STAMP=950573164
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_714_886546382.dbf RECID=432
STAMP=950743903
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_715_886546382.dbf RECID=433
STAMP=950947693
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_716_886546382.dbf RECID=434
STAMP=951009904
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_717_886546382.dbf RECID=435
STAMP=951028391
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_718_886546382.dbf RECID=436
STAMP=951225992
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_719_886546382.dbf RECID=437
STAMP=951391163
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_720_886546382.dbf RECID=438
STAMP=951490739
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_721_886546382.dbf RECID=439
STAMP=951657422
validation succeeded
for archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_722_886546382.dbf RECID=440
STAMP=951658136
validation succeeded
for archived log
archived log file name=/u02/oracle/PROD/db/apps_st/archive/1_723_886546382.dbf
RECID=441 STAMP=951658141
Crosschecked 31
objects
released channel:
ORA_DISK_1
released channel:
ORA_DISK_2
released channel:
ORA_DISK_3
released channel:
ORA_DISK_4
allocated channel:
ORA_DISK_1
channel ORA_DISK_1:
SID=2270 device type=DISK
allocated channel:
ORA_DISK_2
channel ORA_DISK_2:
SID=2293 device type=DISK
allocated channel:
ORA_DISK_3
channel ORA_DISK_3:
SID=2346 device type=DISK
allocated channel:
ORA_DISK_4
channel ORA_DISK_4:
SID=2281 device type=DISK
List of Archived Log
Copies for database with db_unique_name PROD
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- -
---------
411 1
693 A 27-JUN-17
Name: /u02/oracle/PROD/db/apps_st/archive/1_693_886546382.dbf
412 1
694 A 29-JUN-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_694_886546382.dbf
413 1
695 A 01-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_695_886546382.dbf
414 1
696 A 04-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_696_886546382.dbf
415 1
697 A 06-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_697_886546382.dbf
416 1
698 A 09-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_698_886546382.dbf
417 1
699 A 09-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_699_886546382.dbf
418 1
700 A 11-JUL-17
Name: /u02/oracle/PROD/db/apps_st/archive/1_700_886546382.dbf
419 1
701 A 12-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_701_886546382.dbf
420 1
702 A 13-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_702_886546382.dbf
421 1
703 A 14-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_703_886546382.dbf
422 1
704 A 16-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_704_886546382.dbf
423 1
705 A 18-JUL-17
Name: /u02/oracle/PROD/db/apps_st/archive/1_705_886546382.dbf
424 1
706 A 19-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_706_886546382.dbf
425 1
707 A 20-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_707_886546382.dbf
426 1 708
A 22-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_708_886546382.dbf
427 1
709 A 23-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_709_886546382.dbf
428 1
710 A 23-JUL-17
Name: /u02/oracle/PROD/db/apps_st/archive/1_710_886546382.dbf
429 1
711 A 24-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_711_886546382.dbf
430 1
712 A 25-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_712_886546382.dbf
431 1
713 A 26-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_713_886546382.dbf
432 1
714 A 29-JUL-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_714_886546382.dbf
433 1
715 A 30-JUL-17
Name: /u02/oracle/PROD/db/apps_st/archive/1_715_886546382.dbf
434 1
716 A 02-AUG-17
Name:
/u02/oracle/PROD/db/apps_st/archive/1_716_886546382.dbf
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_693_886546382.dbf RECID=411
STAMP=947948947
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_694_886546382.dbf RECID=412
STAMP=948212004
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_695_886546382.dbf RECID=413
STAMP=948456044
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_696_886546382.dbf RECID=414
STAMP=948640868
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_697_886546382.dbf RECID=415
STAMP=948870325
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_698_886546382.dbf RECID=416
STAMP=948887096
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_699_886546382.dbf RECID=417 STAMP=949023894
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_700_886546382.dbf RECID=418
STAMP=949180767
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_701_886546382.dbf RECID=419 STAMP=949227461
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_702_886546382.dbf RECID=420
STAMP=949336912
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_703_886546382.dbf RECID=421 STAMP=949525750
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_704_886546382.dbf RECID=422
STAMP=949657065
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_705_886546382.dbf RECID=423
STAMP=949714170
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_706_886546382.dbf RECID=424
STAMP=949850689
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_707_886546382.dbf RECID=425
STAMP=950016538
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_708_886546382.dbf RECID=426
STAMP=950108807
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_709_886546382.dbf RECID=427
STAMP=950112501
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_710_886546382.dbf RECID=428
STAMP=950185567
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_711_886546382.dbf RECID=429
STAMP=950264440
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_712_886546382.dbf RECID=430
STAMP=950367462
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_713_886546382.dbf RECID=431
STAMP=950573164
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_714_886546382.dbf RECID=432
STAMP=950743903
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_715_886546382.dbf RECID=433
STAMP=950947693
deleted archived log
archived log file
name=/u02/oracle/PROD/db/apps_st/archive/1_716_886546382.dbf RECID=434
STAMP=951009904
Deleted 24 objects
RMAN retention policy
will be applied to the command
RMAN retention policy
is set to recovery window of 30 days
released channel:
ORA_DISK_1
released channel:
ORA_DISK_2
released channel:
ORA_DISK_3
released channel:
ORA_DISK_4
allocated channel:
ORA_DISK_1
channel ORA_DISK_1:
SID=2270 device type=DISK
allocated channel:
ORA_DISK_2
channel ORA_DISK_2:
SID=2293 device type=DISK
allocated channel:
ORA_DISK_3
channel ORA_DISK_3:
SID=2346 device type=DISK
allocated channel:
ORA_DISK_4
channel ORA_DISK_4:
SID=2281 device type=DISK
no obsolete backups
found
RMAN>
Check latest control file in backup pieces and notedown the name
RMAN>
RMAN> list backup of controlfile;
RMAN> list backup of controlfile;
using target database
control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- --
---------- ----------- ------------ ---------------
319 Full
33.39M DISK 00:00:01 17-JUL-17
BP Key: 319 Status: AVAILABLE Compressed: NO Tag: TAG20170717T134620
Piece Name:
/u02/BACKUP/RMAN/c-298384717-20170717-00
Control File Included: Ckp SCN:
5966496684299 Ckp time: 17-JUL-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- --
---------- ----------- ------------ ---------------
324 Full
33.39M DISK 00:00:01 10-AUG-17
BP Key: 324 Status: AVAILABLE Compressed: NO Tag: TAG20170810T132853
Piece Name:
/u02/BACKUP/RMAN/c-298384717-20170810-00
Control File Included: Ckp SCN:
5966517801570 Ckp time: 10-AUG-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ----------
----------- ------------ ---------------
329 Full
1.20M DISK 00:00:01 10-AUG-17
BP Key: 329 Status: AVAILABLE Compressed: YES Tag: SC_CONTROL
Piece Name:
/u02/BACKUP/RMAN/PROD_20170810_352_1_CONTROL
Control File Included: Ckp SCN:
5966517802418 Ckp time: 10-AUG-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- --
---------- ----------- ------------ ---------------
330 Full
33.39M DISK 00:00:00 10-AUG-17
BP Key: 330 Status: AVAILABLE Compressed: NO Tag: TAG20170810T133459
Piece Name: /u02/BACKUP/RMAN/c-298384717-20170810-01
Control File Included: Ckp SCN:
5966517802424 Ckp time: 10-AUG-17
RMAN>
RMAN> exit
Recovery Manager
complete.
[oraprod@RUH-ERPDB01
~]$
Now let’s take backup of ORACLE_HOME from database Tier
[root@RUH-ERPDB01 ~]#
[root@RUH-ERPDB01 ~]# tar -C /u02/oracle/PROD/db -cvzf /u01nfshare/backup_prod/10082017/db_tech_st.tar tech_st (to tar in different loc. & Exclude path /u02/oracle/PROD/db while uncompress)
[root@RUH-ERPDB01 ~]# tar -C /u02/oracle/PROD/db -cvzf /u01nfshare/backup_prod/10082017/db_tech_st.tar tech_st (to tar in different loc. & Exclude path /u02/oracle/PROD/db while uncompress)
[root@RUH-ERPDB01 ~]# cd /u02/oracle/PROD/db/
[root@RUH-ERPDB01 db]#
ls
apps_st tech_st
[root@RUH-ERPDB01 db]#
tar -cvzf /u01nfshare/backup_prod/10082017/db_tech_st.tar
tech_st
Now let’s Backup Application Tier while services are up and Running
[applprod@RUH-ERPAP01
scripts]$
[applprod@RUH-ERPAP01 scripts]$ adopmnctl.sh status
[applprod@RUH-ERPAP01 scripts]$ adopmnctl.sh status
You are running
adopmnctl.sh version 120.6.12010000.4
Checking status of
OPMN managed processes...
Processes in Instance:
PROD_RUH-ERPAP01.RUH-ERPAP01.saudconsult.com
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm |
49773 | Alive
OC4JGroup:default_group | OC4J:forms |
49698 | Alive
OC4JGroup:default_group | OC4J:oacore |
49535 | Alive
HTTP_Server | HTTP_Server |
49472 | Alive
adopmnctl.sh: exiting
with status 0
adopmnctl.sh: check
the logfile
/u02/oracle/PROD/inst/apps/PROD_RUH-ERPAP01/logs/appl/admin/log/adopmnctl.txt
for more information ...
[applprod@RUH-ERPAP01
scripts]$exit
logout
[root@RUH-ERPAP01 ~]# tar -C /u02/oracle/PROD -cvzf /u01nfshare/backup_prod/10082017/apps.tar.gz apps (to tar in different loc. & Exclude path while uncompress)
[root@RUH-ERPAP01 ~]# cd
/u02/oracle/PROD
[root@RUH-ERPAP01
PROD]# ls
apps inst
[root@RUH-ERPAP01
PROD]# tar -cvzf /u01nfshare/backup_prod/10082017/apps.tar.gz apps/
[root@RUH-ERPAP01
PROD]#
Copy the RMAN pieces, db_tech_home, apps backups to Target location(CLONE-SERVER)using
(SCP or Hard disk )
[root@RUH-ERPAP01
10082017]#
[root@RUH-ERPAP01 10082017]# ls
[root@RUH-ERPAP01 10082017]# ls
apps.tar.gz db_tech_st.tar RMAN_bkp.tar.gz
[root@RUH-ERPAP01
10082017]#
[root@RUH-ERPAP01
10082017]# scp * root@192.168.1.11:/u01/CLONE
root@192.168.1.11's
password:
apps.tar.gz 100% 189900 86MB/s
23:41
db_tech_st.tar.gz 100% 12340 51MB/s
10:32
RMAN_bkp.tar.gz 100% 469900 62MB/s
37:11
[root@RUH-ERPAP01
10082017]#
Crontab Service for schedule backup: (restart for any troubleshoot)
[root@rac1 ~]# service crond status
Redirecting to /bin/systemctl status crond.service
● crond.service - Command Scheduler
Loaded: loaded (/usr/lib/systemd/system/crond.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-05-31 14:37:05 +03; 24min ago
Main PID: 1696 (crond)
Tasks: 1
Memory: 2.7M
CGroup: /system.slice/crond.service
└─1696 /usr/sbin/crond -n
May 31 14:37:05 prodapp1 systemd[1]: Started Command Scheduler.
May 31 14:37:05 prodapp1 crond[1696]: (CRON) INFO (RANDOM_DELAY will be scaled with factor 42% if used.)
May 31 14:37:05 prodapp1 crond[1696]: (CRON) INFO (running with inotify support)
May 31 14:37:05 prodapp1 crond[1696]: (CRON) INFO (@reboot jobs will be run at computer's startup.)
May 31 14:39:01 prodapp1 crond[1696]: (root) RELOAD (/var/spool/cron/root)
May 31 14:41:01 prodapp1 crond[1696]: (root) RELOAD (/var/spool/cron/root)
May 31 14:45:01 prodapp1 crond[1696]: (root) RELOAD (/var/spool/cron/root)
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# crontab -l ( List all cron jobs of current users)
1 0 * * * /home/applmgr/bkupscripts/apptarbkp > /home/applmgr/bkupscripts/Logs/apptarbkp.log 2>&1
#*/2 * * * * /bin/date >> /tmp/cron_output
[root@rac1 ~]#
[root@rac1 ~]# crontab -e ( edit cron jobs of current users)
[root@rac1 ~]#
[root@rac1 ~]# cat /home/applmgr/bkupscripts/apptarbkp
tar -C /u01/OCI -cvzf /u02/DailyBKP/"$(date '+%Y-%m-%d')-fs1.tar.gz" fs1
tar -C /u01/OCI -cvzf /u02/DailyBKP/"$(date '+%Y-%m-%d')-fs2.tar.gz" fs2
tar -C /u01/OCI -cvzf /u02/DailyBKP/"$(date '+%Y-%m-%d')-fs_ne.tar.gz" fs_ne
find /u02/DailyBKP -type f -name "*.gz" -mtime +7 -exec rm {} \;
[root@rac1 ~]#
Preparation of Target Machine (clone)
Create necessary user & directory structure in Clone Server
login as: root
root@192.168.1.11's
password:
Last login: Tue Aug 15
10:18:23 2017 from 192.168.1.1
[root@clone ~]#
[root@clone ~]# cat
/etc/issue
Oracle Linux Server
release 5.8
Kernel \r on an \m
[root@clone ~]# lsb_release
-id
Distributor ID:
EnterpriseEnterpriseServer
Description: Enterprise Linux Enterprise Linux Server
release 5.8 (Carthage)
[root@clone ~]#
[root@clone ~]# arch
x86_64
[root@clone ~]#
[root@clone ~]# hostname
clone.dell.com
[root@clone ~]#
[root@clone ~]# hostname -i
192.168.1.11
[root@clone ~]# useradd oraclone -g oinstall
[root@clone ~]# mkdir -p
/u01/CLONE/db/apps_st/data
[root@clone ~]# mkdir -p
/u01/db/rman
Check libdb.so.2 file (if not, your HTTP server
will not be up)
If the file is not available on location, then Http Server will not be start (i.e. login page not available)
Error: 500 Internal server error
Error: 500 Internal server error
If the file libdb.so.2 is not available in location then download and unzip at”/usr/lib” folder
if you dint have Oracle Support Access download from here:(Offline Download)
[root@clone ~]#
[root@clone ~]# ll /usr/lib/libdb.so.2
[root@clone ~]# ll /usr/lib/libdb.so.2
ls: /usr/lib/libdb.so.e: No such file or directory
[root@clone ~]# cd /mnt/hgfs/G/EBS_http_PATCH
[root@clone EBS_http_PATCH]# ll p6078836_101330_LINUX
[root@clone EBS_http_PATCH]#
[root@clone EBS_http_PATCH]# unzip p6078836_101330_LINUX
[root@clone EBS_http_PATCH]#
[root@clone EBS_http_PATCH]# ll 6078836/libdb.so.2
-rwxrwxrwx 1 root root 5825 Oct 4 2007 6078836/libdb.so.2
[root@clone EBS_http_PATCH]# cp libdb.so.2 /usr/lib
[root@clone ~]#
[root@clone ~]# ll /usr/lib/libdb.so.2
-rwxr-xr-x 1 root root 5825 Oct 4 2007 /usr/lib/libdb.so.2
[root@clone ~]#
UnTar your backup pieces to desired location
[root@clone ~]#
[root@clone ~]# cd /mnt/hgfs/F/ebs_clone/
[root@clone ~]# cd /mnt/hgfs/F/ebs_clone/
[root@clone ebs_clone]#
ll
total 39271369
-rwxrwxrwx 1 root
root 9846871516 Aug 10 13:40 apps.tar.gz
-rwxrwxrwx 1 root
root 7972200975 Aug 10 13:56
db_tech_st.tar
-rwxrwxrwx 1 root root
22394383572 Aug 10 13:33 RMAN_bkp.tar.gz
[root@clone ebs_clone]#
[root@clone ebs_clone]#
tar
-xvzf apps.tar.gz -C /u01/CLONE
[root@clone ebs_clone]#
[root@clone ebs_clone]# tar -xvzf db_tech_st.tar -C /u01/CLONE/db/
[root@clone ebs_clone]# tar -xvzf db_tech_st.tar -C /u01/CLONE/db/
[root@clone ebs_clone]#
[root@clone ebs_clone]# tar -xvzf RMAN_bkp.tar.gz -C /u01/rman/
[root@clone ebs_clone]# tar -xvzf RMAN_bkp.tar.gz -C /u01/rman/
Change the ownership to clone user
[root@clone ~]#
[root@clone ~]# chown -R oraclone:oinstall /u01/
[root@clone ~]# chown -R oraclone:oinstall /u01/
Running Clone Configuration script on database Tier using dbTechStack option
[root@clone ~]#
[root@clone ~]# su - oraclone
[root@clone ~]# su - oraclone
[oraclone@clone ~]$ cd
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/
[oraclone@clone bin]$ ls
[oraclone@clone bin]$ ls
adcfgclone.pl adchkutl.sh
adclonectx.pl adclone.pl
[oraclone@clone bin]$
[oraclone@clone bin]$ perl
adcfgclone.pl dbTechStack
Copyright (c) 2002 Oracle
Corporation
Redwood Shores,
California, USA
Oracle Applications
Rapid Clone
Version 12.0.0
adcfgclone Version
120.31.12010000.1
Enter the APPS
password : apps password
Running:
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java
-Xmx600M -cp /u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/java:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar
oracle.apps.ad.context.CloneContext -e
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_5081.lst -stage
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone -dbTechStack 2>
/tmp/adcfgclone_5081.err; echo $? > /tmp/adcfgclone_5081.res
Log file located at
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0815105526.log
Provide the values
required for creation of the new Database Context file.
Target System Hostname
(virtual or normal) [clone] :
Target Instance is RAC
(y/n) [n] :
Target System Database
SID : CLONE
Target System Base
Directory : /u01/CLONE
Target System
utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP's
on the Target System [1] :
Target System DATA_TOP
Directory 1 [/u02/oracle/PROD/db/apps_st/data] : /u01/CLONE/db/apps_st/data
Target System RDBMS
ORACLE_HOME Directory [/u01/CLONE/db/tech_st/11.1.0] :
Do you want to
preserve the Display [null] (y/n) ? : y
Do you want the the
target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port
Pool [0-99] : 10
Checking the port pool
10
done: Port Pool 10 is
free
Report file located at
/u01/CLONE/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port
information available at
/u01/CLONE/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Creating the new
Database Context file from :
/u01/CLONE/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp
The new database
context file has been created :
/u01/CLONE/db/tech_st/11.1.0/appsutil/CLONE_clone.xml
Log file located at
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0815105526.log
Check Clone Context
logfile /u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0815105526.log
for details.
Running Rapid Clone
with command:
perl
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl
java=/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/u01/CLONE/db/tech_st/11.1.0/appsutil/clone
component=dbTechStack method=CUSTOM
dbctxtg=/u01/CLONE/db/tech_st/11.1.0/appsutil/CLONE_clone.xml showProgress
contextValidated=true
Running:
perl
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/../jre
mode=apply stage=/u01/CLONE/db/tech_st/11.1.0/appsutil/clone
component=dbTechStack method=CUSTOM
dbctxtg=/u01/CLONE/db/tech_st/11.1.0/appsutil/CLONE_clone.xml showProgress
contextValidated=true
APPS Password :
Beginning rdbms home
Apply - Tue Aug 15 10:57:29 2017
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=true
-Doracle.installer.oui_loc=/u01/CLONE/db/tech_st/11.1.0/oui -classpath
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc6.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/java:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/oui/srvm.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTechStack -e
/u01/CLONE/db/tech_st/11.1.0/appsutil/CLONE_clone.xml -stage
/u01/CLONE/db/tech_st/11.1.0/appsutil/clone
-showProgress
APPS Password : Log
file located at
/u01/CLONE/db/tech_st/11.1.0/appsutil/log/CLONE_clone/ApplyDBTechStack_08151057.log
/
100% completed
Completed Apply...
Tue Aug 15 10:59:02
2017
Starting database
listener for CLONE:
Running:
/u01/CLONE/db/tech_st/11.1.0/appsutil/scripts/CLONE_clone/addlnctl.sh
start CLONE
You are running
addlnctl.sh version 120.1.12010000.2
Logfile: /u01/CLONE/db/tech_st/11.1.0/appsutil/log/CLONE_clone/addlnctl.txt
Starting listener
process CLONE ...
addlnctl.sh: exiting
with status 0
[oraclone@clone bin]$
Restore the control file from RMAN backup.
As we are not using
catalog database from target we need to first restore and recover database
using the same source SID. Later we can change it to required SID (CLONE) using
"nid"
[oraclone@clone bin]$ cd ../../..
[oraclone@clone
11.1.0]$ pwd
/u01/CLONE/db/tech_st/11.1.0
[oraclone@clone
11.1.0]$
[oraclone@clone
11.1.0]$ ll *.env
-rw-r--r-- 1 oraclone
oinstall 4076 Aug 15 10:58 CLONE_clone.env
-rw-r--r-- 1 oraclone
oinstall 4231 Jan 16 2017
PROD_ruh-erpdb01.env
[oraclone@clone
11.1.0]$ . CLONE_clone.env
[oraclone@clone
11.1.0]$ cd dbs
Copy initCLONE.ora to initPROD.ora and change db_name, and check Controlfile location
[oraclone@clone dbs]$
[oraclone@clone dbs]$ mv initPROD.ora bkp_initPROD.ora
[oraclone@clone dbs]$ mv initPROD.ora bkp_initPROD.ora
[oraclone@clone dbs]$
[oraclone@clone dbs]$ cp
initCLONE.ora initPROD.ora
[oraclone@clone dbs]$
[oraclone@clone dbs]$ vi
initPROD.ora
db_name =
PROD
control_files = /u01/CLONE/db/apps_st/data/cntrl01.dbf
Set ORACLE_SID as per your Source_SID
[oraclone@clone
11.1.0]$
[oraclone@clone 11.1.0]$ echo $ORACLE_SID
[oraclone@clone 11.1.0]$ echo $ORACLE_SID
CLONE
[oraclone@clone
11.1.0]$ export ORACLE_SID=PROD
[oraclone@clone
11.1.0]$
[oraclone@clone
11.1.0]$ echo $ORACLE_SID
PROD
[oraclone@clone
11.1.0]$
Start Database in nomount state
[oraclone@clone
11.1.0]$
[oraclone@clone 11.1.0]$ sqlplus / as sysdba
[oraclone@clone 11.1.0]$ sqlplus / as sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Tue Aug 15 11:26:35 2017
Copyright (c) 1982,
2008, Oracle. All rights reserved.
Connected to an idle
instance.
SQL> startup
nomount
ORACLE instance
started.
Total System Global
Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
SQL> exit
Check latest control file in backup pieces in Target_Node:
[oraclone@clone
11.1.0]$
[oraclone@clone 11.1.0]$ cd /u01/rman/RMAN/
[oraclone@clone 11.1.0]$ cd /u01/rman/RMAN/
[oraclone@clone RMAN]$
[oraclone@clone RMAN]$
ls
c-298384717-20170810-00 PROD_20170810_348_1_ARCHIVE
c-298384717-20170810-01
PROD_20170810_349_1_ARCHIVE
PROD_20170810_343_1_FULL PROD_20170810_350_1_ARCHIVE
PROD_20170810_344_1_FULL PROD_20170810_351_1_ARCHIVE
PROD_20170810_345_1_FULL PROD_20170810_352_1_CONTROL
PROD_20170810_346_1_FULL snapcf_PROD.f
[oraclone@clone RMAN]$
[oraclone@clone RMAN]$
rman target / nocatalog
Recovery Manager:
Release 11.1.0.7.0 - Production on Tue Aug 15 11:53:09 2017
Copyright (c) 1982,
2007, Oracle. All rights reserved.
connected to target
database: PROD (not mounted)
using target database
control file instead of recovery catalog
RMAN> restore controlfile from '/u01/rman/RMAN/c-298384717-20170810-01';
Starting restore at
15-AUG-17
allocated channel:
ORA_DISK_1
channel ORA_DISK_1:
SID=383 device type=DISK
channel ORA_DISK_1:
restoring control file
channel ORA_DISK_1:
restore complete, elapsed time: 00:00:01
output file
name=/u01/CLONE/db/apps_st/data/cntrl01.dbf
Finished restore at
15-AUG-17
RMAN>
RMAN> alter database mount;
database mounted
released channel:
ORA_DISK_1
RMAN>
Catalog backup Pieces (not required if location
of rman bkp same on target)
Note: Change the ownership to user for RMAN backup pieces
RMAN>
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_343_1_FULL';
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_343_1_FULL';
cataloged backup piece
backup piece
handle=/u01/rman/RMAN/PROD_20170810_343_1_FULL RECID=330 STAMP=952084698
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_344_1_FULL';
cataloged backup piece
backup piece
handle=/u01/rman/RMAN/PROD_20170810_344_1_FULL RECID=331 STAMP=952084723
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_345_1_FULL';
cataloged backup piece
backup piece
handle=/u01/rman/RMAN/PROD_20170810_345_1_FULL RECID=332 STAMP=952084748
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_346_1_FULL';
cataloged backup piece
backup piece
handle=/u01/rman/RMAN/PROD_20170810_346_1_FULL RECID=333 STAMP=952084770
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_348_1_ARCHIVE';
cataloged backup piece
backup piece
handle=/u01/rman/RMAN/PROD_20170810_348_1_ARCHIVE RECID=334 STAMP=952086551
RMAN> catalog
backuppiece '/u01/rman/RMAN/PROD_20170810_349_1_ARCHIVE';
cataloged backup piece
backup piece
handle=/u01/rman/RMAN/PROD_20170810_349_1_ARCHIVE RECID=335 STAMP=952086563
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_350_1_ARCHIVE';
cataloged backup piece
backup piece handle=/u01/rman/RMAN/PROD_20170810_350_1_ARCHIVE
RECID=336 STAMP=952086577
RMAN> catalog backuppiece '/u01/rman/RMAN/PROD_20170810_351_1_ARCHIVE';
cataloged backup piece
backup piece
handle=/u01/rman/RMAN/PROD_20170810_351_1_ARCHIVE RECID=337 STAMP=952086598
RMAN>
Prepare script for RMAN Restore and Run script (if target location is same “set
newname” not required)
Genrate from source DB:
SQL> select 'set newname for datafile ' || file_id || ' to ''/u01/CLONE/db/apps_st/data/' || substr(file_name,instr(file_name,'/',-1)+1) || ''';' from dba_data_files ;
Genrate from Target DB:
SQL> select 'set newname for datafile ' || file# || ' to ''/u01/CLONE/db/apps_st/data/' || substr(name,instr(name,'/',-1)+1) || ''';' from v$datafile ;
+++-----the following in Orange color is RMAN restore Script-----+++
RMAN>
run {
set newname for datafile 1 to
'/u01/CLONE/db/apps_st/data/system01.dbf';
set newname for datafile 2 to
'/u01/CLONE/db/apps_st/data/system02.dbf';
set newname for datafile 3 to
'/u01/CLONE/db/apps_st/data/system03.dbf';
set newname for datafile 4 to
'/u01/CLONE/db/apps_st/data/system04.dbf';
set newname for datafile 5 to
'/u01/CLONE/db/apps_st/data/system05.dbf';
set newname for datafile 6 to
'/u01/CLONE/db/apps_st/data/ctxd01.dbf';
set newname for datafile 7 to
'/u01/CLONE/db/apps_st/data/owad01.dbf';
set newname for datafile 8 to
'/u01/CLONE/db/apps_st/data/a_queue02.dbf';
set newname for datafile 9 to
'/u01/CLONE/db/apps_st/data/odm.dbf';
set newname for datafile 10 to
'/u01/CLONE/db/apps_st/data/olap.dbf';
set newname for datafile 11 to
'/u01/CLONE/db/apps_st/data/sysaux01.dbf';
set newname for datafile 12 to
'/u01/CLONE/db/apps_st/data/apps_ts_tools01.dbf';
set newname for datafile 13 to
'/u01/CLONE/db/apps_st/data/system12.dbf';
set newname for datafile 14 to
'/u01/CLONE/db/apps_st/data/a_txn_data04.dbf';
set newname for datafile 15 to
'/u01/CLONE/db/apps_st/data/a_txn_ind06.dbf';
set newname for datafile 16 to
'/u01/CLONE/db/apps_st/data/a_ref03.dbf';
set newname for datafile 17 to
'/u01/CLONE/db/apps_st/data/a_int02.dbf';
set newname for datafile 18 to
'/u01/CLONE/db/apps_st/data/sysaux02.dbf';
set newname for datafile 19 to
'/u01/CLONE/db/apps_st/data/a_txn_data05.dbf';
set newname for datafile 20 to
'/u01/CLONE/db/apps_st/data/XXHRCUSTOM01.dbf';
set newname for datafile 21 to
'/u01/CLONE/db/apps_st/data/a_ref04.dbf';
set newname for datafile 22 to '/u01/CLONE/db/apps_st/data/a_txn_ind07.dbf';
set newname for datafile 23 to
'/u01/CLONE/db/apps_st/data/sysaux03.dbf';
set newname for datafile 24 to
'/u01/CLONE/db/apps_st/data/a_txn_data06.dbf';
set newname for datafile 25 to
'/u01/CLONE/db/apps_st/data/a_txn_ind08.dbf';
set newname for datafile 26 to
'/u01/CLONE/db/apps_st/data/a_txn_data07.dbf';
set newname for datafile 27 to
'/u01/CLONE/db/apps_st/data/a_txn_ind09.dbf';
set newname for datafile 28 to
'/u01/CLONE/db/apps_st/data/a_txn_data08.dbf';
set newname for datafile 29 to
'/u01/CLONE/db/apps_st/data/a_txn_data09.dbf';
set newname for datafile 30 to
'/u01/CLONE/db/apps_st/data/a_txn_ind10.dbf';
set newname for datafile 31 to
'/u01/CLONE/db/apps_st/data/a_txn_data010.dbf';
set newname for datafile 32 to '/u01/CLONE/db/apps_st/data/a_txn_ind11.dbf';
set newname for datafile 33 to
'/u01/CLONE/db/apps_st/data/ctxd02.dbf';
set newname for datafile 34 to
'/u01/CLONE/db/apps_st/data/a_txn_data011.dbf';
set newname for datafile 288 to '/u01/CLONE/db/apps_st/data/system10.dbf';
set newname for datafile 295 to '/u01/CLONE/db/apps_st/data/system06.dbf';
set newname for datafile 314 to '/u01/CLONE/db/apps_st/data/portal01.dbf';
set newname for datafile 351 to '/u01/CLONE/db/apps_st/data/system07.dbf';
set newname for datafile 352 to '/u01/CLONE/db/apps_st/data/system09.dbf';
set newname for datafile 353 to '/u01/CLONE/db/apps_st/data/system08.dbf';
set newname for datafile 354 to '/u01/CLONE/db/apps_st/data/system11.dbf';
set newname for datafile 379 to '/u01/CLONE/db/apps_st/data/undo01.dbf';
set newname for datafile 392 to
'/u01/CLONE/db/apps_st/data/a_txn_data01.dbf';
set newname for datafile 393 to
'/u01/CLONE/db/apps_st/data/a_txn_ind01.dbf';
set newname for datafile 394 to '/u01/CLONE/db/apps_st/data/a_ref01.dbf';
set newname for datafile 395 to '/u01/CLONE/db/apps_st/data/a_int01.dbf';
set newname for datafile 396 to '/u01/CLONE/db/apps_st/data/a_summ01.dbf';
set newname for datafile 397 to
'/u01/CLONE/db/apps_st/data/a_nolog01.dbf';
set newname for datafile 398 to
'/u01/CLONE/db/apps_st/data/a_archive01.dbf';
set newname for datafile 399 to
'/u01/CLONE/db/apps_st/data/a_queue01.dbf';
set newname for datafile 400 to
'/u01/CLONE/db/apps_st/data/a_media01.dbf';
set newname for datafile 401 to '/u01/CLONE/db/apps_st/data/a_txn_data02.dbf';
set newname for datafile 402 to
'/u01/CLONE/db/apps_st/data/a_txn_data03.dbf';
set newname for datafile 403 to
'/u01/CLONE/db/apps_st/data/a_txn_ind02.dbf';
set newname for datafile 404 to '/u01/CLONE/db/apps_st/data/a_txn_ind03.dbf';
set newname for datafile 405 to
'/u01/CLONE/db/apps_st/data/a_txn_ind04.dbf';
set newname for datafile 406 to
'/u01/CLONE/db/apps_st/data/a_txn_ind05.dbf';
set newname for datafile 407 to '/u01/CLONE/db/apps_st/data/a_ref02.dbf';
restore database;
switch datafile all; }
+++----------------- END OF SCRIPT ----------------------+++
RMAN> run {
2> set newname for
datafile 1 to '/u01/CLONE/db/apps_st/data/system01.dbf';
3> set newname for
datafile 2 to '/u01/CLONE/db/apps_st/data/system02.dbf';
4> set newname for
datafile 3 to '/u01/CLONE/db/apps_st/data/system03.dbf';
5> set newname for
datafile 4 to '/u01/CLONE/db/apps_st/data/system04.dbf';
6> set newname for
datafile 5 to '/u01/CLONE/db/apps_st/data/system05.dbf';
7> set newname for
datafile 6 to '/u01/CLONE/db/apps_st/data/ctxd01.dbf';
8> set newname for
datafile 7 to '/u01/CLONE/db/apps_st/data/owad01.dbf';
9> set newname for
datafile 8 to '/u01/CLONE/db/apps_st/data/a_queue02.dbf';
10> set newname for
datafile 9 to '/u01/CLONE/db/apps_st/data/odm.dbf';
11> set newname for
datafile 10 to '/u01/CLONE/db/apps_st/data/olap.dbf';
12> set newname for
datafile 11 to '/u01/CLONE/db/apps_st/data/sysaux01.dbf';
13> set newname for
datafile 12 to '/u01/CLONE/db/apps_st/data/apps_ts_tools01.dbf';
14> set newname for
datafile 13 to '/u01/CLONE/db/apps_st/data/system12.dbf';
15> set newname for
datafile 14 to '/u01/CLONE/db/apps_st/data/a_txn_data04.dbf';
16> set newname for
datafile 15 to '/u01/CLONE/db/apps_st/data/a_txn_ind06.dbf';
17> set newname for
datafile 16 to '/u01/CLONE/db/apps_st/data/a_ref03.dbf';
set newname for
datafile 17 to '/u01/CLONE/db/apps_st/data/a_int02.dbf';
18> 19> set
newname for datafile 18 to '/u01/CLONE/db/apps_st/data/sysaux02.dbf';
20> set newname for
datafile 19 to '/u01/CLONE/db/apps_st/data/a_txn_data05.dbf';
21> set newname for
datafile 20 to '/u01/CLONE/db/apps_st/data/XXHRCUSTOM01.dbf';
22> set newname for
datafile 21 to '/u01/CLONE/db/apps_st/data/a_ref04.dbf';
23> set newname for
datafile 22 to '/u01/CLONE/db/apps_st/data/a_txn_ind07.dbf';
24> set newname for
datafile 23 to '/u01/CLONE/db/apps_st/data/sysaux03.dbf';
25> set newname for
datafile 24 to '/u01/CLONE/db/apps_st/data/a_txn_data06.dbf';
26> set newname for
datafile 25 to '/u01/CLONE/db/apps_st/data/a_txn_ind08.dbf';
27> set newname for
datafile 26 to '/u01/CLONE/db/apps_st/data/a_txn_data07.dbf';
28> set newname for
datafile 27 to '/u01/CLONE/db/apps_st/data/a_txn_ind09.dbf';
29> set newname for
datafile 28 to '/u01/CLONE/db/apps_st/data/a_txn_data08.dbf';
30> set newname for
datafile 29 to '/u01/CLONE/db/apps_st/data/a_txn_data09.dbf';
31> set newname for
datafile 30 to '/u01/CLONE/db/apps_st/data/a_txn_ind10.dbf';
32> set newname for
datafile 31 to '/u01/CLONE/db/apps_st/data/a_txn_data010.dbf';
set newname for
datafile 32 to '/u01/CLONE/db/apps_st/data/a_txn_ind11.dbf';
33> 34> set
newname for datafile 33 to '/u01/CLONE/db/apps_st/data/ctxd02.dbf';
35> set newname for
datafile 34 to '/u01/CLONE/db/apps_st/data/a_txn_data011.dbf';
36> set newname for
datafile 288 to
'/u01/CLONE/db/apps_st/data/system10.dbf';
37> set newname for
datafile 295 to
'/u01/CLONE/db/apps_st/data/system06.dbf';
38> set newname for
datafile 314 to
'/u01/CLONE/db/apps_st/data/portal01.dbf';
39> set newname for
datafile 351 to
'/u01/CLONE/db/apps_st/data/system07.dbf';
40> set newname for
datafile 352 to
'/u01/CLONE/db/apps_st/data/system09.dbf';
41> set newname for
datafile 353 to
'/u01/CLONE/db/apps_st/data/system08.dbf';
42> set newname for
datafile 354 to
'/u01/CLONE/db/apps_st/data/system11.dbf';
43> set newname for
datafile 379 to
'/u01/CLONE/db/apps_st/data/undo01.dbf';
44> set newname for
datafile 392 to
'/u01/CLONE/db/apps_st/data/a_txn_data01.dbf';
45> set newname for
datafile 393 to
'/u01/CLONE/db/apps_st/data/a_txn_ind01.dbf';
46> set newname for
datafile 394 to '/u01/CLONE/db/apps_st/data/a_ref01.dbf';
47> set newname for
datafile 395 to
'/u01/CLONE/db/apps_st/data/a_int01.dbf';
set newname for
datafile 396 to
'/u01/CLONE/db/apps_st/data/a_summ01.dbf';
48> 49> set
newname for datafile 397 to
'/u01/CLONE/db/apps_st/data/a_nolog01.dbf';
50> set newname for
datafile 398 to
'/u01/CLONE/db/apps_st/data/a_archive01.dbf';
51> set newname for
datafile 399 to
'/u01/CLONE/db/apps_st/data/a_queue01.dbf';
52> set newname for
datafile 400 to
'/u01/CLONE/db/apps_st/data/a_media01.dbf';
53> set newname for
datafile 401 to
'/u01/CLONE/db/apps_st/data/a_txn_data02.dbf';
54> set newname for
datafile 402 to
'/u01/CLONE/db/apps_st/data/a_txn_data03.dbf';
55> set newname for
datafile 403 to
'/u01/CLONE/db/apps_st/data/a_txn_ind02.dbf';
56> set newname for
datafile 404 to
'/u01/CLONE/db/apps_st/data/a_txn_ind03.dbf';
57> set newname for
datafile 405 to
'/u01/CLONE/db/apps_st/data/a_txn_ind04.dbf';
58> set newname for
datafile 406 to
'/u01/CLONE/db/apps_st/data/a_txn_ind05.dbf';
59> set newname for
datafile 407 to
'/u01/CLONE/db/apps_st/data/a_ref02.dbf';
60> restore
database;
61> switch datafile
all; }
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
Starting restore at
15-AUG-17
using channel
ORA_DISK_1
using channel
ORA_DISK_2
using channel
ORA_DISK_3
using channel
ORA_DISK_4
channel ORA_DISK_1:
starting datafile backup set restore
channel ORA_DISK_1:
specifying datafile(s) to restore from backup set
channel ORA_DISK_1:
restoring datafile 00002 to /u01/CLONE/db/apps_st/data/system02.dbf
channel ORA_DISK_1:
restoring datafile 00008 to /u01/CLONE/db/apps_st/data/a_queue02.dbf
channel ORA_DISK_1:
restoring datafile 00010 to /u01/CLONE/db/apps_st/data/olap.dbf
channel ORA_DISK_1:
restoring datafile 00012 to /u01/CLONE/db/apps_st/data/apps_ts_tools01.dbf
channel ORA_DISK_1:
restoring datafile 00018 to /u01/CLONE/db/apps_st/data/sysaux02.dbf
channel ORA_DISK_1:
restoring datafile 00020 to /u01/CLONE/db/apps_st/data/XXHRCUSTOM01.dbf
channel ORA_DISK_1:
restoring datafile 00021 to /u01/CLONE/db/apps_st/data/a_ref04.dbf
channel ORA_DISK_1:
restoring datafile 00022 to /u01/CLONE/db/apps_st/data/a_txn_ind07.dbf
channel ORA_DISK_1:
restoring datafile 00026 to /u01/CLONE/db/apps_st/data/a_txn_data07.dbf
channel ORA_DISK_1:
restoring datafile 00027 to /u01/CLONE/db/apps_st/data/a_txn_ind09.dbf
channel ORA_DISK_1:
restoring datafile 00030 to /u01/CLONE/db/apps_st/data/a_txn_ind10.dbf
channel ORA_DISK_1:
restoring datafile 00353 to /u01/CLONE/db/apps_st/data/system08.dbf
channel ORA_DISK_1:
restoring datafile 00395 to /u01/CLONE/db/apps_st/data/a_int01.dbf
channel ORA_DISK_1:
restoring datafile 00400 to /u01/CLONE/db/apps_st/data/a_media01.dbf
channel ORA_DISK_1:
restoring datafile 00401 to /u01/CLONE/db/apps_st/data/a_txn_data02.dbf
channel ORA_DISK_1:
reading from backup piece /u02/BACKUP/RMAN/PROD_20170810_345_1_FULL
channel ORA_DISK_2:
starting datafile backup set restore
channel ORA_DISK_2:
specifying datafile(s) to restore from backup set
channel ORA_DISK_2:
restoring datafile 00003 to /u01/CLONE/db/apps_st/data/system03.dbf
channel ORA_DISK_2:
restoring datafile 00006 to /u01/CLONE/db/apps_st/data/ctxd01.dbf
channel ORA_DISK_2:
restoring datafile 00009 to /u01/CLONE/db/apps_st/data/odm.dbf
channel ORA_DISK_2:
restoring datafile 00015 to /u01/CLONE/db/apps_st/data/a_txn_ind06.dbf
channel ORA_DISK_2:
restoring datafile 00019 to /u01/CLONE/db/apps_st/data/a_txn_data05.dbf
channel ORA_DISK_2:
restoring datafile 00023 to /u01/CLONE/db/apps_st/data/sysaux03.dbf
channel ORA_DISK_2:
restoring datafile 00028 to /u01/CLONE/db/apps_st/data/a_txn_data08.dbf
channel ORA_DISK_2:
restoring datafile 00032 to /u01/CLONE/db/apps_st/data/a_txn_ind11.dbf
channel ORA_DISK_2:
restoring datafile 00354 to /u01/CLONE/db/apps_st/data/system11.dbf
channel ORA_DISK_2:
restoring datafile 00379 to /u01/CLONE/db/apps_st/data/undo01.dbf
channel ORA_DISK_2:
restoring datafile 00393 to /u01/CLONE/db/apps_st/data/a_txn_ind01.dbf
channel ORA_DISK_2:
restoring datafile 00397 to /u01/CLONE/db/apps_st/data/a_nolog01.dbf
channel ORA_DISK_2:
restoring datafile 00398 to /u01/CLONE/db/apps_st/data/a_archive01.dbf
channel ORA_DISK_2:
restoring datafile 00399 to /u01/CLONE/db/apps_st/data/a_queue01.dbf
channel ORA_DISK_2:
restoring datafile 00403 to /u01/CLONE/db/apps_st/data/a_txn_ind02.dbf
channel ORA_DISK_2:
reading from backup piece /u02/BACKUP/RMAN/PROD_20170810_346_1_FULL
channel ORA_DISK_3:
starting datafile backup set restore
channel ORA_DISK_3:
specifying datafile(s) to restore from backup set
channel ORA_DISK_3:
restoring datafile 00004 to /u01/CLONE/db/apps_st/data/system04.dbf
channel ORA_DISK_3:
restoring datafile 00007 to /u01/CLONE/db/apps_st/data/owad01.dbf
channel ORA_DISK_3:
restoring datafile 00011 to /u01/CLONE/db/apps_st/data/sysaux01.dbf
channel ORA_DISK_3:
restoring datafile 00014 to /u01/CLONE/db/apps_st/data/a_txn_data04.dbf
channel ORA_DISK_3:
restoring datafile 00025 to /u01/CLONE/db/apps_st/data/a_txn_ind08.dbf
channel ORA_DISK_3:
restoring datafile 00031 to /u01/CLONE/db/apps_st/data/a_txn_data010.dbf
channel ORA_DISK_3:
restoring datafile 00033 to /u01/CLONE/db/apps_st/data/ctxd02.dbf
channel ORA_DISK_3:
restoring datafile 00034 to /u01/CLONE/db/apps_st/data/a_txn_data011.dbf
channel ORA_DISK_3:
restoring datafile 00295 to /u01/CLONE/db/apps_st/data/system06.dbf
channel ORA_DISK_3:
restoring datafile 00314 to /u01/CLONE/db/apps_st/data/portal01.dbf
channel ORA_DISK_3:
restoring datafile 00351 to /u01/CLONE/db/apps_st/data/system07.dbf
channel ORA_DISK_3:
restoring datafile 00394 to /u01/CLONE/db/apps_st/data/a_ref01.dbf
channel ORA_DISK_3:
restoring datafile 00396 to /u01/CLONE/db/apps_st/data/a_summ01.dbf
channel ORA_DISK_3:
restoring datafile 00402 to /u01/CLONE/db/apps_st/data/a_txn_data03.dbf
channel ORA_DISK_3:
restoring datafile 00406 to /u01/CLONE/db/apps_st/data/a_txn_ind05.dbf
channel ORA_DISK_3:
reading from backup piece /u02/BACKUP/RMAN/PROD_20170810_343_1_FULL
channel ORA_DISK_4:
starting datafile backup set restore
channel ORA_DISK_4:
specifying datafile(s) to restore from backup set
channel ORA_DISK_4:
restoring datafile 00001 to /u01/CLONE/db/apps_st/data/system01.dbf
channel ORA_DISK_4:
restoring datafile 00005 to /u01/CLONE/db/apps_st/data/system05.dbf
channel ORA_DISK_4:
restoring datafile 00013 to /u01/CLONE/db/apps_st/data/system12.dbf
channel ORA_DISK_4:
restoring datafile 00016 to /u01/CLONE/db/apps_st/data/a_ref03.dbf
channel ORA_DISK_4:
restoring datafile 00017 to /u01/CLONE/db/apps_st/data/a_int02.dbf
channel ORA_DISK_4:
restoring datafile 00024 to /u01/CLONE/db/apps_st/data/a_txn_data06.dbf
channel ORA_DISK_4:
restoring datafile 00029 to /u01/CLONE/db/apps_st/data/a_txn_data09.dbf
channel ORA_DISK_4:
restoring datafile 00288 to /u01/CLONE/db/apps_st/data/system10.dbf
channel ORA_DISK_4:
restoring datafile 00352 to /u01/CLONE/db/apps_st/data/system09.dbf
channel ORA_DISK_4:
restoring datafile 00392 to /u01/CLONE/db/apps_st/data/a_txn_data01.dbf
channel ORA_DISK_4:
restoring datafile 00404 to /u01/CLONE/db/apps_st/data/a_txn_ind03.dbf
channel ORA_DISK_4:
restoring datafile 00405 to /u01/CLONE/db/apps_st/data/a_txn_ind04.dbf
channel ORA_DISK_4:
restoring datafile 00407 to /u01/CLONE/db/apps_st/data/a_ref02.dbf
channel ORA_DISK_4:
reading from backup piece /u02/BACKUP/RMAN/PROD_20170810_344_1_FULL
channel ORA_DISK_1:
errors found reading piece handle=/u02/BACKUP/RMAN/PROD_20170810_345_1_FULL
channel ORA_DISK_1:
failover to piece handle=/u01/rman/RMAN/PROD_20170810_345_1_FULL tag=SC_FULL
channel ORA_DISK_1:
restored backup piece 1
channel ORA_DISK_1:
restore complete, elapsed time: 01:06:52
channel ORA_DISK_2:
errors found reading piece handle=/u02/BACKUP/RMAN/PROD_20170810_346_1_FULL
channel ORA_DISK_2:
failover to piece handle=/u01/rman/RMAN/PROD_20170810_346_1_FULL tag=SC_FULL
channel ORA_DISK_2:
restored backup piece 1
channel ORA_DISK_2:
restore complete, elapsed time: 01:07:22
channel ORA_DISK_4:
errors found reading piece handle=/u02/BACKUP/RMAN/PROD_20170810_344_1_FULL
channel ORA_DISK_4:
failover to piece handle=/u01/rman/RMAN/PROD_20170810_344_1_FULL tag=SC_FULL
channel ORA_DISK_4:
restored backup piece 1
channel ORA_DISK_4:
restore complete, elapsed time: 01:07:22
channel ORA_DISK_3:
errors found reading piece handle=/u02/BACKUP/RMAN/PROD_20170810_343_1_FULL
channel ORA_DISK_3:
failover to piece handle=/u01/rman/RMAN/PROD_20170810_343_1_FULL tag=SC_FULL
channel ORA_DISK_3:
restored backup piece 1
channel ORA_DISK_3:
restore complete, elapsed time: 01:08:43
Finished restore at
15-AUG-17
datafile 1 switched to
datafile copy
input datafile copy
RECID=59 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/system01.dbf
datafile 2 switched to
datafile copy
input datafile copy
RECID=60 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/system02.dbf
datafile 3 switched to
datafile copy
input datafile copy
RECID=61 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/system03.dbf
datafile 4 switched to
datafile copy
input datafile copy
RECID=62 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/system04.dbf
datafile 5 switched to
datafile copy
input datafile copy
RECID=63 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/system05.dbf
datafile 6 switched to
datafile copy
input datafile copy
RECID=64 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/ctxd01.dbf
datafile 7 switched to
datafile copy
input datafile copy
RECID=65 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/owad01.dbf
datafile 8 switched to
datafile copy
input datafile copy
RECID=66 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/a_queue02.dbf
datafile 9 switched to
datafile copy
input datafile copy
RECID=67 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/odm.dbf
datafile 10 switched
to datafile copy
input datafile copy
RECID=68 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/olap.dbf
datafile 11 switched
to datafile copy
input datafile copy
RECID=69 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/sysaux01.dbf
datafile 12 switched
to datafile copy
input datafile copy
RECID=70 STAMP=952091708 file
name=/u01/CLONE/db/apps_st/data/apps_ts_tools01.dbf
datafile 13 switched
to datafile copy
input datafile copy
RECID=71 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/system12.dbf
datafile 14 switched
to datafile copy
input datafile copy
RECID=72 STAMP=952091708 file name=/u01/CLONE/db/apps_st/data/a_txn_data04.dbf
datafile 15 switched
to datafile copy
input datafile copy
RECID=73 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_ind06.dbf
datafile 16 switched
to datafile copy
input datafile copy
RECID=74 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_ref03.dbf
datafile 17 switched
to datafile copy
input datafile copy
RECID=75 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_int02.dbf
datafile 18 switched
to datafile copy
input datafile copy
RECID=76 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/sysaux02.dbf
datafile 19 switched
to datafile copy
input datafile copy
RECID=77 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_data05.dbf
datafile 20 switched
to datafile copy
input datafile copy
RECID=78 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/XXHRCUSTOM01.dbf
datafile 21 switched
to datafile copy
input datafile copy
RECID=79 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_ref04.dbf
datafile 22 switched
to datafile copy
input datafile copy
RECID=80 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_ind07.dbf
datafile 23 switched
to datafile copy
input datafile copy
RECID=81 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/sysaux03.dbf
datafile 24 switched
to datafile copy
input datafile copy
RECID=82 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_data06.dbf
datafile 25 switched
to datafile copy
input datafile copy
RECID=83 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_ind08.dbf
datafile 26 switched
to datafile copy
input datafile copy
RECID=84 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_data07.dbf
datafile 27 switched
to datafile copy
input datafile copy
RECID=85 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_ind09.dbf
datafile 28 switched
to datafile copy
input datafile copy
RECID=86 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_data08.dbf
datafile 29 switched
to datafile copy
input datafile copy
RECID=87 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_data09.dbf
datafile 30 switched
to datafile copy
input datafile copy
RECID=88 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_ind10.dbf
datafile 31 switched
to datafile copy
input datafile copy
RECID=89 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_data010.dbf
datafile 32 switched
to datafile copy
input datafile copy
RECID=90 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_ind11.dbf
datafile 33 switched
to datafile copy
input datafile copy
RECID=91 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/ctxd02.dbf
datafile 34 switched
to datafile copy
input datafile copy
RECID=92 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/a_txn_data011.dbf
datafile 288 switched
to datafile copy
input datafile copy
RECID=93 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/system10.dbf
datafile 295 switched
to datafile copy
input datafile copy
RECID=94 STAMP=952091709 file name=/u01/CLONE/db/apps_st/data/system06.dbf
datafile 314 switched
to datafile copy
input datafile copy
RECID=95 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/portal01.dbf
datafile 351 switched
to datafile copy
input datafile copy
RECID=96 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/system07.dbf
datafile 352 switched
to datafile copy
input datafile copy
RECID=97 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/system09.dbf
datafile 353 switched
to datafile copy
input datafile copy
RECID=98 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/system08.dbf
datafile 354 switched
to datafile copy
input datafile copy
RECID=99 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/system11.dbf
datafile 379 switched
to datafile copy
input datafile copy
RECID=100 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/undo01.dbf
datafile 392 switched
to datafile copy
input datafile copy
RECID=101 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_data01.dbf
datafile 393 switched
to datafile copy
input datafile copy
RECID=102 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_ind01.dbf
datafile 394 switched
to datafile copy
input datafile copy
RECID=103 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_ref01.dbf
datafile 395 switched
to datafile copy
input datafile copy
RECID=104 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_int01.dbf
datafile 396 switched
to datafile copy
input datafile copy
RECID=105 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_summ01.dbf
datafile 397 switched
to datafile copy
input datafile copy
RECID=106 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_nolog01.dbf
datafile 398 switched
to datafile copy
input datafile copy
RECID=107 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_archive01.dbf
datafile 399 switched
to datafile copy
input datafile copy
RECID=108 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_queue01.dbf
datafile 400 switched
to datafile copy
input datafile copy
RECID=109 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_media01.dbf
datafile 401 switched
to datafile copy
input datafile copy
RECID=110 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_data02.dbf
datafile 402 switched
to datafile copy
input datafile copy
RECID=111 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_data03.dbf
datafile 403 switched
to datafile copy
input datafile copy
RECID=112 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_ind02.dbf
datafile 404 switched
to datafile copy
input datafile copy
RECID=113 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_ind03.dbf
datafile 405 switched
to datafile copy
input datafile copy
RECID=114 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_ind04.dbf
datafile 406 switched
to datafile copy
input datafile copy
RECID=115 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_txn_ind05.dbf
datafile 407 switched
to datafile copy
input datafile copy
RECID=116 STAMP=952091710 file name=/u01/CLONE/db/apps_st/data/a_ref02.dbf
RMAN>
Check for last Archive log Sequence number
RMAN>
RMAN> list backup of archivelog all;
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size
------- ----------
325 1.49G
List of Archived Logs in backup set 325
Thrd Seq
Low SCN Low Time Next SCN
Next Time
---- ------- ---------- --------- ----------
---------
1
717 5966512484111 03-AUG-17
5966512858566 03-AUG-17
1
718 5966512858566 03-AUG-17
5966513737587 05-AUG-17
1
719 5966513737587 05-AUG-17
5966514796511 07-AUG-17
1
720 5966514796511 07-AUG-17
5966517128807 08-AUG-17
1
721 5966517128807 08-AUG-17
5966517800106 10-AUG-17
1
722 5966517800106 10-AUG-17
5966517801588 10-AUG-17
1 723 5966517801588 10-AUG-17 5966517801596 10-AUG-17
Backup Set Copy #1 of backup set 325
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:03:31 10-AUG-17 YES SC_ARCHIVE
List of Backup Pieces for backup set 325
Copy #1
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
325
1 AVAILABLE /u02/BACKUP/RMAN/PROD_20170810_351_1_ARCHIVE
Backup Set Copy #2 of backup set 325
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:03:31 15-AUG-17 YES SC_ARCHIVE
List of Backup Pieces for backup set 325
Copy #2
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
337
1 AVAILABLE /u01/rman/RMAN/PROD_20170810_351_1_ARCHIVE
BS Key Size
------- ----------
326 2.43G
List of Archived Logs in backup set 326
Thrd Seq
Low SCN Low Time Next SCN
Next Time
---- ------- ---------- --------- ----------
---------
1
693 5966482899186 27-JUN-17
5966483719717 29-JUN-17
1
694 5966483719717 29-JUN-17
5966486071316 01-JUL-17
1
695 5966486071316 01-JUL-17
5966487495795 04-JUL-17
1
696 5966487495795 04-JUL-17
5966488271819 06-JUL-17
1
697 5966488271819 06-JUL-17
5966489300003 09-JUL-17
1
698 5966489300003 09-JUL-17
5966489435818 09-JUL-17
1
699 5966489435818 09-JUL-17
5966490058699 11-JUL-17
1
700 5966490058699 11-JUL-17
5966492730734 12-JUL-17
Backup Set Copy #1 of backup set 326
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:05:40 10-AUG-17 YES SC_ARCHIVE
List
of Backup Pieces for backup set 326 Copy #1
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
326
1 AVAILABLE /u02/BACKUP/RMAN/PROD_20170810_349_1_ARCHIVE
Backup Set Copy #2 of backup set 326
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:05:40 15-AUG-17 YES SC_ARCHIVE
List of Backup Pieces for backup set 326
Copy #2
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
335
1 AVAILABLE /u01/rman/RMAN/PROD_20170810_349_1_ARCHIVE
BS Key Size
------- ----------
327 2.43G
List of Archived Logs in backup set 327
Thrd Seq
Low SCN Low Time Next SCN
Next Time
---- ------- ---------- --------- ----------
---------
1
709 5966502709722 23-JUL-17
5966504027288 23-JUL-17
1
710 5966504027288 23-JUL-17
5966505440175 24-JUL-17
1
711 5966505440175 24-JUL-17
5966506229048 25-JUL-17
1 712
5966506229048 25-JUL-17 5966507818557 26-JUL-17
1
713 5966507818557 26-JUL-17
5966508599056 29-JUL-17
1
714 5966508599056 29-JUL-17
5966511231897 30-JUL-17
1
715 5966511231897 30-JUL-17
5966512061716 02-AUG-17
1
716 5966512061716 02-AUG-17
5966512484111 03-AUG-17
Backup Set Copy #1 of backup set 327
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:05:42 10-AUG-17 YES SC_ARCHIVE
List of Backup Pieces for backup set 327
Copy #1
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
327
1 AVAILABLE /u02/BACKUP/RMAN/PROD_20170810_348_1_ARCHIVE
Backup Set Copy #2 of backup set 327
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:05:42 15-AUG-17 YES SC_ARCHIVE
List of Backup Pieces for backup set 327
Copy #2
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
334
1 AVAILABLE /u01/rman/RMAN/PROD_20170810_348_1_ARCHIVE
BS Key Size
------- ----------
328 2.49G
List of Archived Logs in backup set 328
Thrd Seq
Low SCN Low Time Next SCN
Next Time
---- ------- ---------- --------- ----------
---------
1
701 5966492730734 12-JUL-17
5966494153892 13-JUL-17
1
702 5966494153892 13-JUL-17
5966495342584 14-JUL-17
1
703 5966495342584 14-JUL-17
5966496415352 16-JUL-17
1
704 5966496415352 16-JUL-17
5966497028644 18-JUL-17
1
705 5966497028644 18-JUL-17
5966497371850 19-JUL-17
1
706 5966497371850 19-JUL-17
5966499901034 20-JUL-17
1
707 5966499901034 20-JUL-17
5966500668593 22-JUL-17
1
708 5966500668593 22-JUL-17
5966502709722 23-JUL-17
Backup Set Copy #1 of backup set 328
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:05:47 10-AUG-17 YES SC_ARCHIVE
List of Backup Pieces for backup set 328
Copy #1
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
328
1 AVAILABLE /u02/BACKUP/RMAN/PROD_20170810_350_1_ARCHIVE
Backup Set Copy #2 of backup set 328
Device Type Elapsed Time Completion Time
Compressed Tag
----------- ------------ ---------------
---------- ---
DISK
00:05:47 15-AUG-17 YES SC_ARCHIVE
List of Backup Pieces for backup set 328 Copy
#2
BP Key
Pc# Status Piece Name
------- --- ----------- ----------
336
1 AVAILABLE /u01/rman/RMAN/PROD_20170810_350_1_ARCHIVE
RMAN>
RMAN>
Recover the Database till last sequence
RMAN>
RMAN> run {
RMAN> run {
2> set until sequence 724 thread 1;
3> recover
database;}
executing command: SET
until clause
Starting recover at
15-AUG-17
using channel
ORA_DISK_1
using channel
ORA_DISK_2
using channel
ORA_DISK_3
using channel
ORA_DISK_4
starting media
recovery
channel ORA_DISK_1:
starting archived log restore to default destination
channel ORA_DISK_1:
restoring archived log
archived log thread=1
sequence=722
channel ORA_DISK_1:
restoring archived log
archived log thread=1
sequence=723
channel ORA_DISK_1:
reading from backup piece /u02/BACKUP/RMAN/PROD_20170810_351_1_ARCHIVE
channel ORA_DISK_1:
errors found reading piece handle=/u02/BACKUP/RMAN/PROD_20170810_351_1_ARCHIVE
channel ORA_DISK_1:
failover to piece handle=/u01/rman/RMAN/PROD_20170810_351_1_ARCHIVE
tag=SC_ARCHIVE
channel ORA_DISK_1:
restored backup piece 1
channel ORA_DISK_1:
restore complete, elapsed time: 00:00:01
archived log file
name=/u01/CLONE/db/tech_st/11.1.0/dbs/arch1_722_886546382.dbf thread=1
sequence=722
archived log file
name=/u01/CLONE/db/tech_st/11.1.0/dbs/arch1_723_886546382.dbf thread=1
sequence=723
media recovery
complete, elapsed time: 00:00:01
Finished recover at
15-AUG-17
RMAN>
RMAN> exit
Recovery Manager
complete.
[oraclone@clone RMAN]$
Rename Online LOGFILES:
[oraclone@clone RMAN]$
[oraclone@clone RMAN]$ sqlplus / as sysdba
[oraclone@clone RMAN]$ sqlplus / as sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Tue Aug 15 14:08:48 2017
Copyright (c) 1982,
2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL> select NAME,OPEN_MODE from v$database;
NAME OPEN_MODE
--------- ----------
PROD MOUNTED
SQL>
SQL>
SQL> select
member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u02/oracle/PROD/db/apps_st/data/log02a.dbf
/u02/oracle/PROD/db/apps_st/data/log02b.dbf
/u02/oracle/PROD/db/apps_st/data/log01a.dbf
/u02/oracle/PROD/db/apps_st/data/log01b.dbf
SQL>
SQL> alter database rename file '/u02/oracle/PROD/db/apps_st/data/log02a.dbf' to '/u01/CLONE/db/apps_st/data/log02a.dbf';
SQL> alter database rename file '/u02/oracle/PROD/db/apps_st/data/log02a.dbf' to '/u01/CLONE/db/apps_st/data/log02a.dbf';
Database altered.
SQL> alter
database rename file '/u02/oracle/PROD/db/apps_st/data/log02b.dbf' to
'/u01/CLONE/db/apps_st/data/log02b.dbf';
Database altered.
SQL> alter
database rename file '/u02/oracle/PROD/db/apps_st/data/log01a.dbf' to
'/u01/CLONE/db/apps_st/data/log01a.dbf';
Database altered.
SQL> alter
database rename file '/u02/oracle/PROD/db/apps_st/data/log01b.dbf' to
'/u01/CLONE/db/apps_st/data/log01b.dbf';
Database altered.
SQL>
Disable Archive log and Open Database using Resetlogs
SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/CLONE/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence 722
Next log sequence to archive 723
Current log sequence 723
SQL> alter database noarchivelog;
SQL> alter database open resetlogs;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/CLONE/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence 722
Next log sequence to archive 723
Current log sequence 723
SQL> alter database noarchivelog;
Database altered.
SQL>SQL> alter database open resetlogs;
Database altered.
SQL>
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/CLONE/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence 1
Current log sequence 1
SQL>
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/CLONE/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence 1
Current log sequence 1
SQL>
Create and Drop TEMP tablespace
SQL>
SQL> col TABLESPACE_NAME for a20;
SQL>
SQL> select TABLESPACE_NAME, STATUS from DBA_TEMP_FILES;
TABLESPACE_NAME STATUS
-------------------- ---------
TEMP1 AVAILABLE
TEMP2 AVAILABLE
TEMP2 AVAILABLE
SQL>
SQL>
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u02/oracle/PROD/db/apps_st/data/temp01.dbf
/u02/oracle/PROD/db/apps_st/data/temp02.dbf
/u02/oracle/PROD/db/apps_st/data/temp03.dbf
SQL>
SQL> create TEMPORARY TABLESPACE TEMP3 TEMPFILE '/u01/CLONE/db/apps_st/data/temp003.dbf' size 2048M;
SQL> col TABLESPACE_NAME for a20;
SQL>
SQL> select TABLESPACE_NAME, STATUS from DBA_TEMP_FILES;
TABLESPACE_NAME STATUS
-------------------- ---------
TEMP1 AVAILABLE
TEMP2 AVAILABLE
TEMP2 AVAILABLE
SQL>
SQL>
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u02/oracle/PROD/db/apps_st/data/temp01.dbf
/u02/oracle/PROD/db/apps_st/data/temp02.dbf
/u02/oracle/PROD/db/apps_st/data/temp03.dbf
SQL>
SQL> create TEMPORARY TABLESPACE TEMP3 TEMPFILE '/u01/CLONE/db/apps_st/data/temp003.dbf' size 2048M;
Tablespace created.
SQL> ALTER
DATABASE DEFAULT TEMPORARY TABLESPACE temp3;
Database altered.
SQL> drop
tablespace temp1 including contents and datafiles;
Tablespace dropped.
SQL> drop
tablespace temp2 including contents and datafiles;
Tablespace dropped.
SQL>
Change Database name using “nid” command
SQL>
SQL> shut immediate
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut
down.
SQL>
SQL> startup
mount
ORACLE instance
started.
Total System Global
Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
Database mounted.
SQL> exit
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
[oraclone@clone RMAN]$
[oraclone@clone ~]$ echo
$ORACLE_SID
PROD
[oraclone@clone ~]$
[oraclone@clone ~]$ nid
TARGET=SYS/oracle DBNAME=CLONE
DBNEWID: Release
11.1.0.7.0 - Production on Tue Aug 15 14:20:47 2017
Copyright (c) 1982,
2007, Oracle. All rights reserved.
Connected to database
PROD (DBID=298384717)
Connected to server
version 11.1.0
Control Files in
database:
/u01/CLONE/db/apps_st/data/cntrl01.dbf
Change database ID and
database name PROD to CLONE? (Y/[N]) => Y
Proceeding with
operation
Changing database ID
from 298384717 to 1150887423
Changing database name
from PROD to CLONE
Control File
/u01/CLONE/db/apps_st/data/cntrl01.dbf - modified
Datafile
/u01/CLONE/db/apps_st/data/system01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system02.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/system03.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system04.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system05.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/ctxd01.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/owad01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_queue02.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/odm.db
- dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/olap.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/sysaux01.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/apps_ts_tools01.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system12.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data04.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/a_txn_ind06.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_ref03.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_int02.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/sysaux02.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data05.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/XXHRCUSTOM01.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/a_ref04.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind07.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/sysaux03.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data06.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind08.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data07.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind09.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data08.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data09.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/a_txn_ind10.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data010.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind11.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/ctxd02.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data011.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system10.db - dbid changed, wrote new name
Datafile /u01/CLONE/db/apps_st/data/system06.db
- dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/portal01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system07.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system09.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system08.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/system11.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/undo01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_ref01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_int01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_summ01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_nolog01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_archive01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_queue01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_media01.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data02.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_data03.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind02.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind03.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind04.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_txn_ind05.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/a_ref02.db - dbid changed, wrote new name
Datafile
/u01/CLONE/db/apps_st/data/temp003.db - dbid changed, wrote new name
Control File
/u01/CLONE/db/apps_st/data/cntrl01.dbf - dbid changed, wrote new name
Instance shut down
Database name changed
to CLONE.
Modify parameter file
and generate a new password file before restarting.
Database ID for
database CLONE changed to 1150887423.
All previous backups
and archived redo logs for this database are unusable.
Database has been
shutdown, open database with RESETLOGS option.
Succesfully changed
database name and ID.
DBNEWID - Completed
succesfully.
[oraclone@clone ~]$
[oraclone@clone ~]$
Change ORACLE SID to TARGET and start databse with resetlogs;
[oraclone@clone ~]$
[oraclone@clone ~]$ cd $ORACLE_HOME
[oraclone@clone ~]$ cd $ORACLE_HOME
[oraclone@clone
11.1.0]$ echo $ORACLE_SID
PROD
[oraclone@clone
11.1.0]$ . CLONE_clone.env
[oraclone@clone
11.1.0]$ echo $ORACLE_SID
CLONE
[oraclone@clone 11.1.0]$
Check controlfile location in initclone.ora file
[oraclone@clone
11.1.0]$
[oraclone@clone 11.1.0]$ cd dbs
[oraclone@clone 11.1.0]$ cd dbs
[oraclone@clone dbs]$ vi
initCLONE.ora
control_files =
/u01/CLONE/db/apps_st/data/cntrl01.dbf
[oraclone@clone dbs]$ echo
$ORACLE_SID
CLONE
[oraclone@clone dbs]$ sqlplus / as
sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Tue Aug 15 14:39:15 2017
Copyright (c) 1982,
2008, Oracle. All rights reserved.
Connected to an idle
instance.
SQL> startup
mount;
ORACLE instance
started.
Total System Global
Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
Database mounted.
SQL>
SQL> alter
database open resetlogs;
Database altered.
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- ----------
CLONE READ WRITE
SQL>
SQL>
SQL> col TABLESPACE_NAME for a20;
SQL> col FILE_NAME for a45;
SQL> select TABLESPACE_NAME, FILE_NAME, STATUS from DBA_TEMP_FILES;
TABLESPACE_NAME FILE_NAME STATUS
-------------------- --------------------------------------------- ---------
TEMP3 /u01/PTEST/db/apps_st/data/temp003.dbf AVAILABLE
SQL>
SQL>
SQL> col TABLESPACE_NAME for a20;
SQL> col FILE_NAME for a45;
SQL> select TABLESPACE_NAME, FILE_NAME, STATUS from DBA_TEMP_FILES;
TABLESPACE_NAME FILE_NAME STATUS
-------------------- --------------------------------------------- ---------
TEMP3 /u01/PTEST/db/apps_st/data/temp003.dbf AVAILABLE
SQL>
To check component list and last applied bundel patch
SQL> select comp_id,comp_name,version,status from dba_registry;
SQL>
SQL> select description from dba_registry_sqlpatch;SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oraclone@clone dbs]$
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oraclone@clone dbs]$
Run autoconfig on database Tier
[oraclone@clone
CLONE_clone]$
[oraclone@clone CLONE_clone]$ pwd
[oraclone@clone CLONE_clone]$ pwd
/u01/CLONE/db/tech_st/11.1.0/appsutil/scripts/CLONE_clone
[oraclone@clone
CLONE_clone]$ ls
adautocfg.sh addbctl.sh
adexecsql.pl adpreclone.pl adstrtdb.sql
adchknls.pl addlnctl.sh adlsnodes.sh
adstopdb.sql
[oraclone@clone
CLONE_clone]$ adautocfg.sh
Enter the APPS user
password:
The log file for this
session is located at:
/u01/CLONE/db/tech_st/11.1.0/appsutil/log/CLONE_clone/08151444/adconfig.log
AutoConfig is
configuring the Database environment...
AutoConfig will
consider the custom templates if present.
Using ORACLE_HOME location :
/u01/CLONE/db/tech_st/11.1.0
Classpath :
:/u01/CLONE/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/java:/u01/CLONE/db/tech_st/11.1.0/jlib/netcfg.jar:/u01/CLONE/db/tech_st/11.1.0/jlib/ldapjclnt11.jar
Using Context file :
/u01/CLONE/db/tech_st/11.1.0/appsutil/CLONE_clone.xml
Context Value
Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and
templates to database...COMPLETED
Updating rdbms version
in Context file to db111
Updating rdbms type in
Context file to 64 bits
Configuring templates
from ORACLE_HOME ...
AutoConfig completed
successfully.
[oraclone@clone
CLONE_clone]$
Run Clone Configuration script on Apps Tier
[root@clone ~]#
[root@clone ~]# su - oraclone
[root@clone ~]# su - oraclone
[oraclone@clone ~]$ cd
/u01/CLONE/apps/apps_st/comn/clone/bin/
[oraclone@clone bin]$
[oraclone@clone bin]$ ls
adaddnode.pl adcfgclone.pl
adchkutl.sh adclonectx.pl adclone.pl
[oraclone@clone bin]$ perl
adcfgclone.pl appsTier
Copyright (c) 2002 Oracle
Corporation
Redwood Shores, California,
USA
Oracle Applications
Rapid Clone
Version 12.0.0
adcfgclone Version
120.31.12010000.8
Enter the APPS
password :
Running:
/u01/CLONE/apps/apps_st/comn/clone/bin/../jre/bin/java
-Xmx600M -cp
/u01/CLONE/apps/apps_st/comn/clone/jlib/java:/u01/CLONE/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/CLONE/apps/apps_st/comn/clone/jlib/ojdbc14.jar
oracle.apps.ad.context.CloneContext -e
/u01/CLONE/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate
-pairsfile /tmp/adpairsfile_13523.lst -stage
/u01/CLONE/apps/apps_st/comn/clone 2>
/tmp/adcfgclone_13523.err; echo $? > /tmp/adcfgclone_13523.res
Log file located at
/u01/CLONE/apps/apps_st/comn/clone/bin/CloneContext_0815144835.log
Provide the values
required for creation of the new APPL_TOP Context file.
Target System Hostname
(virtual or normal) [clone] :
Target System Database
SID : CLONE
Target System Database
Server Node [clone] :
Target System Database
Domain Name [dell.com] :
Target System Base
Directory : /u01/CLONE
Target System Tools
ORACLE_HOME Directory [/u01/CLONE/apps/tech_st/10.1.2] :
Target System Web
ORACLE_HOME Directory [/u01/CLONE/apps/tech_st/10.1.3] :
Target System APPL_TOP
Directory [/u01/CLONE/apps/apps_st/appl] :
Target System
COMMON_TOP Directory [/u01/CLONE/apps/apps_st/comn] :
Target System Instance
Home Directory [/u01/CLONE/inst] :
Target System Root
Service [enabled] :
Target System Web
Entry Point Services [enabled] :
Target System Web
Application Services [enabled] :
Target System Batch
Processing Services [enabled] :
Target System Other
Services [disabled] :
Do you want to
preserve the Display [RUH-ERPAP01:0.0] (y/n)
: y
Do you want the the
target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port
Pool [0-99] : 10
Checking the port pool
10
done: Port Pool 10 is
free
Report file located at
/u01/CLONE/inst/apps/CLONE_clone/admin/out/portpool.lst
Complete port
information available at
/u01/CLONE/inst/apps/CLONE_clone/admin/out/portpool.lst
UTL_FILE_DIR on
database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3.
/u01/CLONE/db/tech_st/11.1.0/appsutil/outbound/CLONE_clone
4. /usr/tmp
Choose a value which
will be set as APPLPTMP value on the target node [1] :
Creating the new
APPL_TOP Context file from :
/u01/CLONE/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP
context file has been created :
/u01/CLONE/inst/apps/CLONE_clone/appl/admin/CLONE_clone.xml
Log file located at
/u01/CLONE/apps/apps_st/comn/clone/bin/CloneContext_0815144835.log
Check Clone Context
logfile /u01/CLONE/apps/apps_st/comn/clone/bin/CloneContext_0815144835.log for
details.
Running Rapid Clone
with command:
perl
/u01/CLONE/apps/apps_st/comn/clone/bin/adclone.pl
java=/u01/CLONE/apps/apps_st/comn/clone/bin/../jre mode=apply
stage=/u01/CLONE/apps/apps_st/comn/clone component=appsTier method=CUSTOM
appctxtg=/u01/CLONE/inst/apps/CLONE_clone/appl/admin/CLONE_clone.xml
showProgress contextValidated=true
Running:
perl
/u01/CLONE/apps/apps_st/comn/clone/bin/adclone.pl
java=/u01/CLONE/apps/apps_st/comn/clone/bin/../jre mode=apply
stage=/u01/CLONE/apps/apps_st/comn/clone component=appsTier method=CUSTOM
appctxtg=/u01/CLONE/inst/apps/CLONE_clone/appl/admin/CLONE_clone.xml
showProgress contextValidated=true
APPS Password :
Beginning application
tier Apply - Tue Aug 15 14:49:25 2017
/u01/CLONE/apps/apps_st/comn/clone/bin/../jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=true
-Doracle.installer.oui_loc=/oui -classpath
/u01/CLONE/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/CLONE/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/u01/CLONE/apps/apps_st/comn/clone/jlib/java:/u01/CLONE/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u01/CLONE/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u01/CLONE/apps/apps_st/comn/clone/jlib/oui/share.jar:/u01/CLONE/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/u01/CLONE/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e
/u01/CLONE/inst/apps/CLONE_clone/appl/admin/CLONE_clone.xml -stage
/u01/CLONE/apps/apps_st/comn/clone
-showProgress
APPS Password : Log
file located at
/u01/CLONE/inst/apps/CLONE_clone/admin/log/ApplyAppsTier_08151449.log
/
73% completed
Completed Apply...
Tue Aug 15 14:57:02
2017
Do you want to startup
the Application Services for CLONE? (y/n) [y] : press enter here
Starting application
Services for CLONE:
Running:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adstrtal.sh
-nopromptmsg
You are running
adstrtal.sh version 120.15.12010000.3
The logfile for this
session is located at
/u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adstrtal.log
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adopmnctl.sh
start
script returned:
****************************************************
You are running
adopmnctl.sh version 120.6.12010000.4
Starting Oracle
Process Manager (OPMN) ...
opmnctl: opmn started.
adopmnctl.sh: exiting
with status 0
adopmnctl.sh: check
the logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adopmnctl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adalnctl.sh
start
script returned:
****************************************************
adalnctl.sh version
120.3
Checking for FNDFS
executable.
Starting listener
process APPS_CLONE.
adalnctl.sh: exiting
with status 0
adalnctl.sh: check the
logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adalnctl.txt for
more information ...
.end std out.
.end err out.
****************************************************
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adapcctl.sh
start
script returned:
****************************************************
You are running
adapcctl.sh version 120.7.12010000.2
Starting OPMN managed
Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is
already running.
opmnctl: starting opmn
managed processes...
================================================================================
opmn
id=clone.dell.com:6210
0 of 1 processes started.
ias-instance
id=CLONE_clone.clone.dell.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server/
Error
--> Process
(index=1,uid=1638094525,pid=22289)
failed to start a managed process after the
maximum retry limit
Log:
/u01/CLONE/inst/apps/CLONE_clone/logs/ora/10.1.3/opmn/HTTP_Server~1.log
adapcctl.sh: exiting
with status 0
adapcctl.sh: check the
logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adapcctl.txt for
more information ...
.end std out.
.end err out.
****************************************************
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adoacorectl.sh
start
script returned:
****************************************************
You are running
adoacorectl.sh version 120.13
Starting OPMN managed
OACORE OC4J instance ...
adoacorectl.sh:
exiting with status 0
adoacorectl.sh: check
the logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adoacorectl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adformsctl.sh
start
script returned:
****************************************************
You are running
adformsctl.sh version 120.16.12010000.3
Starting OPMN managed
FORMS OC4J instance ...
Calling
txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...
Program :
/u01/CLONE/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl
started @ Tue Aug 15 14:57:38 2017
*** Log File =
/u01/CLONE/inst/apps/CLONE_clone/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Aug_15_14_57_38_2017/txkChkFormsDeployment_Tue_Aug_15_14_57_38_2017.log
File
"/u01/CLONE/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar"
exists. Proceeding to check the size...
=============================================
*** Latest
formsapp.ear has been deployed ***
=============================================
Program :
/u01/CLONE/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl
completed @ Tue Aug 15 14:57:39 2017
Perl script
txkChkFormsDeployment.pl got executed successfully
adformsctl.sh: exiting
with status 0
adformsctl.sh: check
the logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adformsctl.txt
for more information ...
.end std out.
*** ALL THE FOLLOWING
FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File =
/u01/CLONE/inst/apps/CLONE_clone/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Aug_15_14_57_38_2017/txkChkFormsDeployment_Tue_Aug_15_14_57_38_2017.log
.end err out.
****************************************************
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adoafmctl.sh
start
script returned:
****************************************************
You are running
adoafmctl.sh version 120.8
Starting OPMN managed
OAFM OC4J instance ...
adoafmctl.sh: exiting
with status 0
adoafmctl.sh: check
the logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adoafmctl.txt
for more information ...
.end std out.
.end err out.
****************************************************
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/adcmctl.sh
start
script returned:
****************************************************
You are running
adcmctl.sh version 120.17.12010000.5
Starting concurrent
manager for CLONE ...
Starting
CLONE_0815@CLONE Internal Concurrent Manager
Default printer is
noprint
adcmctl.sh: exiting
with status 0
adcmctl.sh: check the
logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adcmctl.txt for
more information ...
.end std out.
.end err out.
****************************************************
Executing service
control script:
/u01/CLONE/inst/apps/CLONE_clone/admin/scripts/jtffmctl.sh
start
script returned:
****************************************************
You are running
jtffmctl.sh version 120.3
Validating Fulfillment
patch level via /u01/CLONE/apps/apps_st/comn/java/classes
Fulfillment patch
level validated.
Starting Fulfillment
Server for CLONE on port 9310 ...
jtffmctl.sh: exiting
with status 0
.end std out.
.end err out.
****************************************************
All enabled services
for this node are started.
adstrtal.sh: Exiting
with status 0
adstrtal.sh: check the
logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adstrtal.log for
more information ...
[oraclone@clone bin]$
[oraclone@clone bin]$ .
/u01/CLONE/apps/apps_st/appl/APPSCLONE_clone.env
[oraclone@clone bin]$ adopmnctl.sh
status
You are running
adopmnctl.sh version 120.6.12010000.4
Checking status of
OPMN managed processes...
Processes in Instance:
CLONE_clone.clone.dell.com
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm |
32076 | Alive
OC4JGroup:default_group | OC4J:forms |
32005 | Alive
OC4JGroup:default_group | OC4J:oacore |
31858 | Alive
HTTP_Server | HTTP_Server |
729 | Alive
adopmnctl.sh: exiting
with status 0
adopmnctl.sh: check
the logfile /u01/CLONE/inst/apps/CLONE_clone/logs/appl/admin/log/adopmnctl.txt
for more information ...
[oraclone@clone bin]$
execute FND_CONC script
[oraclone@clone ~]$
[oraclone@clone ~]$ . /u01/CLONE/apps/apps_st/appl/APPSCLONE_clone.env
[oraclone@clone ~]$ sqlplus apps/apps
[oraclone@clone ~]$ . /u01/CLONE/apps/apps_st/appl/APPSCLONE_clone.env
[oraclone@clone ~]$ sqlplus apps/apps
SQL*Plus: Release
10.1.0.5.0 - Production on Wed Aug 16 09:58:41 2017
Copyright (c) 1982,
2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL>
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.3
SQL>
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.3
SQL>
SQL> select
NODE_NAME from fnd_nodes;
NODE_NAME
------------------------------
AUTHENTICATION
CLONE
RUH-ERPAP01
RUH-ERPDB01
SQL> EXEC
FND_CONC_CLONE.SETUP_CLEAN;
PL/SQL procedure
successfully completed.
SQL> select
NODE_NAME from fnd_nodes;
no rows selected
SQL> commit;
Commit complete.
SQL> exit
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
Run autoconfig first on DATABASE-SERVER and then on APPS-SERVER
Run autoconfig on DatabaseTier
[root@clone ~]#
[root@clone ~]# su - oraclone
[oraclone@clone ~]$[root@clone ~]# su - oraclone
[oraclone@clone ~]$ . /u01/CLONE/db/tech_st/11.1.0/CLONE_clone.env
[oraclone@clone ~]$
[oraclone@clone ~]$ cd
$ORACLE_HOME/appsutil/scripts/CLONE_clone
[oraclone@clone
CLONE_clone]$
[oraclone@clone
CLONE_clone]$ adautocfg.sh
Enter the APPS user
password:
The log file for this
session is located at:
/u01/CLONE/db/tech_st/11.1.0/appsutil/log/CLONE_clone/08151512/adconfig.log
AutoConfig is
configuring the Database environment...
AutoConfig will
consider the custom templates if present.
Using ORACLE_HOME location :
/u01/CLONE/db/tech_st/11.1.0
Classpath :
:/u01/CLONE/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/u01/CLONE/db/tech_st/11.1.0/appsutil/java:/u01/CLONE/db/tech_st/11.1.0/jlib/netcfg.jar:/u01/CLONE/db/tech_st/11.1.0/jlib/ldapjclnt11.jar
Using Context file :
/u01/CLONE/db/tech_st/11.1.0/appsutil/CLONE_clone.xml
Context Value
Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and
templates to database...COMPLETED
Updating rdbms version
in Context file to db111
Updating rdbms type in
Context file to 64 bits
Configuring templates
from ORACLE_HOME ...
AutoConfig completed
successfully.
[oraclone@clone
CLONE_clone]$
Run autoconfig on AppsTier
[root@clone ~]#
[root@clone ~]# su - oraclone
[root@clone ~]# su - oraclone
[oraclone@clone ~]$
[oraclone@clone ~]$.
/u01/CLONE/apps/apps_st/appl/APPSCLONE_clone.env
[oraclone@clone ~]$
[oraclone@clone ~]$ adautocfg.sh
Enter the APPS user
password:
The log file for this
session is located at:
/u01/CLONE/inst/apps/CLONE_clone/admin/log/08151515/adconfig.log
AutoConfig is
configuring the Applications environment...
AutoConfig will
consider the custom templates if present.
Using CONFIG_HOME location : /u01/CLONE/inst/apps/CLONE_clone
Classpath :
/u01/CLONE/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/CLONE/apps/apps_st/comn/java/classes
Using Context file :
/u01/CLONE/inst/apps/CLONE_clone/appl/admin/CLONE_clone.xml
Context Value
Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and
templates to database...COMPLETED
Configuring templates
from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed
successfully.
[oraclone@clone ~]$
[oraclone@clone ~]$ sqlplus
apps/apps
SQL*Plus: Release
10.1.0.5.0 - Production on Wed Aug 16 09:58:41 2017
Copyright (c) 1982,
2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL>
NODE_NAME
------------------------------
AUTHENTICATION
CLONE
SQL>
Target System Application dash board:
Complete Post Clone
Steps also includes
- Changing "Apps Password"
- Runnig "cmclean.sql" if required
- Disable archive log mode
- Redusing
Standard Concurrent Manager
- Change SGA size as required (default 1GB will be configured)
- Changing values in "System Profile Values"
1. Java Color
Scheme
2. Site Name
3. Corporate Branding Image for Oracle Applications
- Clear Cache Memory from
"Functional Administrator Responsibility"
Thanks for Reading
Regards,
Mohammed Areefuddin.
Suggested Topics :
Linux
|
DATABASE
|
RMAN
|
RAC
|
EBS
|
EBS DataGuard
| ||||
No comments:
Post a Comment