| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rman ... what do YOU need
Kitri - Thanks so much for pointing this book out. I have purchased it and
worked through almost all the examples. It is excellent. It was exactly what
I needed. I had found it difficult to get started with RMAN. I had read the
Oracle manual, and taken the Oracle 8i Backup & Recovery class (briefly
covers RMAN, no classroom exercises), and felt I was getting nowhere. I
needed some concrete practice exercises.
About half of Backup & Recovery 101 is devoted to RMAN. He takes you step-by-step through creating a practice database, creating an RMAN catalog database, configuring RMAN, performing backups, listing RMAN information from both the RMAN catalog and the target database control file, performing recoveries using RMAN, creating an RMAN duplicate database, creating an RMAN standby database, and performing an RMAN tablespace point-in-time recovery. Each chapter has several relevant exercises to work through.
He has instructions for both Linux and NT, but he worked the exercises on Linux, so for NT you will have to adjust more, but there is probably enough information for you to succeed. I used the Linux instructions on a Unix system and had no problems, other than the fact that my practice system is Oracle 8.1.6 and his instructions are for Oracle 8.1.7. But the adjustments were simple and even added to my learning.
So, if you are considering RMAN, but don't know where to start, I
enthusiastically recommend that you buy Oracle Backup & Recovery 101.
http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1J&
mscssid=G50N06L3282V9M7H7E1C63LT2FLNDC69&isbn=0072194618
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, April 09, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L
FWIW --
Oracle Press recently published a "Backup & Recovery 101" book by Kenny
Smith and Stephan Haisley.
I have not yet read it, but it claims to have RMAN coverage.
Since it is part of the '101' series, I presume it covers most of the basic
stuff.
Has anyone purchased it? And read it?
I may check it out at IOUG-A next week :)
Regards,
-----Original Message-----
Sent: Tuesday, April 09, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome.
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.
-----Original Message-----
Sent: Monday, April 08, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field.
Okay, I HATE to suggest this, but since the table is small:
add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date)
add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column
create an index on oracle_date_2 and change the query to use that column
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: Robert_Freeman_at_csx.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri May 10 2002 - 12:58:24 CDT
 |
 |