Installing Oracle 9i Release 2 on Linux (Cheat Sheet)
Posted at Thursday, October 27, 2005
Here is a step-by-step document that I use to install Oracle 9i Release 2 - specifically 9.2.0.6 - on Linux - specifically Red Hat Enterprise 4.0. The steps in general, however, should apply to most distributions; you will just have to do a little more research if you are using a different distribution.
Installing Oracle 9i Release 2 on Red Hat Enterprise 4.0
Installing Oracle 9i Release 2 on Red Hat Enterprise 4.0
Labels: 9i, Installation
Standby Database Process Flows
Posted at Friday, July 08, 2005
Process Flows for Building 9i Release 2 Physical Standby Database
Process Flows for Building 9i Release 2 Logical Standby Database
Process Flows for Recoverying Standby Database
Process Flows for Building 9i Release 2 Logical Standby Database
Process Flows for Recoverying Standby Database
Labels: 9i, Backup and Recovery, Data Guard, Process Flows
Point-in-Time Duplication - 9i
Posted at Wednesday, June 01, 2005
Every so often, I find myself in a situation in which a user loses data, I need to recover it - from an RMAN tape backup - and only the production host has access to the tape device. In situations such as these, I opt for a Point-In-Time Duplication of the database in question:
Here are the basics:
Here are the basics:
- You need to build an instance with a new name for the database you are about to duplicate, including: copy & edit init.ora file (make sure to set db_filename_convert and log_file_name_convert parameters and make sure remote_login_passwordfile is set to something other than 'NONE'!); create necessary file systems; modify listener.ora and tnsnames.ora to include this new instance; create passwordfile, etc.
- Next modify and execute this script. Be sure to configure any of the necessary RMAN channels, etc.
For additional information you can refer to: Metalink article 228257.1 and/or Oracle 9i RMAN Backup and Recovery by Robert G. Freeman (ISBN# 0072226625).
Feel free to contact me with and questions, comments, experiences, etc.....
How to Install 9i Release 2 (Windows)
Posted at Sunday, June 06, 2004
A how-to guide I drafted on Installing Oracle 9i Release 2 on the Windows platform
Labels: 9i, Installation
