Re: Learn Oracle in three days?

Michael,

My biggest concern is for your database to have a good backup strategy. Some of the scripts on my website could be a good starting point for you. I have an application named Installgen which automates creating backup/recovery scripts along with creating the documentation for performing 15 different database recovery scenarios.

You may download a demo version of Installgen so that you may conveniently look at or modify the scripts on your own computer: http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

Or you may choose to browse the individual output files via the web: http://www.dotcomsolutionsinc.net/products/installgen/installgen_files_win90 1.html

Here is a full-featured RMAN backup script I like to use for situations where I am not using a recovery catalog: http://www.dotcomsolutionsinc.net/products/installgen/installgen_win901_29_. html
RMAN is preferred by Oracle over the Hot Backup method because it generates less redo in the database and you can also throttle the amount of I/O used by RMAN. (I have implemented this functionality on my scripts.) This means that if necessary, you can perform the RMAN backup while users are actively using the server without consuming all of the I/O bandwidth of the server. You will need to adjust the default I/O rate to a value which is suitable for your server.

Each of these backup scripts also produces a disaster_recovery.txt output file to help you keep your database documentation up-to-date in case you need to rebuild the database on a different server in an emergency. David Simpson
www.dotcomsolutionsinc.net

"Michael Wilkinson" <mwilkinson_jr_at_yahoo.com> wrote in message news:5d7c58cb.0205121625.3acf40c3_at_posting.google.com...
> Greetings - masters of table extents, and other things arcane. This
> neophyte has a ludicrous question for you: Is it possible for me to
> learn oracle in three days or less? I've worked with other RDBMS in
> the past, and know the difference between a fragment and a chunk, but
> my first pass through the oracle documentation had convinced me that I
> might have just entered into seventh circle of hell.
>
> Why three days you ask? Well, I've just found out that's how long I
> have before I have to take delivery of a product from an outsourcer
> that uses oracle as a backend. I'm not a DBA myself, but our in-house
> DBAs only know Informix and some MSSQL and are already running for
> cover, leaving the young and foolish (that's me) holding the bullseye.
> Since I figure the thing will chug along on own for a few days (it's
> got to at least work for a few hours for the outsource company to
> prove that it works) my first concern is obviously logical logging and
> backups.
>
> If you were in my shoes, what books and tools would you recommend I
> have to survive this suicidal oracle piano drop?
>
> Thanks in advance,
>
> - MW
Received on Sun May 19 2002 - 18:23:29 CDT