DataGuard setup using RMAN (lgwr async)
I have prepared a DG configuration steps using the below
table content.
|
Hostname
|
Db/Apps
|
Database Role
|
Database Name
|
|
vmtestebs01.1199nbf.net
10.0.240.94
|
Db Tier
|
Primary
|
Db_name = QUAL2
Db_unique_name = QUAL2
|
|
vmtestebs02.1199nbf.net
10.0.240.95
|
Apps Tier
|
Primary
|
|
|
hkvpebsdb.1199nbf.net
10.100.1.151
|
Db Tier
|
Physical Standby
|
Db_name = QUAL2
Db_unique_name =QUAL2S
|
|
hkvpebsdb.1199nbf.net
10.100.1.150
|
Apps Tier
|
Physical Standby
|
|
1. DG can be setup using 2 backup methods
1.1. cold backup, incurs downtime so we will opt for hot backup
1.2. hot backup using RMAN
2. Add primary and standby hosts in /etc/hosts file, edit them as root
user, these entries will be added to all the four hosts. These entries are mandatory as the log files
will be transferred using these entries.
[oracp@cbnyorc-tst01
~]$ cat /etc/hosts
#
Do not remove the following line, or various programs
#
that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
###
Primary servers
ipaddress vmtestebs01.1199nbf.net
ipaddress vmtestebs02.1199nbf.net
####
DR servers
ipaddress hkvpebsdb.1199nbf.net
ipaddress hkvpebsdb.1199nbf.net
3. archive log mode is mandatory for the primary database to setup data
guard. Check if the primary database is
in the archivelog mode.
SQL>
select log_mode from v$database;
If database is no archivelog mode, we changed to archielog mode
SQL> startup mount;
SQL> alter database archivelog;
4. Check the primary database, if the force logging is not enabled,
enable force logging
SQL>
select force_logging from v$database;
If database is no force logging , we changed to force logging
SQL>
alter database force logging ;
5. on primary database, add standby redo logs. if there are 2 redolog files, on the standby
we need to add 3 standby redo log files.
if you are using lgwr async we
have to configure physical standby redolog file.
SQL> alter database add standby
logfile group
3('/u02/oracle/QUAL/QUAL2/db/apps_st/data/log03a.dbf','/u03/oracle/QUAL/QUAL2/db/apps_st/data/log03b.dbf')
size 1000M ;
SQL> alter alter database add
standby logfile group 4('/u02/oracle/QUAL/QUAL2/db/apps_st/data/log04a.dbf','/u03/oracle/QUAL/QUAL2/db/apps_st/data/log04b.dbf')
size 1000M ;
SQL> alter database add standby
logfile group 5('/u02/oracle/QUAL/QUAL2/db/apps_st/data/log05a.dbf','/u03/oracle/QUAL/QUAL2/db/apps_st/data/log05b.dbf')
size 1000M ;
6. Configure Oracle Net for primary and standby database. Add appropriate entries into tnsnames.ora. use
tnsping to verify the tnsnames.ora settings.
7. Configure data guard parameters.
add initQUAL2.ora data guard parameters in the primary and standby
7.1. add the following initQUAL2.ora parameters on the primary database
environment
7.1.1.
DB_NAME=QUAL2
7.1.2.
DB_UNIQUE_NAME=QUAL2
7.1.3.
LOG_ARCHIVE_CONFIG=DG_CONFIG=(QUAL2,QUAL2S)
7.1.4.
LOG_ARCHIVE_DEST_1=’LOCATION= /u07/oracle/QUAL/QUAL2/db/arch
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=QUAL2’
7.1.5.
LOG_ARCHIVE_DEST_2=’SERVICE=QUAL2S LGWR
ASYNC NOAFFIRM
compression=disable
max_failure=0
max_connections=1
delay=0 reopen=300
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=QUAL2S)
7.1.6.
LOG_FILE_NAME_CONVERT=(
' /u02/oracle/QUAL/QUAL2/db/apps_st/data/’,’/u02/oracle/QUAL/QUAL2/db/apps_st/data',
'/u02/oracle/QUAL/QUAL2/db/apps_st/data/','
/u03/oracle/QUAL/QUAL2/db/apps_st/data')
7.1.7.
DB_FILE_NAME_CONVERT=(
'/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,'/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,'/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,’/u03/oracle/QUAL/QUAL2/db/apps_st/data/’,
’/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,
/u05/oracle/QUAL/QUAL2/db/apps_st/data/’
’/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,
/u06/oracle/QUAL/QUAL2/db/apps_st/data/’)
7.1.8.
STANDBY_FILE_MANAGEMENT=AUTO
7.1.9.
LOG_ARCHIVE_DEST_STATE_1=ENABLE
7.1.10. LOG_ARCHIVE_DEST_STATE_2=ENABLE
7.1.11.
remote_login_passwordfile=EXCLUSIVE
7.1.12.
FAL_SERVER=QUAL2S
7.1.13.
FAL_CLIENT=QUAL2
7.2. login to dbTier take a tar backup of tech_st in database.
The pre-clone script
for database and apps tier are called adpreclone.pl. It lives under the
$ORACLE_HOME/appsutil/scripts/
after the run adpreclone.pl
.backup the tech_st
7.3. login to appsTier and take a backup of inst_top, apps_st and tech_st
shutdown appstier and run the autoconfig on appstier. it lived under the
$ADMIN_SCRIPTS_HOME/adstpall.sh or $INST_TOP/admin/scripts/adstpall.sh
$ADMIN_SCRIPTS_HOME/adstpall.sh or $INST_TOP/admin/scripts/adstpall.sh
7.4. create remote_login_passwordfile will be same for both primary and
standby
orapwd
file=$ORACLE_HOME/dbs/orapwQUAL2S password=notforuse
7.5. move the tech_st tar to standby dbTier node, then untar the tech_st
7.6. Go to $ORACLE_HOME, untar tech_st, then run perl adcfgclone.pl dbTechStack
This command will start
the Oracle instance
[oraqual@hkvpebsdb
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.20.12000000.18
Enter the APPS password :
Running:
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/../jre/bin/java
-Xmx600M -cp
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/java:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/xmlparserv2.jar:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/ojdbc5.jar
oracle.apps.ad.context.CloneContext -e
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/../context/db/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_14674.lst -stage
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone -dbTechStack 2>
/tmp/adcfgclone_14674.err; echo $? > /tmp/adcfgclone_14674.res
Log file located at
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/CloneContext_0807095644.log
Provide the values required for creation of the new Database Context
file.
Target System Hostname (virtual or normal) [hkvpebsdb] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : QUAL2S
Target System Base Directory : /u08/oracle/QUAL/QUAL2
Target System utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP's on the Target System [4] :
Target System DATA_TOP Directory 1
[/u02/oracle/QUAL/QUAL2/db/apps_st/data] :
Target System DATA_TOP Directory 2
[/u03/oracle/QUAL/QUAL2/db/apps_st/data] :
Target System DATA_TOP Directory 3 [/u06/oracle/QUAL/QUAL2/db/apps_st/data]
:
Target System DATA_TOP Directory 4
[/u05/oracle/QUAL/QUAL2/db/apps_st/data] :
Target System RDBMS ORACLE_HOME Directory
[/u08/oracle/QUAL/QUAL2/db/tech_st/11.1.0] :
RC-00215: Warning: File /u08/oracle/QUAL/QUAL2/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv
not found.
Target System RDBMS ORACLE_HOME Directory
[/u08/oracle/QUAL/QUAL2/db/tech_st/11.1.0] :
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3
Do you want to preserve the Display [vmtestebs01:0.0] (y/n) : n
Target System Display [hkvpebsdb:0.0] :
Do you want the the target system to have the same port values as the
source system (y/n) [y] ? :
Complete port information available at
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/out/QUAL2S_hkvpebsdb/portpool.lst
Creating the new Database Context file from :
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/template/adxdbctx.tmp
The new database context file has been created :
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/QUAL2S_hkvpebsdb.xml
Log file located at
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/CloneContext_0807095644.log
Check Clone Context logfile
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/CloneContext_0807095644.log
for details.
Running Rapid Clone with command:
perl
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/adclone.pl
java=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/../jre
mode=apply stage=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone
component=dbTechStack method=CUSTOM
dbctxtg=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/QUAL2S_hkvpebsdb.xml
showProgress contextValidated=true
Running:
perl
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/adclone.pl
java=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/../jre
mode=apply stage=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone
component=dbTechStack method=CUSTOM
dbctxtg=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/QUAL2S_hkvpebsdb.xml
showProgress contextValidated=true
APPS Password :
Beginning rdbms home Apply - Fri Aug
7 09:59:34 2015
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/bin/../jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=true
-Doracle.installer.oui_loc=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/oui
-classpath
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/xmlparserv2.jar:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/ojdbc5.jar:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/java:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/oui/OraInstaller.jar:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/oui/ewt3.jar:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/oui/share.jar:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/oui/srvm.jar:/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTechStack -e
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/QUAL2S_hkvpebsdb.xml -stage
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/clone -showProgress
APPS Password : Log file located at
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/log/QUAL2S_hkvpebsdb/ApplyDBTechStack_08070959.log
| 4% completed
Completed Apply...
Fri Aug 7 10:01:01 2015
Starting database listener for QUAL2S:
Running:
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/scripts/QUAL2S_hkvpebsdb/addlnctl.sh
start QUAL2S
You are running addlnctl.sh version 120.1
Logfile: /u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/log/QUAL2S_hkvpebsdb/addlnctl.txt
Starting listener process QUAL2S ...
addlnctl.sh: exiting with status 0
perl $ORACLE_HOME/appsutil/clone/bin/adcfgclone.pl dbTier
Issue the
following SQL to check the Oracle Instance.
SQL> select instance_name, status from v$instance ;
7.7. You
will see instance_name is 'QUAL2S' and status is 'started'. Add the listener entries into the standby
database environment. use tnsping
command to check if you able to ping both primary and standby database using
net service name.
7.8. add the following parameters in the standby database environment
7.8.1.
DB_NAME=QUAL2
7.8.2.
DB_UNIQUE_NAME=QUAL2S
7.8.3.
LOG_FILE_NAME_CONVERT=(
'/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,’/u02/oracle/QUAL/QUAL2/db/apps_st/data',
'/u03/oracle/QUAL/QUAL2/db/apps_st/data/','
/u02/oracle/QUAL/QUAL2/db/apps_st/data')
7.8.4.
DB_FILE_NAME_CONVERT=( '/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,'/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,'/u03/oracle/QUAL/QUAL2/db/apps_st/data/’,’/u02/oracle/QUAL/QUAL2/db/apps_st/data/’,
’/u05/oracle/QUAL/QUAL2/db/apps_st/data/’,
/u02/oracle/QUAL/QUAL2/db/apps_st/data/’
’/u06/oracle/QUAL/QUAL2/db/apps_st/data/’,
/u02/oracle/QUAL/QUAL2/db/apps_st/data/’)
7.8.5.
FAL_SERVER=QUAL2
7.8.6.
FAL_CLIENT=QUAL2S
7.8.7.
remote_login_passwordfile=EXCLUSIVE
7.8.8.
LOG_ARCHIVE_CONFIG=
DG_CONFIG=(QUAL2,QUAL2S)’
7.8.9.
STANDBY_FILE_MANAGEMENT=AUTO
7.8.10. LOG_ARCHIVE_DEST_1=’LOCATION=/u07/oracle/QUAL/QUAL2/db/arch
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=QUAL2S’
7.8.11.
LOG_ARCHIVE_DEST_2=’SERVICE=QUAL2S
LGWR ASYNC NOAFFIRM
compression=disable
max_failure=0
max_connections=1
delay=0 reopen=300
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=QUAL2
7.8.12. LOG_ARCHIVE_DEST_STATE_1=ENABLE
7.8.13. LOG_ARCHIVE_DEST_STATE_2=ENABLE
8. restart the standby database using 'startup force nomount'
9. connect to RMAN using primary target and standby as auxiliary
database
9.1. login to standby
[oraqual@hkvpebsdb QUAL2S_hkvpebsdb]$ rman
target sys/notforuse@qual2 auxiliary sys/notforuse@qual2S
Recovery Manager: Release 11.2.0.3.0 -
Production on Fri Aug 7 10:23:54 2015
Copyright (c) 1982, 2011, Oracle and/or its
affiliates. All rights reserved.
connected to target database: QUAL2
(DBID=2546051098)
connected to auxiliary database: QUAL2 (not
mounted)
RMAN>
run
{
allocate
channel c1 type disk;
allocate
auxiliary channel sc1 type disk;
duplicate
target database for standby from active database nofilenamecheck;
release
channel c1;
release
channel sc1;
}
RMAN>
run
{
allocate
channel c1 type disk;
allocate
channel c2 type disk;
allocate
channel c3 type disk;
allocate
auxiliary channel sc1 type disk;
allocate
auxiliary channel sc2 type disk;
allocate
auxiliary channel sc3 type disk;
duplicate
target database for standby from active database nofilenamecheck;
release
channel c1;
release
channel c2;
release
channel c3;
release
channel sc1;
release
channel sc2;
release
channel sc3;
}
using
target database control file instead of recovery catalog
allocated
channel: c1
channel
c1: SID=1746 device type=DISK
allocated
channel: sc1
channel
sc1: SID=570 device type=DISK
Starting
Duplicate Db at 26-MAR-15
contents
of Memory Script:
{
backup as copy reuse
targetfile
'/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/dbs/orapwQUAL2' auxiliary
format
'/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/dbs/orapwQUAL2S' ;
}
executing
Memory Script
Starting
backup at 26-MAR-15
Finished
backup at 26-MAR-15
contents
of Memory Script:
{
backup as copy current controlfile for
standby auxiliary format
'/u02/oracle/QUAL/QUAL2/db/apps_st/data/cntrl01.dbf';
restore clone controlfile to '/u03/oracle/QUAL/QUAL2/db/apps_st/data/cntrl02.dbf'
from
'/u02/oracle/QUAL/QUAL2/db/apps_st/data/cntrl01.dbf';
restore clone controlfile to
'/u06/oracle/QUAL/QUAL2/db/apps_st/data/cntrl03.dbf' from
'/u02/oracle/QUAL/QUAL2/db/apps_st/data/cntrl01.dbf';
}
executing
Memory Script
Starting
backup at 26-MAR-15
channel
c1: starting datafile copy
copying
standby control file
output
file name=/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/dbs/snapcf_QUAL2.f
tag=TAG20150326T130414 RECID=2 STAMP=875365455
channel
c1: datafile copy complete, elapsed time: 00:00:03
Finished
backup at 26-MAR-15
Starting
restore at 26-MAR-15
channel
sc1: copied control file copy
Finished
restore at 26-MAR-15
Starting
restore at 26-MAR-15
channel
sc1: copied control file copy
Finished
restore at 26-MAR-15
contents
of Memory Script:
{
sql clone 'alter database mount standby
database';
}
executing
Memory Script
sql
statement: alter database mount standby database
contents
of Memory Script:
{
set newname for tempfile 1 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/temp01.dbf";
set newname for tempfile 2 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/temp02.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system01.dbf";
set newname for datafile 2 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system02.dbf";
set newname for datafile 3 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system03.dbf";
set newname for datafile 4 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system04.dbf";
set newname for datafile 5 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system05.dbf";
set newname for datafile 6 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/ctxd01.dbf";
set newname for datafile 7 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/owad01.dbf";
set newname for datafile 8 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue02.dbf";
set newname for datafile 9 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/odm.dbf";
set newname for datafile 10 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap.dbf";
set newname for datafile 11 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux01.dbf";
set newname for datafile 12 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/apps_ts_tools01.dbf";
set newname for datafile 13 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system12.dbf";
set newname for datafile 14 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data04.dbf";
set newname for datafile 15 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind06.dbf";
set newname for datafile 16 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref03.dbf";
set newname for datafile 17 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int02.dbf";
set newname for datafile 18 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux02.dbf";
set newname for datafile 19 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap01.dbf";
set newname for datafile 20 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data05.dbf";
set newname for datafile 21 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data06.dbf";
set newname for datafile 22 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind07.dbf";
set newname for datafile 23 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind08.dbf";
set newname for datafile 24 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxnbf01.dbf";
set newname for datafile 25 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_data01.dbf";
set newname for datafile 26 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_idx01.dbf";
set newname for datafile 27 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media02.dbf";
set newname for datafile 28 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media03.dbf";
set newname for datafile 29 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media04.dbf";
set newname for datafile 30 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media05.dbf";
set newname for datafile 31 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media06.dbf";
set newname for datafile 32 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media07.dbf";
set newname for datafile 33 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media08.dbf";
set newname for datafile 34 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media09.dbf";
set newname for datafile 35 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media10.dbf";
set newname for datafile 36 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media11.dbf";
set newname for datafile 37 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media12.dbf";
set newname for datafile 38 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media13.dbf";
set newname for datafile 39 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media14.dbf";
set newname for datafile 40 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media15.dbf";
set newname for datafile 41 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media16.dbf";
set newname for datafile 42 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media17.dbf";
set newname for datafile 43 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media18.dbf";
set newname for datafile 44 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data07.dbf";
set newname for datafile 45 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media19.dbf";
set newname for datafile 46 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux03.dbf";
set newname for datafile 47 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data08.dbf";
set newname for datafile 48 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media20.dbf";
set newname for datafile 49 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media21.dbf";
set newname for datafile 50 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data09.dbf";
set newname for datafile 51 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo02.dbf";
set newname for datafile 52 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo03.dbf";
set newname for datafile 53 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media22.dbf";
set newname for datafile 54 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data10.dbf";
set newname for datafile 55 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media23.dbf";
set newname for datafile 56 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data11.dbf";
set newname for datafile 57 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media24.dbf";
set newname for datafile 58 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind09.dbf";
set newname for datafile 59 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data12.dbf";
set newname for datafile 60 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_media25.dbf";
set newname for datafile 61 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data13.dbf";
set newname for datafile 62 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media26.dbf";
set newname for datafile 63 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media27.dbf";
set newname for datafile 64 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data14.dbf";
set newname for datafile 65 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data15.dbf";
set newname for datafile 66 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux04.dbf";
set newname for datafile 67 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data16.dbf";
set newname for datafile 288 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system10.dbf";
set newname for datafile 295 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system06.dbf";
set newname for datafile 314 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/portal01.dbf";
set newname for datafile 351 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system07.dbf";
set newname for datafile 352 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system09.dbf";
set newname for datafile 353 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system08.dbf";
set newname for datafile 354 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system11.dbf";
set newname for datafile 379 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo01.dbf";
set newname for datafile 392 to
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data01.dbf";
set newname for datafile 393 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind01.dbf";
set newname for datafile 394 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref01.dbf";
set newname for datafile 395 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int01.dbf";
set newname for datafile 396 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_summ01.dbf";
set newname for datafile 397 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_nolog01.dbf";
set newname for datafile 398 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_archive01.dbf";
set newname for datafile 399 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue01.dbf";
set newname for datafile 400 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media01.dbf";
set newname for datafile 401 to
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data02.dbf";
set newname for datafile 402 to
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data03.dbf";
set newname for datafile 403 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind02.dbf";
set newname for datafile 404 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind03.dbf";
set newname for datafile 405 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind04.dbf";
set newname for datafile 406 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind05.dbf";
set newname for datafile 407 to
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref02.dbf";
backup as copy reuse
datafile
1 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system01.dbf" datafile
2 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system02.dbf" datafile
3 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system03.dbf" datafile
4 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system04.dbf" datafile
5 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system05.dbf" datafile
6 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/ctxd01.dbf" datafile
7 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/owad01.dbf" datafile
8 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue02.dbf" datafile
9 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/odm.dbf" datafile
10 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap.dbf" datafile
11 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux01.dbf" datafile
12 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/apps_ts_tools01.dbf" datafile
13 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system12.dbf" datafile
14 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data04.dbf" datafile
15 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind06.dbf" datafile
16 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref03.dbf" datafile
17 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int02.dbf" datafile
18 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux02.dbf" datafile
19 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap01.dbf" datafile
20 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data05.dbf" datafile
21 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data06.dbf" datafile
22 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind07.dbf" datafile
23 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind08.dbf" datafile
24 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxnbf01.dbf" datafile
25 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_data01.dbf" datafile
26 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_idx01.dbf" datafile
27 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media02.dbf" datafile
28 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media03.dbf" datafile
29 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media04.dbf" datafile
30 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media05.dbf" datafile
31 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media06.dbf" datafile
32 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media07.dbf" datafile
33 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media08.dbf" datafile
34 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media09.dbf" datafile
35 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media10.dbf" datafile
36 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media11.dbf" datafile
37 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media12.dbf" datafile
38 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media13.dbf" datafile
39 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media14.dbf" datafile
40 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media15.dbf" datafile
41 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media16.dbf" datafile
42 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media17.dbf" datafile
43 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media18.dbf" datafile
44 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data07.dbf" datafile
45 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media19.dbf" datafile
46 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux03.dbf" datafile
47 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data08.dbf" datafile
48 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media20.dbf" datafile
49 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media21.dbf" datafile
50 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data09.dbf" datafile
51 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo02.dbf" datafile
52 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo03.dbf" datafile
53 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media22.dbf" datafile
54 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data10.dbf" datafile
55 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media23.dbf" datafile
56 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data11.dbf" datafile
57 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media24.dbf" datafile
58 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind09.dbf" datafile
59 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data12.dbf" datafile
60 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_media25.dbf" datafile
61 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data13.dbf" datafile
62 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media26.dbf" datafile
63 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media27.dbf" datafile
64 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data14.dbf" datafile
65 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data15.dbf" datafile
66 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux04.dbf" datafile
67 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data16.dbf" datafile
288 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system10.dbf" datafile
295 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system06.dbf" datafile
314 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/portal01.dbf" datafile
351 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system07.dbf" datafile
352 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system09.dbf" datafile
353 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system08.dbf" datafile
354 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/system11.dbf" datafile
379 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo01.dbf" datafile
392 auxiliary format
"/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data01.dbf" datafile
393 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind01.dbf" datafile
394 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref01.dbf" datafile
395 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int01.dbf" datafile
396 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_summ01.dbf" datafile
397 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_nolog01.dbf" datafile
398 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_archive01.dbf" datafile
399 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue01.dbf" datafile
400 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media01.dbf" datafile
401 auxiliary format
"/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data02.dbf" datafile
402 auxiliary format
"/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data03.dbf" datafile
403 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind02.dbf" datafile
404 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind03.dbf" datafile
405 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind04.dbf" datafile
406 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind05.dbf" datafile
407 auxiliary format
"/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref02.dbf" ;
sql 'alter system archive log current';
}
executing
Memory Script
executing
command: SET NEWNAME
executing
command: SET NEWNAME
renamed
tempfile 1 to /u02/oracle/QUAL/QUAL2/db/apps_st/data/temp01.dbf in control file
renamed
tempfile 2 to /u02/oracle/QUAL/QUAL2/db/apps_st/data/temp02.dbf in control file
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
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
backup at 26-MAR-15
channel
c1: starting datafile copy
input
datafile file number=00400
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media01.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:02:35
channel
c1: starting datafile copy
input
datafile file number=00027
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media02.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media02.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:55
channel
c1: starting datafile copy
input
datafile file number=00028
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media03.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media03.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:55
channel
c1: starting datafile copy
input
datafile file number=00011
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux01.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00029
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media04.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media04.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00018
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux02.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux02.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00030
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media05.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media05.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00031
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media06.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media06.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00032
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media07.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media07.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00033 name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media08.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media08.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00034 name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media09.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media09.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00035 name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media10.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media10.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00036
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media11.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media11.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00037
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media12.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media12.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00038
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media13.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media13.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00039
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media14.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media14.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00040
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media15.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media15.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00041
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media16.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media16.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00042
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media17.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media17.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00043
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media18.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media18.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00379
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00020 name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data05.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data05.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00021 name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data06.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data06.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:25
channel
c1: starting datafile copy
input
datafile file number=00402
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data03.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data03.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:35
channel
c1: starting datafile copy
input
datafile file number=00044
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data07.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data07.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:15
channel
c1: starting datafile copy
input
datafile file number=00014
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data04.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data04.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00045
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media19.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media19.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00046
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux03.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux03.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00047
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data08.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data08.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00048
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media20.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media20.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00049
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media21.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media21.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00050 name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data09.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data09.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00051 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo02.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo02.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00053 name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media22.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media22.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00392
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data01.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00393
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind01.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00403
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind02.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind02.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00054
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data10.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data10.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00055
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media23.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media23.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00056
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data11.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data11.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00057
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media24.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media24.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00059
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data12.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data12.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00060 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_media25.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_media25.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00061 name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data13.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data13.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00062
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media26.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media26.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00063
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media27.dbf
output
file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media27.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00064
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data14.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data14.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00065
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data15.dbf
output
file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data15.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00401
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data02.dbf
output
file name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data02.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:01:05
channel
c1: starting datafile copy
input
datafile file number=00067
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data16.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data16.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:55
channel
c1: starting datafile copy
input
datafile file number=00404
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind03.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind03.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:55
channel
c1: starting datafile copy
input
datafile file number=00398
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_archive01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_archive01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:45
channel
c1: starting datafile copy
input
datafile file number=00024 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxnbf01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxnbf01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:35
channel
c1: starting datafile copy
input
datafile file number=00025 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_data01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_data01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:35
channel
c1: starting datafile copy
input
datafile file number=00052
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo03.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo03.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:35
channel
c1: starting datafile copy
input
datafile file number=00026
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_idx01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_idx01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:26
channel
c1: starting datafile copy
input
datafile file number=00066
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux04.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux04.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:25
channel
c1: starting datafile copy
input
datafile file number=00405
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind04.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind04.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:25
channel
c1: starting datafile copy
input
datafile file number=00058
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind09.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind09.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:25
channel
c1: starting datafile copy
input
datafile file number=00015
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind06.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind06.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00022
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind07.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind07.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00023
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind08.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind08.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00353 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system08.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system08.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00001 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00406
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind05.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind05.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00013
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system12.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system12.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00394
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00407
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref02.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref02.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00396
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_summ01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_summ01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00395
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00006
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/ctxd01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/ctxd01.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00008
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue02.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue02.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00017
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int02.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int02.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00002
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system02.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system02.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00003
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system03.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system03.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00004 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system04.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system04.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00005 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system05.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system05.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00288
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system10.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system10.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00295
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system06.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system06.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00352
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system09.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system09.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00354
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system11.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system11.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:15
channel
c1: starting datafile copy
input
datafile file number=00351
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system07.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system07.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:07
channel
c1: starting datafile copy
input
datafile file number=00012
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/apps_ts_tools01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/apps_ts_tools01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:07
channel
c1: starting datafile copy
input
datafile file number=00399
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:07
channel
c1: starting datafile copy
input
datafile file number=00016
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref03.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref03.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:03
channel
c1: starting datafile copy
input
datafile file number=00314
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/portal01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/portal01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:03
channel
c1: starting datafile copy
input
datafile file number=00397
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_nolog01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_nolog01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:03
channel
c1: starting datafile copy
input
datafile file number=00010 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:01
channel
c1: starting datafile copy
input
datafile file number=00009 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/odm.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/odm.dbf tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:01
channel
c1: starting datafile copy
input
datafile file number=00007 name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/owad01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/owad01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:01
channel
c1: starting datafile copy
input
datafile file number=00019
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap01.dbf
output
file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap01.dbf
tag=TAG20150326T130429
channel
c1: datafile copy complete, elapsed time: 00:00:01
Finished
backup at 26-MAR-15
sql
statement: alter system archive log current
contents
of Memory Script:
{
switch clone datafile all;
}
executing
Memory Script
datafile
1 switched to datafile copy
input
datafile copy RECID=2 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system01.dbf
datafile
2 switched to datafile copy
input
datafile copy RECID=3 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system02.dbf
datafile
3 switched to datafile copy
input
datafile copy RECID=4 STAMP=875370134 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system03.dbf
datafile
4 switched to datafile copy
input
datafile copy RECID=5 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system04.dbf
datafile
5 switched to datafile copy
input
datafile copy RECID=6 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system05.dbf
datafile
6 switched to datafile copy
input
datafile copy RECID=7 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/ctxd01.dbf
datafile
7 switched to datafile copy
input
datafile copy RECID=8 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/owad01.dbf
datafile
8 switched to datafile copy
input
datafile copy RECID=9 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue02.dbf
datafile
9 switched to datafile copy
input
datafile copy RECID=10 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/odm.dbf
datafile
10 switched to datafile copy
input
datafile copy RECID=11 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap.dbf
datafile
11 switched to datafile copy
input
datafile copy RECID=12 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux01.dbf
datafile
12 switched to datafile copy
input
datafile copy RECID=13 STAMP=875370134 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/apps_ts_tools01.dbf
datafile
13 switched to datafile copy
input
datafile copy RECID=14 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system12.dbf
datafile
14 switched to datafile copy
input
datafile copy RECID=15 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data04.dbf
datafile
15 switched to datafile copy
input
datafile copy RECID=16 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind06.dbf
datafile
16 switched to datafile copy
input
datafile copy RECID=17 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref03.dbf
datafile
17 switched to datafile copy
input
datafile copy RECID=18 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int02.dbf
datafile
18 switched to datafile copy
input
datafile copy RECID=19 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/sysaux02.dbf
datafile
19 switched to datafile copy
input
datafile copy RECID=20 STAMP=875370134 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/olap01.dbf
datafile
20 switched to datafile copy
input
datafile copy RECID=21 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data05.dbf
datafile
21 switched to datafile copy
input
datafile copy RECID=22 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data06.dbf
datafile
22 switched to datafile copy
input
datafile copy RECID=23 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind07.dbf
datafile
23 switched to datafile copy
input
datafile copy RECID=24 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind08.dbf
datafile
24 switched to datafile copy
input
datafile copy RECID=25 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxnbf01.dbf
datafile
25 switched to datafile copy
input
datafile copy RECID=26 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_data01.dbf
datafile
26 switched to datafile copy
input
datafile copy RECID=27 STAMP=875370134 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/xxlaapps_idx01.dbf
datafile
27 switched to datafile copy
input
datafile copy RECID=28 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media02.dbf
datafile
28 switched to datafile copy
input
datafile copy RECID=29 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media03.dbf
datafile
29 switched to datafile copy
input
datafile copy RECID=30 STAMP=875370134 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media04.dbf
datafile
30 switched to datafile copy
input
datafile copy RECID=31 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media05.dbf
datafile
31 switched to datafile copy
input
datafile copy RECID=32 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media06.dbf
datafile
32 switched to datafile copy
input
datafile copy RECID=33 STAMP=875370134 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media07.dbf
datafile
33 switched to datafile copy
input
datafile copy RECID=34 STAMP=875370134 file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media08.dbf
datafile
34 switched to datafile copy
input
datafile copy RECID=35 STAMP=875370134 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media09.dbf
datafile
35 switched to datafile copy
input
datafile copy RECID=36 STAMP=875370134 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media10.dbf
datafile
36 switched to datafile copy
input
datafile copy RECID=37 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media11.dbf
datafile
37 switched to datafile copy
input
datafile copy RECID=38 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media12.dbf
datafile
38 switched to datafile copy
input
datafile copy RECID=39 STAMP=875370134 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media13.dbf
datafile
39 switched to datafile copy
input
datafile copy RECID=40 STAMP=875370134 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media14.dbf
datafile
40 switched to datafile copy
input
datafile copy RECID=41 STAMP=875370134 file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media15.dbf
datafile
41 switched to datafile copy
input
datafile copy RECID=42 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media16.dbf
datafile
42 switched to datafile copy
input
datafile copy RECID=43 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media17.dbf
datafile
43 switched to datafile copy
input
datafile copy RECID=44 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media18.dbf
datafile
44 switched to datafile copy
input
datafile copy RECID=45 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data07.dbf
datafile
45 switched to datafile copy
input
datafile copy RECID=46 STAMP=875370134 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_media19.dbf
datafile
46 switched to datafile copy
input
datafile copy RECID=47 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux03.dbf
datafile
47 switched to datafile copy
input
datafile copy RECID=48 STAMP=875370134 file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data08.dbf
datafile
48 switched to datafile copy
input
datafile copy RECID=49 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media20.dbf
datafile
49 switched to datafile copy
input
datafile copy RECID=50 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media21.dbf
datafile
50 switched to datafile copy
input
datafile copy RECID=51 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data09.dbf
datafile
51 switched to datafile copy
input
datafile copy RECID=52 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo02.dbf
datafile
52 switched to datafile copy
input
datafile copy RECID=53 STAMP=875370134 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo03.dbf
datafile
53 switched to datafile copy
input
datafile copy RECID=54 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media22.dbf
datafile
54 switched to datafile copy
input
datafile copy RECID=55 STAMP=875370134 file name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data10.dbf
datafile
55 switched to datafile copy
input
datafile copy RECID=56 STAMP=875370134 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media23.dbf
datafile
56 switched to datafile copy
input
datafile copy RECID=57 STAMP=875370134 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data11.dbf
datafile
57 switched to datafile copy
input
datafile copy RECID=58 STAMP=875370135 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media24.dbf
datafile
58 switched to datafile copy
input
datafile copy RECID=59 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind09.dbf
datafile
59 switched to datafile copy
input
datafile copy RECID=60 STAMP=875370135 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data12.dbf
datafile
60 switched to datafile copy
input
datafile copy RECID=61 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_media25.dbf
datafile
61 switched to datafile copy
input
datafile copy RECID=62 STAMP=875370135 file name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data13.dbf
datafile
62 switched to datafile copy
input
datafile copy RECID=63 STAMP=875370135 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media26.dbf
datafile
63 switched to datafile copy
input
datafile copy RECID=64 STAMP=875370135 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_media27.dbf
datafile
64 switched to datafile copy
input
datafile copy RECID=65 STAMP=875370135 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data14.dbf
datafile
65 switched to datafile copy
input
datafile copy RECID=66 STAMP=875370135 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data15.dbf
datafile
66 switched to datafile copy
input
datafile copy RECID=67 STAMP=875370135 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/sysaux04.dbf
datafile
67 switched to datafile copy
input
datafile copy RECID=68 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data16.dbf
datafile
288 switched to datafile copy
input
datafile copy RECID=69 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system10.dbf
datafile
295 switched to datafile copy
input
datafile copy RECID=70 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system06.dbf
datafile
314 switched to datafile copy
input
datafile copy RECID=71 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/portal01.dbf
datafile
351 switched to datafile copy
input
datafile copy RECID=72 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system07.dbf
datafile
352 switched to datafile copy
input
datafile copy RECID=73 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system09.dbf
datafile
353 switched to datafile copy
input
datafile copy RECID=74 STAMP=875370135 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system08.dbf
datafile
354 switched to datafile copy
input
datafile copy RECID=75 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/system11.dbf
datafile
379 switched to datafile copy
input
datafile copy RECID=76 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/undo01.dbf
datafile
392 switched to datafile copy
input
datafile copy RECID=77 STAMP=875370135 file
name=/u03/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data01.dbf
datafile
393 switched to datafile copy
input
datafile copy RECID=78 STAMP=875370135 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind01.dbf
datafile
394 switched to datafile copy
input
datafile copy RECID=79 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref01.dbf
datafile
395 switched to datafile copy
input
datafile copy RECID=80 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_int01.dbf
datafile
396 switched to datafile copy
input
datafile copy RECID=81 STAMP=875370135 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_summ01.dbf
datafile
397 switched to datafile copy
input
datafile copy RECID=82 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_nolog01.dbf
datafile
398 switched to datafile copy
input
datafile copy RECID=83 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_archive01.dbf
datafile
399 switched to datafile copy
input
datafile copy RECID=84 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_queue01.dbf
datafile
400 switched to datafile copy
input
datafile copy RECID=85 STAMP=875370135 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_media01.dbf
datafile
401 switched to datafile copy
input
datafile copy RECID=86 STAMP=875370135 file
name=/u05/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data02.dbf
datafile
402 switched to datafile copy
input
datafile copy RECID=87 STAMP=875370135 file
name=/u06/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_data03.dbf
datafile
403 switched to datafile copy
input
datafile copy RECID=88 STAMP=875370135 file name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind02.dbf
datafile
404 switched to datafile copy
input
datafile copy RECID=89 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind03.dbf
datafile
405 switched to datafile copy
input
datafile copy RECID=90 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind04.dbf
datafile
406 switched to datafile copy
input
datafile copy RECID=91 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_txn_ind05.dbf
datafile
407 switched to datafile copy
input
datafile copy RECID=92 STAMP=875370135 file
name=/u02/oracle/QUAL/QUAL2/db/apps_st/data/a_ref02.dbf
Finished
Duplicate Db at 26-MAR-15
released
channel: c1
released
channel: sc1
10. After RMAN step is complete, the standby database will be in the
mount standby database. This can be
verified using the SQL pasted below :
SQL>
select instance_name, status, database_role from v$instance
You will see
instance_name is 'QUAL2S', status is 'mount' and database_role is 'physical
standby'
11. Check redo transport service, verify if the redologs are being
transferred successfully from primary to standby database host.
SQL>
select name, archived from v$archived_log ;
12. start MRP process on the standby database
SQL>
alter database recover managed standby database disconnect from session
13. check if the archived log files are being applied on the standby
database
SQL>
select name, archived, applied from v$archived_log
14. cancel MRP process on the standby database, to verify if the standby
database can be opened in the readonly mode.
if we can open the database in readonly mode, both primary and standy
are in sync
SQL>
alter database recover managed standby cancel ;
15. execute below SQL to open the
standby database in the readonly mode
SQL>
alter database open readonly ;
16. since 11gR1 the new feature active standby database will be in open
mode, now start the MRP process
SQL>
alter database recover managed standby database disconnect from session ;
17. login to standby host appsTier, copy the primary appsTier tar backup
and untar, go to $COMMON_TOP/clone/bin,
perl
$COMMON_TOP/clone/bin/adclonectx.pl
<INST_TOP>/appl/admin/<PRIMARY_CONTEXT>.xml
[oraqual@hkvpebsapp
bin]$ perl adclonectx.pl
/u01/oracle/QUAL/QUAL2/inst/apps/QUAL2_vmtestebs02/appl/admin/QUAL2_vmtestebs02.xml
Copyright (c) 2002 Oracle
Corporation
Redwood Shores,
California, USA
Oracle Applications
Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath
/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/../jlib/java
oracle.apps.ad.context.CloneContext -e
/u01/oracle/QUAL/QUAL2/inst/apps/QUAL2_vmtestebs02/appl/admin/QUAL2_vmtestebs02.xml
Enter the
APPS password : nottouse
Log file located at
/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/CloneContext_0909131932.log
Provide the values required for creation of
the new APPL_TOP Context file.
Target System Hostname (virtual or normal)
[hkvpebsapp] :
It is recommended that your inputs are
validated by the program.
However you might choose not to validate them
under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not
available.
Do you want the inputs to be validated (y/n)
[n] ? : Y
Target System Database SID : QUAL2S
Target System Database Server Node
[hkvpebsapp] : hkvpebsdb
Target System Database Domain Name
[1199nbf.net] :
Target System Base Directory :
/u01/oracle/QUAL/QUAL2
Target System Tools ORACLE_HOME Directory
[/u01/oracle/QUAL/QUAL2/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory
[/u01/oracle/QUAL/QUAL2/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory
[/u01/oracle/QUAL/QUAL2/apps/apps_st/appl] :
Target System COMMON_TOP Directory
[/u01/oracle/QUAL/QUAL2/apps/apps_st/comn] :
Target System Instance Home Directory
[/u01/oracle/QUAL/QUAL2/inst] :
Username for the Applications File System
Owner [oraqual] :
Group for the Applications File System Owner
[oraqual] :
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 [enabled] :
Do you want to preserve the Display
[vmtestebs02:0.0] (y/n) :
Invalid input value. 'y' or 'n' required.
Do you want to preserve the Display
[vmtestebs02:0.0] (y/n) : n
Target System Display [hkvpebsapp:0.0] :
Do you want the the target system to have the
same port values as the source system (y/n) [y] ? :
Complete port information available at /u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/out/QUAL2S_hkvpebsapp/portpool.lst
UTL_FILE_DIR on database tier consists of the
following directories.
1. /usr/tmp
2. /usr/tmp
3.
/u08/oracle/QUAL/QUAL2/db/tech_st/11.2.0.3/appsutil/outbound/QUAL2S_hkvpebsdb
4. /usr/tmp
Choose a value which will be set as APPLPTMP
value on the target node [1] : 1
Creating the new APPL_TOP Context file from :
/u01/oracle/QUAL/QUAL2/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created
:
/u01/oracle/QUAL/QUAL2/inst/apps/QUAL2S_hkvpebsapp/appl/admin/QUAL2S_hkvpebsapp.xml
Log file located at
/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/CloneContext_0909131932.log
contextfile=/u01/oracle/QUAL/QUAL2/inst/apps/QUAL2S_hkvpebsapp/appl/admin/QUAL2S_hkvpebsapp.xml
Check Clone Context logfile
/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/CloneContext_0909131932.log
for details.
if the above step completed successfully, now
go to $APPL_TOP/ad/12.0.0/bin, run perl adconfig.pl contextfile= /u01/oracle/QUAL/QUAL2/inst/apps/QUAL2S_hkvpebsapp/appl/admin/QUAL2S_hkvpebsapp.xml
run=INSTE8
Enter the
APPS user password:
Script execution phase specified: INSTE8
The log file
for this session is located at: /u01/oracle/QUAL/QUAL2/inst/apps/QUAL2S_hkvpebsapp/admin/log/03271244/adconfig.log
AutoConfig
is configuring the Applications environment...
AutoConfig
will consider the custom templates if present.
Using CONFIG_HOME location : /u01/oracle/QUAL/QUAL2/inst/apps/QUAL2S_hkvpebsapp
Classpath :
/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/java/classes
Using Context file :
/u01/oracle/QUAL/QUAL2/apps/apps_st/comn/clone/bin/QUAL2S_hkvpebsapp.xml
Context
Value Management will now update the Context file
Updating Context file...COMPLETED
Execution phase specified at run time:
INSTE8
No uploading of Context File and its
templates to database.
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 XXSE_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.
[oraqual@hkvpebsapp
bin]$
18. rsync log and out directories on the primary and standby nodes.
rsync -avz
out/
oraqual@10.100.1.150:/u01/oracle/QUAL/QUAL2/inst/apps/QUAL2S_hkvpebsapp/logs/appl/conc/out
rsync -avz
log/
oraqual@10.100.1.150:/u01/oracle/QUAL/QUAL2/inst/apps/QUAL2S_hkvpebsapp/logs/appl/conc/log
No comments:
Post a Comment