standby2.html
09-13-2001 Bikle
-----------------

This page provides a demonstration of transforming a recently
"activated" standby database, named BBIKLE, into a primary database
and then constructing another standby database named CBIKLE.

Summary:

-Take inventory of BBIKLE
-Obtain host and disk space for CBIKLE
-Configure BBIKLE
-Install CBIKLE software
-Configure CBIKLE software
-Copy BBIKLE data files to CBIKLE location
-Start CBIKLE
-Test manual recovery
-Test managed recovery mode
-Open Read-Only mode
-Create new BBIKLE tablespace named BIKLE
-Add datafile to BIKLE tablespace

Details:

-Take inventory of BBIKLE

inventoryBBIKLE.html

-Obtain host and disk space for CBIKLE

host:          sf49er.bikle.com
disk location: /u2/oracle/data/CBIKLE/ (12GB free)


-Configure BBIKLE

ConfigBBIKLE.html

-Install CBIKLE software

To install the CBIKLE software we simply copied the BBIKLE software to
/u2/oracle/CBIKLE/ and then pushed the resulting tree through a
grep-perl filter:

insCBIKLE.html

-Configure CBIKLE software

We jumped the gun on this step; much of the CBIKLE software
configuration was done in the previous step.  One last thing we did to
configure the CBIKLE software was to create the CBIKLE control file.
A screen dump of us completing that step is displayed below:

crCBIKLEctl.txt

-Copy BBIKLE data files to CBIKLE location

A screen dump of us copying the BBIKLE data files to CBIKLE location is displayed below:

cpB2C.txt

-Start CBIKLE

startCBIKLE.txt

-Test manual recovery

tstManRecovery.txt

-Test managed recovery mode

tstMgdRec.txt

-Open Read-Only mode

tstReadOnly.txt

-Create new BBIKLE tablespace named BIKLE

newBBIKLEts.txt

-Add datafile to BIKLE tablespace

addDbf2bikle.html