Bikle.com

Ajax Demo:

Plain HTML
(no Ajax here):

of URLs:

mgdRcvryMde.html 09-07-2001 Bikle ----------------- A Demonstration of Oracle 8i Managed Recovery Mode This page demonstrates a few ideas and techniques related to setting up a standby database. Also we will demonstrate some methods for moving the standby database through a variety of states: Manual Recovery Mode, Managed Recovery Mode, Open Read-Only Mode, and finally, Fail Over Mode. All of these topics are discussed in the following Oracle document: Oracle8i Standby Database Concepts and Administration Release 2 (8.1.6) Part Number A76995-01 A search of http://google.com Will reveal the following links to the above document as copies of it reside in various locations across the internet: http://www.cs.rose-hulman.edu/docs/oracle-817/server.817/a76995/index.htm Another page which discusses Oracle8i Standby Database Concepts and Administration is listed below: http://www.arsdigita.com/asj/oracle-fault-tolerance/ We are now in a position to demonstrate the setup of an actual standby database. A summary of the steps we take to setup the standby database is listed below: -Take inventory of primary database -Obtain host and disk space for standby database -Configure primary database -Install standby database software -Configure standby database software -Copy primary data to standby database -Start standby database -Test manual recovery -Managed Recovery mode -Open Read-Only mode -Additional topics Details associated with the above steps are listed below: -Take inventory of primary database host: sf49er.bikle.com oracle_home: /u2/oracle/ABIKLE (this is a soft link pointing to /u2/oracle/817/) oracle_sid: ABIKLE dbf files: ABIKLEdbf.txt control files: /u2/oracle/data/ABIKLE/control01.ctl service name: ABIKLE.BIKLE.NET init.ora: initABIKLE.ora listener.ora: listener.ora tnsnames.ora: tnsnames.ora -Obtain host and disk space for standby database host: sf49er.bikle.com disk location: /u2/oracle/data/BBIKLE/ (20gb free) -Configure primary database editPrimDb.txt The initABIKLE.ora now looks like this: initABIKLE.ora Now that the init.ora is ready, we put the primary database in ARCHIVELOG mode: archMode.txt -Install standby database software Although we may place both the primary and standby databases on the same host, we found (via the school of hard knocks) that the standby database should have its own software. Often, Oracle customers will configure a host such that a single tree of Oracle software will act as several independent ORACLE_HOMEs through the clever use of UNIX symbolic links. It's probable that both the ABIKLE database and the BBIKLE standby database could share large parts of ORACLE_HOME and that we need to only avoid the sharing of ORACLE_HOME/dbs. Since disk is cheap, however, we decided to give the BBIKLE database its own ORACLE_HOME. For this demo, we make note of the following attributes of the standby database ORACLE_HOME: /u2/oracle/BBIKLE ORACLE_SID: BBIKLE -Configure standby database software init.ora: initBBIKLE.ora -The above file was created with the help of a simple sed filter: cat /u2/oracle/ABIKLE/dbs/initABIKLE.ora|sed '/ABIKLE/s/ABIKLE/BBIKLE/g'>/u2/oracle/BBIKLE/dbs/initBBIKLE.ora And then we edited a few parameters by hand. -In the above file, initBBIKLE.ora, make note of these parameters: -DB_NAME -CONTROL_FILES -STANDBY_ARCHIVE_DEST -DB_FILE_NAME_CONVERT -LOG_FILE_NAME_CONVERT After editing the init.ora, we worked on the files listed below: listener.ora: listener.ora tnsnames.ora: tnsnames.ora -Copy primary data to standby database create and then copy standby control file: crStandbyCtl.txt copy dbf files: cpDbfFiles.txt -Start standby database startStandby.txt -Test manual recovery tstManualRecovery.txt -Managed Recovery Mode mgdRcvryMdeDetails.html -Open Read-Only mode readonly.html -Additional Topics Adding a datafile to the primary database: addDatafile.txt Activation: activation.html Transformation of "activated" standby database into primary database: standby2.html