What is cloning and why is it required?
• Cloning is the process of creating
an identical copy of the Oracle application system.
It is required due to following
reasons
• Creating a test copy of your
production system before upgrading.
• Moving an existing system to a
different machine.
• To test some patches
• Creating a development copy of your
environment to be used by the developers.
What is the location of adpreclone.pl for RDBMS_ORACLE_HOME?
$RDBMS_ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
What is the location of adcfgclone.pl for RDBMS_ORACLE_HOME?
$RDBMS_ORACLE_HOME/appsutil/clone/bin
What is the location of adpreclone.pl for applmgr user?
$COMMON_TOP/admin/scripts/$CONTEXT_AME
What is the location of adcfgclone.pl
for applmgr user?
$COMMON_TOP/clone/bin
How to scrap the target database?
Login to database as sysdba,
1)shutdown database (shutdown immediate)
2) startup restrict mount
3)drop database
SQL> startup restrict mount;
ORACLE instance started.
Total System Global Area 2021117952
bytes
Fixed Size 2229704 bytes
Variable Size 1728055864 bytes
Database Buffers 268435456 bytes
Redo Buffers 22396928 bytes
Database mounted.
SQL> select name from v$database;
NAME
---------
EBSTEST1
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g
Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real
Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application
Testing options
SQL>
What are the scripts do you use while
Apps cloning?
• adpreclone.pl prepares the source
system and adcfgclone.pl configures the target system.
• adpreclone.pl is located in
$COMMON_TOP/admin/scripts/$CONTEXT_NAME directory and adcfgclone.pl located in
$COMMON_TOP/clone/bin.
• Adpreclone.pl collects information
about the database.
• It also creates generic templates
of files containing source specified hardcore values.
How often Do you clone?
Cloning happens biweekly or monthly depending on the organization requirement.
How do we find adpreclone is run in source or not ?
If clone directory exists under $RDBMS_ORACLE_HOME/appsutil for oracle user and $COMMON_TOP/clone for applmgr user.
When do you run adpreclone on
Production?
If any changes made to either
TechStack,database or any patches applied.
When we run perl adpreclone.pl dbTier
why it requires apps password?
It requires a database connection to
validate apps schema.
When we run perl adpreclone.pl appTier
why it will not prompt for apps password?
It doesn’t require db a connection.
What happens after running
adcfgclone.pl?
It will take inputs and creates xml
file.
after creating xml file,it runs
autoconfig.
It registers the ORALCE_HOME with
GLOBAL INVENTORY.
What adpreclone.pl does on appsTier?
Adpreclone.pl
?adclone.pl?StageAppsTier.java
?StageApplTop.java
?StageAppsTechStack.java
What adpreclone.pl does on dbTier?
Adpreclone.pl
?adclone.pl?StageDBTier.java
?StageDtabase.java
?StageDBTechStack.java
When you moved oracle binary files from
one ORACLE_HOME server to another server then which oracle utility will be used
to make this new ORACLE_HOME usable?
Relink all.
what Perl adcfgclone.pl dbTechStack
do?
Perl adcfgclone.pl dbTechStack will
do below things.
1)Create context file
2)Register ORACLE_HOME
3)Relink ORACLE_HOME
4)Configure ORACLE_HOME
5)Start SQL*NET listener
what Perl adcfgclone.pl dbTier do?
1)Create context file
2)Register ORACLE_HOME
3)Relink ORACLE_HOME
4)Configure ORACLE_HOME
5)Recreate controlfile
6)Configure database
7)Start SQL*NET listener
what Perl adcfgclone.pl appsTier do?
perl adcfgclone.pl appsTier will do
below things.
1)Create context file
2)Register ORACLE_HOME
3)Relink ORACLE_HOME
4)Configure ORACLE_HOME
5)Create INST_TOP
6)Configure APPL_TOP
7)Start Apps Processses
How to register a node as Concurrent
manager ?
SQL> @afcpnode_ctssd11.sql
Enter value for 1: apps
Enter value for 2: apps#man
Enter value for 3: ebstest1
Connected.
Register a node ...
11 args...
Registered Node - erptest1 - as Concurrent Manager recognizable node
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
11 args...
Registered Node - erptest1 - as Concurrent Manager recognizable node
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
When we run adcfgclone.pl which script it
will call?
It will call adclone.pl which is
located at $AD_TOP/bin .
To use RMAN DUPLICATE what parameters
are mandatory in 11g?
*.db_file_name_convert='/ebsoltp1/oradata/dbdata/data1','/ebstest1/oradata/dbdata/data1','/ebsoltp1/dbdata/temp','/ebstest1/dbdata/temp'
*.log_file_name_convert='/ebsoltp1/oradata/dbdata/redo1','/ebstest1/oradata/dbdata/redo1','/ebsoltp1/dbdata/redo2','/ebstest1/dbdata/redo2'
*.diagnostic_dest='/ebstest1/oracle/11.2.0/admin/ebstest1_ebstest1'
*.event='10298 trace name context
forever, level 32'
+++++++++++++++++++++
++++++++++++++++++++
What is rman duplicate?
rman log
/ebstest1/oracle/recovery.log
==>By default rman writes output
to screen but we are sending the output to log file.
connect target sys/*****@ebsoltp1
==> connect to production database
connect catalog
cataloguser/cataloguser@catalogdb
==>Connect to catalog database.
connect auxiliary /
Connect to target database.
run {
ALLOCATE auxiliary CHANNEL ch00 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch01 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch02 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch03 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch04 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch05 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch06 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch07 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch08 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch09 TYPE
DISK;
ALLOCATE auxiliary CHANNEL ch10 TYPE
DISK;
set until time '30-DEC-2012
23:35:00';
duplicate target database to
ebstest1;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
RELEASE CHANNEL ch04;
RELEASE CHANNEL ch05;
RELEASE CHANNEL ch06;
RELEASE CHANNEL ch07;
RELEASE CHANNEL ch08;
RELEASE CHANNEL ch09;
RELEASE CHANNEL ch10;
}
When do we run
FND_CONC_CLONE.SETUP_CLEAN?
Does clone preserve the patch history?
• Yes, Rapid clone preserves the
patch history in following locations
• RDBMS ORACLE_HOME: preserves the
OUI oraInventory.
• iAS ORACLE_HOME: preserves the OUI
oraInventory
• 806 ORACLE_HOME: preserves the
patch level and Oracle inventory
• APPL_TOP and Database: preserves
the patch level and history tables.
Quote of the day
===========
First they ignore you, then they laugh
at you, then they fight you, then you win
No comments:
Post a Comment