RE: rman backup

AK

   When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those archived logs to the location that Oracle will expect them to be, and I believe that is done as part of the RESTORE DATABASE command. In my situation, I found no advantage from having RMAN store the archive logs, so I have no experience there, just what I've read in the manual.

    Only RMAN can perform the RESTORE DATABASE command, but once you complete that command, you can complete the recovery using svrmgrl. From everything I've seen, RMAN just issues the RECOVER DATABASE command to svrmgrl or SQL*Plus.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, October 28, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L

Thanks Dennis for Reply,
My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ?

-ak

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 28, 2003 10:49 AM

> AK - Unless you specify otherwise, RMAN will automatically apply archive
> logs to bring the database up to the time of failure (your recover
database
> statement). This is why it is good to run disaster recovery tests on a
> regular basis, to ensure everything is ready, and you can try different
> recovery times. You will see that RMAN will not complete its recovery if
the
> archived logs are not available.
>
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Tuesday, October 28, 2003 11:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We take daily rman backup each nite at 10pm . Which means in worst case we
> risk one day of work. Now suppose something wrong goes before 10 pm .
Then
> Can I recover my database till time using previous day rman backup and
> currently available archived logs.
>
> Or in nutshell is it possible to run { restore databse; recover database }
> from rman and then apply remaing archived logs from a separated disk ( not
a
> rman backup ).
>
> Thanks,
> -ak
>
>
>
>
> --
> 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: AK
  INET: oramagic_at_hotmail.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: 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).