>  Operating System
>  VMWARE
>  Installations - Apps11i
>  R12 Topics
>  Installations - Apps R12
>  Patching
>  Cloning
>  Oracle Apps Upgrades
>  System Administration - R11/R12
>  Advance Features - Oracle Apps R12
>  Want to Become an Apps DBA ?
>  Certification - Apps DBA
>  Apps Performance
>  Oracle Apps DBA Interview Questions
>  Apps Day to Day Queries

Home

Username

Password

Remember Me







Installation
RMAN - Backup & Recovery
Duplicate a Database - RMAN
Replication
Convert DB Character Set
DATAPUMP
Recoveries
Oracle 11g Topics
Oracle 11g DBA course

   Installation

Duplicate Database - RMAN

Source Server - linux1 - AIA (SID)
Target Server - rac1 - CLON (Duplicate database SID)


1> Take the AIA (source) backup using RMAN

rman

connect target

run {
allocate channel d1 type disk maxpiecesize 2047M;
backup format '/u01/oracle/rman_backup/AIA/df_t%t_s%s_p%p' database;
sql 'alter system archive log current';
backup format '/u01/oracle/rman_backup/AIA/al_t%t_s%s_p%p' archivelog all;
backup format '/u01/oracle/rman_backup/AIA/control%U' current controlfile;
delete noprompt archivelog all backed up 2 times to device type disk;
release channel d1;
}


2> Create an Initialization Parameter for the Auxiliary Database

-- connect to source server

sqlplus "/ as sysdba"
create pfile='/d02/oracle/AIA/ORACLE10g/dbs/initCLON.ora' from spfile;

3> Create / Start the Auxiliary Instance

Copy oracle home from source server to target server

cd /u01/rmantest/ORACLE10g
scp -pr oracle@linux1:/d02/oracle/AIA/ .

mkdir -p /u01/oracle/rman_backup/AIA

cd /u01/oracle/rman_backup/AIA
scp -pr oracle@linux1:/u01/oracle/rman_backup/AIA/* .

4> Create Password File for Auxiliary Database
cd $ORACLE_HOME/dbs
orapwd file=orapwCLON password=oracle entries=5

5> Create all needed directories for the duplicate database:

export ORACLE_SID=CLON

sqlplus "/ as sysdba"

startup nomount

6> Ensure Oracle Net Connectivity to Auxiliary Database


-- listener.ora

CLON =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCmanprod))
(ADDRESS= (PROTOCOL= TCP)(Host= rac1.com )(Port= 1521))
)

SID_LIST_BEST =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u01/rmantest/ORACLE10g)
(SID_NAME = CLON)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/rmantest/ORACLE10g)
(PROGRAM = extproc)
)
)

-- tnsnames.ora
CLON =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CLON)
)
)
AIA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = AIA)
)
)


8> Mount or Open the Target Database
export ORACLE_SID=AIA
$ sqlplus "/ as sysdba"
SQL> select status from v$instance;

9> Ensure You Have the Necessary Backups and Archived Redo Log Files

-- To know the time from the rman backup


rem Filename: rmanstat.sql
rem Purpose: List completed RMAN backups for the last 24-hours
rem (use info from Dictionary - Control File Views)
rem Date: 12-Feb-2000
rem Author: Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

tti "RMAN Backups for last 24-hours"

col type format a4
col handle format a35 trunc
col file# format 9999
col duration format a9

select decode(BACKUP_TYPE, 'L', 'ARCH', 'D', 'DB', 'I', 'INC',
'Unknown type='||BACKUP_TYPE) TYPE,
to_char(a.start_time, 'DDMON HH24:MI') start_time,
to_char(a.elapsed_seconds/60, '99.9')||' Min' DURATION,
substr(handle, -35) handle,
nvl(d.file#, l.sequence#) file#, nvl(d.blocks, l.blocks) blocks
from SYS.V_$BACKUP_SET a, SYS.V_$BACKUP_PIECE b,
SYS.V_$BACKUP_DATAFILE d, SYS.V_$BACKUP_REDOLOG l
where a.start_time between sysdate-1 and sysdate
and a.SET_STAMP = b.SET_STAMP
and a.SET_STAMP = d.SET_STAMP(+)
and a.SET_STAMP = l.SET_STAMP(+)
order by start_time, file#
/

10> Duplicate CLON from AIA instance

set -a
LOG_FILE=CLON.log
set +a
(
rman < < EOF
CONNECT TARGET sys/oracle@AIA

CONNECT AUXILIARY sys/oracle



RUN
{
set until time "to_date('OCT 31 2009 02:30:00','Mon DD YYYY HH24:MI:SS')";
SET NEWNAME FOR DATAFILE 1 TO '/u01/rmantest/CLON/data/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/u01/rmantest/CLON/data/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 3 TO '/u01/rmantest/CLON/data/sysaux01.dbf';
SET NEWNAME FOR DATAFILE 4 TO '/u01/rmantest/CLON/data/users01.dbf';
SET NEWNAME FOR DATAFILE 5 TO '/u01/rmantest/CLON/data/example01.dbf';
set newname for tempfile 1 to '/u01/rmantest/CLON/data/temp.dbf';
DUPLICATE TARGET DATABASE TO CLON
LOGFILE
GROUP 1 ('/u01/rmantest/CLON/data/redo1a.log') SIZE 50M reuse,
GROUP 2 ('/u01/rmantest/CLON/data/redo1b.log') SIZE 50M reuse,
GROUP 3 ('/u01/rmantest/CLON/data/redo2a.log') SIZE 50M reuse,
GROUP 4 ('/u01/rmantest/CLON/data/redo2b.log') SIZE 50M reuse;
}
EOF
) > $LOG_FILE 2>&1





Created on 07/16/2008 11:57 PM by akr14feb
Updated on 10/31/2009 10:09 PM by akr14feb
 Printable Version

The comments are owned by the poster. We are not responsible for its content.
DZsdasd
Posted on: 2012-09-04 20:06:20   By: Anonymous
 
A group of organic molecules are called Proteins. Proteins are very coq10 powder essential of all the materials firefly luciferase enzyme that make up all living organisms hirudin. Proteins are chains of amino acids, programmed purchase thrombin by DNA. Proteins are copious in buy enzymes different types and are present in every chrondroitin sulfate single living cell of all organisms metallothionein. The uniqueness of the organisms are alpha-2-macroglobulin Protein found out by protein activity for abl protein instance, eye color, immune system operation ACHE antibody, etc,. Recombinant protein is a protein that beta actin protein whose code is carried by a recombinant Acvr2b DNA. The term recombinant DNA means that ADAMTS-4 two segments of DNA in a plasmid. Plasmids are how to get adiponectin those which generally occur in bacteria ADRB1. Once a recombinant DNA is inserted into AFP protein bacteria, these bacteria will make protein RAGE protein based on this recombinant DNA. This protein agrin protein is known as "Recombinant protein". Now-a-days, the Human Angiotensinogen utilization of bacteria for producing recombinant sahh protein is very advanced. Recombinant DNA (rDNA) AKT2 protein molecules are DNA sequences that is human a consequence of molecular cloning (used to yeast aldehyde dehydrogenase assemble recombinant DNA molecules) to assemble leucyl aminopeptidase the genetic material from various sources, ampk making sequences that cannot be predicted ampk protein in biological organisms. This technique α amylase+ is often used to produce human growth hormone ang 1 and insulin. Occasionally, Recombinant DNA ANGPTL6 molecules are known as “chimeric DNA”, as annexin i they are made of material from two species.The annexin A2 antibody method of recombinant DNA was initially annexin v protein planned by a graduate student, Peter Lobban, along serum amyloid P-component with a biochemist, A. Dale Kaiser at apo ai the Stanford University. During then years,1972–74, the APOC2 method was then acknowledged by Stanley apoe peptide Norman Cohen, an American geneticist soluble app Chang, Herbert Boyer, a addressee of the 1990 androgen receptor protein National Medal of Science. In arginase 1973, they published their predictions in ATG16L1 antibody journal "Enzymatic end-to-end joining of atg5 protein DNA molecules" which explained the methods to AXL protein separate and intensify genes or DNA segments beta2 microglobulin and introduce them into an additional beta secretase 1 cell with accuracy. In 1977, an batroxobin advance in the field of recombinant Recombinant Bax DNA technology took place when Herbert human Butyrylcholinesterase Boyer created the biosynthetic "human" bcl 2 protein insulin, a group of biosynthetic human insulin BCL6 Protein products.The DNA sequences that are buy bdnf utilized in the recombinant DNA molecules building bhmt can initiate from any species. For bilberry instance, plant DNA may be combined to rhbmp2 bacterial DNA, or human DNA may be bmp 4 associated with fungal DNA. Also, DNA bone morphogenetic protein 7 sequences that may not transpire bmpr1a anywhere in environment may be produced emmprin by the chemical synthesis of DNA, and betacellulin built-in into recombinant molecules. Any DNA bub1 sequence may be created and introduced into complement c2 any of a very wide range of living carbonic anhydrase ii organisms, with the help of artificial calbindin 1 DNA and recombinant DNA method. Recombinant Recombinant Calreticulin proteins are those which is an outcome recombinant caspase 3 of the expression of recombinant DNA recombinant caspase 8 inside living cells. Once the TARC/CCL17 recombinant DNA encoding a protein is mcp 1 set up into a host organism, the creation cyclin d1 protein of recombinant protein is not required.The ccr5 genes that code for the proteins mouse cd14 are put into special vectors, or recombinant cd19 units of DNA. Vectors are selected Human CD33 that will create huge quantities of the CD36 antigen preferred protein. This is known as “over recombinant cd40 expression”. Over expression is performed CD44 antigen in unique host cells. Occasionally, the hosts Cd5l are bacteria or yeast. The hosts CD74 antigen are frequently insect or mammalian cell cdc6 protein lines, in cases where the proteins are recombinant e cadherin from mammals. Various kits are commercially present n cadherin to assist both the cloning of p 16 the gene, and the following recombinant ceacam1 protein fabrication.The other method is Human complement factor H the polymerase chain reaction (a CHK1 protein method in molecular biology to cib1 intensify a single or a clcf1 few copies of a piece of DNA) used CLPP Protein to proceed the replication of any cntf specific DNA sequence selected by cntn1 the scientist.The basic difference between recombinant endostatin the two methods is that molecular collagen type iv cloning incorporates the replication of the cbp protein DNA within a living cell, whereas recombinant crp PCR replicates DNA in the test tube, without crystallin alpha a living cells. DNA replication is the m csf process of making an identical copy of a CSF1R antibody section of duplex (double-stranded) DNA, using gm csf elisa existing DNA. Configuration of recombinant DNA gcsf needs a cloning vector, a DNA molecule that csk protein will replicate inside a living cell CSNK1D. Generally, vectors are a consequent of plasmids ny eso 1 protein or viruses, and stand for fairly ctgf protein small segments of DNA that contain CTHRC1 necessary genetic signals for replication beta catenin protein. The option of vector for molecular sdf 1a cloning relies on the option of cxcl15 host organism, the size of the DNA to CXCL5 antibody be cloned, and the way in which the CYP24A1 foreign DNA is to be expressed cyp2d6 enzyme.Recombinant protein expression is the manufacture cyr61 protein of a protein derived from deoxycytidine kinase recombinant DNA. It is a common recombinant decorin technique in molecular biology and in pharmaceutical L-Dopa decarboxylase production of hormone replacements. The recombinant DECR1 DNA is a specific portion of beta-Defensin 1 a gene designed to express a human beta defensin 2 single product within a host cell, guided Beta-defensin 2 by special chemical factors so desmin protein that the right protein is expressed desert hedgehog protein in large amounts. on’t let false Recombinant DKK1 positives ruin your project. Use the dkk 1 ultimate TetR-Y2H.

[Reply ]

Discount Dallas Cowboys Jerseys
Posted on: 2012-10-05 00:34:50   By: Anonymous
 
You give up a lot of things in life. A lot of it is not a normal, natural life. You're so focused. It's all about me. It's all about my performance. What's the most important thing for me to do right now so I can have peak performance at the most important meet of the year 10 months from now?And that's what you think about constantly. And if it's a holiday and the gym's closed, you can't train. So it's not bad timing on your part. It's just the stupid gym's closed. It's horrible. I hate Thanksgiving because the gym's closed and you can't train. Come on.
Cheap Cleveland Browns Jerseys
Cheap Dallas Cowboys Jerseys
Discount Cincinnati Bengals Jerseys
Discount Cleveland Browns Jerseys
Discount Dallas Cowboys Jerseys

[Reply ]

Sonic Skin Cleansing
Posted on: 2012-10-18 13:21:55   By: Anonymous
 
Clarisonic Sonic Skin Cleansing Systems UK Online:Save 50% off
Healthy skin begins with Clarisonic Sonic Skin Cleansing System
While Cleaner skin is the first step toward healthier skin in any skin care ritual, it is often overlooked. Typical manual cleansing can leave behind dirt and oil trapped in pores. This build-up can damage the appearance and health of your skin and keep your skin care products from working like they should.Used and recommended by spas and dermatologists, Clarisonic Sonic Skin Cleansing Systems use a patented sonic frequency of more than 300 movements per second to gently, yet thoroughly remove 6X more makeup and 2X more dirt and oil than cleansing with your hands alone.Helps reduce oily areas, dry skin patches and blemishes. Helps reduce the appearance of visible pores.
Clarisonic uk
Sonic Skin Cleansing
Skin Cleansing System
Clarisonic Skin Cleansing SystemClarisonic uk
Sonic Skin Cleansing
Skin Cleansing System
Clarisonic Skin Cleansing System

[Reply ]

Vikings Jerseys
Posted on: 2012-10-19 11:42:42   By: Anonymous
 
zlynewyyurl1019 the deep pockets that Randall Cobb Jersey out in their mess and tell them there is a Savior who loves them and wants to rescue them B J Raji Jersey from sin to give them hope for all eternity. The passage then goes on to tell us Greg Jennings Jersey to move them baptize and teach so as to see them grow into fully devoted Christ followers Donald Driver Jersey that will continue to repeat the cycle of making disciples.The challenge comes to each and Nick Perry Jersey every ministry as it sifts through various methodologies and models to fulfill the mandate. The above statement of James Starks Jersey change is so powerful in that it reminds me of the truth that the local church has a Charles Woodson Jersey tendency to hold on to its methods and models long after they have run their course Jermichael Finley Jersey while harming/forgetting/forsaking the very mandate we are called Jordy Nelson Jersey to fulfill.As noted in the statement, it is something well worth every leader praying for daily. We must Clay Matthews Jersey keep a laser focus on the mandate of Christ and while continually evaluating the models and methods we will use to Aaron Rodgers Jersey fulfill it It's been a crazy busy great week! I know that's not the most grammatical Official Packers Jerseys correct statement, but it reflects how I'm feeling this AM. It is now Friday morning Packers Jerseys and I find myself sitting at Panera Bread in Altoona, PA enjoying some Wi-Fi, quiet and good coffee.


[Reply ]

Packers Jerseys
Posted on: 2012-10-20 09:08:10   By: Anonymous
 
AWERZ020121020 2 to his lawyer Packers Jerseys look in the NBA (the oath at Po) Aaron Rodgers Jersey suspended in sign, poaching by less Clay Matthews Jersey fastidious during deron Williams, the Jordy Nelson Jersey pursuit of kobe Bryant with durant at Jermichael Finley Jersey the same time, they are still in the Charles Woodson Jersey expand their reinforcements range from James Starks Jersey Turkey, the news Nick Perry Jersey report, besitkas general manager last Donald Driver Jersey week not just go to Los Angeles to met with kobe Bryant, and kobe Bryant's agent, they Greg Jennings Jersey also take the B J Raji Jersey time to go with the bulls center the Randall Cobb Jersey mill, meet cript:Official Packers Jerseys ism.trans.

[Reply ]

sdfs
Posted on: 2012-10-23 09:18:30   By: Anonymous
 
Rex Grossman Jersey
Roy Helu Jersey
Chris Cooley Jersey
Ryan Kerrigan Jersey
Brian Orakpo Jersey
DeAngelo Hall Jersey
Santana Moss Jersey
London Fletcher Jersey
Anthony Armstrong Jersey
Brandon Banks Jersey
Brandon Meriweather Jersey
Donte Stallworth Jersey
Fred Davis Jersey
Graham Gano Jersey
Jabar Gaffney Jersey
Josh Leribeus Jersey
Josh Morgan Jersey
LaRon Landry Jersey
Leonard Hankerson Jersey


[Reply ]

Ravens Jerseys
Posted on: 2012-10-25 07:26:54   By: Anonymous
 
wymlin1025 which Cardinals Jerseys they Cardinals Kevin Kolb Jersey broke, dropped Larry Fitzgerald Jersey into the Michael Floyd Jersey glasses and fished for with spoons. Their Patrick Peterson Jersey The American Woman Darnell Dockett Jersey coils of knitting, like two snakes, slumbered beside the Official Cardinals Jerseys tray.


[Reply ]

zhu
Posted on: 2012-10-29 08:26:05   By: Anonymous
 
cheap jerseys wholesale

[Reply ]

Air Jordan Son Of Mars
Posted on: 2012-11-07 13:11:47   By: Anonymous
 
The wait is almost over, using the 2011 model in the Jordan Son Of Mars in Black Silver finally hitting shelves this Saturday. jordan 7 raptors This has become a classic colorway because it produced its debut on Jordan 6 Rings feet again in 1990, with each subsequent release getting snapped up pretty swiftly. air jordan 7 raptors The 2011 version stands out through the prior iterations with the blue tint found about the icy sole, Not long ago we mentioned that this fall the http://www.jordan-son-of-mars.com/ would be reappearing to the fourth time. Detailed pics have finally surfaced, Jordan 1 and it seems like the popular clear rubber soles are icey as at any time.

[Reply ]

casque beats pas cher
Posted on: 2012-11-08 06:03:36   By: Anonymous
 
une minute d'attente, la casque beats pas cher main de l'un des médiums a écrit spontanément un sermon sur la résignation et la charité : il est pigné Bourdaloue ; nous le publierons sans doute un autre jour, parmi les Communications détachées. Lorsqu'il a été lu, la main du même médium a repris en ces

[Reply ]

    casque beats by dre
    Posted on: 2012-11-08 06:05:47   By: Anonymous
     
    avantageux, cachet casque beats by dre de l'ignorance Qae ses admirateurs prennent pour de l'esprit. Mais le panvre Jeannot, malgré sa rhétorique, Et ses discours ronflants, et toute sa logique, A perdu son crédit." Le soir du 4 juillet, nous étions seulement huit personnes, «t nous venions de nous asseoir,

    [Reply ]

      sac chanel pas cher
      Posted on: 2012-11-08 11:25:51   By: Anonymous
       
      C'est qu'il sac chanel pas cher fallait un pays libre pour que les manifestations eltramonclaïues pussent fie faire librement, et c'est dans les Etats-Unis que vous avez vu les premières manifestations spiritualistes. Si elles ont été

      [Reply ]

www.newnhljerseyssupply.com
Posted on: 2012-11-14 08:19:56   By: Anonymous
 
Detroit Red Wings
Edmonton Oilers
Florida Panthers
Los Angeles Kings
Minnesota Wild
Montreal Canadiens
Nashville Predators
New Jersey Devils
New York Islanders
New York Rangers
Ottawa Senators
Philadelphia Flyers
Phoenix Coyotes

[Reply ]

Thanks
Posted on: 2014-05-06 12:34:24   By: Anonymous
 
I now definitely getting your information. I must spend some time studying much more or understanding more.
friv 2

[Reply ]

Thanks!
Posted on: 2015-08-31 17:19:25   By: Anonymous
 
Anti-Brucella VHH Single Domain Antibody (Brucella antibody) is a recombinant protein produced in E. coli.

[Reply ]

Nice Information
Posted on: 2017-06-13 06:24:33   By: Anonymous
 
I am very happy to have found such excellent information as what you have presented, this is one of the interesting articles I found today. Maybe I will inform my friend that I have found an article that may be useful for him, because the discussion in this article is the same as what my friends are looking for. Certainly later I will come back again to visit this article and read other articles contained on this website. Thank you very much yes because you have given a very amazing thing good.

Cara Menghilangkan Mual Obat Hipertiroidisme Cara Mengobati Diabetes Kering Cara Mengobati Tipes Cara Mengobati Dermatitis Obat Benjolan Di Ketiak Obat Gagal Jantung Obat Radang Ginjal Cara Mengatasi Gangguan Pencernaan Cara Menghilangkan Bercak Merah Di Tubuh

[Reply ]