Re: Backup Strategy

Jeremiah, you must evidently not know Jared based on your reply. He didnt detail the step but gave an overall theory. I know his scripts wouldnt take anything on blind faith(unless of course he's the ONLY one who does DBA work on that database, then if he's as anal as me, he still wouldnt trust himself) ;)

joe
Jeremiah Wilton wrote:
>
> On Thu, 4 Oct 2001, Gene Sais wrote:
>
> > 2) Cold backups follow the KISS principle. Shutdown db, tar, dump,
> > cpio, dd, etc. the datafiles, redo logs, ctl files, oracle
> > filesystems, etc. to tape, Startup db, Done. Take the tape to same or
> > another server and restore, No Oracle cmds required (filesystems
> > being the same).
>
> Seems like if you just tar everything up without querying the database
> for the file locations, you stand a chance of missing files. You are
> relying on the good will of all involved to put new datafiles under
> the mountpoints you are backing up. If someone makes a mistake and
> puts a new datafile in a different place, it can result in that file
> not getting backed up. All backup scripts, hot and cold, should be
> obtaining the file locations from the database instance. You are not
> really saving anything by avoiding "oracle commands."
>
> Jared wrote:
>
> > As for cold backups, and I'm sure you've heard this already, they're
> > only really needed after you open a database with 'resetlogs' .
> > Otherwise it is not necessary to use a cold backup.
>
> What? you haven't recovered past resetlogs before?
>
> 8-)
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

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