You can recover just one or a set of datafiles with RMAN. I've had to do that for a recovery before. It will recover just the datafiles you need plus the necessary archive logs.
Jim "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: >No, not from what I saw. I may be wrong, though. > >Lisa > >> -----Original Message----- >> From: Orr, Steve [SMTP:[EMAIL PROTECTED]] >> Sent: Thursday, April 04, 2002 10:24 AM >> To: Multiple recipients of list ORACLE-L >> Subject: RE: Deleting old archive log files. >> >> > the most portable and sanest route is to use RMAN >> Agreed. Go RMAN... Gorman... Hmmm... :-) >> >> > Being able to issue only two commands (i.e. "RESTORE DATABASE" and >> "RECOVER >> > DATABASE") over dialup from home after being roused at 2:30am and having >> > RMAN do all the thinking for you is sublime. >> If you do a RESTORE/RECOVER DATABASE doesn't RMAN retrieve and restore ALL >> datafiles from tape? Wouldn't this unnecessarily increase the mean time to >> recovery if you just need to recover one datafile? >> >> >> Orrman for RMAN, >> Steve Orr >> Bozeman, MT >> >> >> >> -----Original Message----- >> Sent: Thursday, April 04, 2002 7:19 AM >> To: Multiple recipients of list ORACLE-L >> >> >> If you are not using RMAN, the best, safest, and most portable approach >> whether deleting archived redo log files on UNIX, VMS, or Windows is the >> technique of "SQL-generating-OScmd". Query the V$ARCHIVED_LOG view to >> retrieve the file's NAME where COMPLETION_TIME < whatever-you-want and >> ARCHIVED='Y'. The query should be written to spool the OS-specific >> "remove" >> command along with the file-name, and the spool output can be run as a >> ".bat" script in Windows, a shell script in UNIX, or DCL script in >> OpenVMS. >> >> However, the most portable and sanest route is to use RMAN for backups and >> deletion of archived redo log files (and datafiles, of course), as all of >> RMAN's actions are recorded and are viewable through V$ARCHIVED_LOG and >> other views. RMAN not only handles archived redo log files according to >> the >> rules you specify, it can backup the log files multiple times before >> deleting them, keeping track of everything. If you have a bad tape, look >> for the archived redo log file on an older tape. RMAN also validates the >> redo log files during the backup to verify that it is not corrupted, an >> invaluable service. >> >> Yes, RMAN is tough to set up, but it's very name indicates it's focus. >> It's >> not called "backup manager" or BMAN for a reason. >> >> Being able to issue only two commands (i.e. "RESTORE DATABASE" and >> "RECOVER >> DATABASE") over dialup from home after being roused at 2:30am and having >> RMAN do all the thinking for you is sublime. Every DBA who has been >> around >> for a couple years has their own "backup scripts" that they love and trust >> (myself included), but how many have bothered to automate restore and >> recovery? Those who have are certainly aware of the shortcomings of their >> own efforts and probably use their restore/recovery scripts very >> sparingly, >> if they are wise, as the most common cause of failed recoveries by far is >> not tape failure, but human error or (worse yet) semi-automated human >> error. >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Orr, Steve >> INET: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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: Koivu, Lisa > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). > -- _____________________________ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
