RE: backup problem

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Wed, 17 Sep 2003 12:14:54 -0800
Message-ID: <F001.005D03FD.20030917121454@fatcity.com>

Good. And I would add... Test on a regular schedule to see if some yahoo has altered the server or environment and invalidated your recover procedure.

Brian

-----Original Message-----
Sent: Tuesday, September 16, 2003 4:15 PM To: Multiple recipients of list ORACLE-L

LeRoy

   One of my bigger concerns, right up there with asteroids that may strike the earth at any moment, is that no backup can be trusted until it has been tested. Yes, you can use RMAN to back up your database from here forward. But it will be a more complex task, hence more prone to exactly the problem you illustrate. So you shouldn't trust that until you've tested recovery with it. And that will take some time. My recommendation would be:

1. Fix your existing backup process.
2. Test recovery with your existing backup process.
3. Learn more about B&R.
4. Configure RMAN
5. Test RMAN recovery.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, September 16, 2003 1:05 PM To: Multiple recipients of list ORACLE-L

All -

I am implementing RMAN on my unix boxes. The dbs are already in archivelog mode for about a year. The system admin was backing up the files from cold backups. Today we realize the backups are no good. The tape is unreadable. Most of the archived logs (.arc) files have been removed from the system. Now I have no way to put them back!

How can I set rman to start backing up from today forward? Hoping to get a good backup and dependable from rman.

TIA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: LeRoy Kemnitz
  INET: lkemnitz_at_uwsa.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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.net
--

Author: Spears, Brian
  INET: BSpears_at_Limitedbrands.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed Sep 17 2003 - 15:14:54 CDT