Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backup flashback logs to tape

Re: Backup flashback logs to tape

From: joel garry <joel-garry_at_home.com>
Date: Thu, 05 Jul 2007 11:39:40 -0700
Message-ID: <1183660780.043021.23650@m37g2000prh.googlegroups.com>


On Jul 5, 2:52 am, Ganesh <ganesh.tam..._at_gmail.com> wrote:
> I am very sorry my thread started all this mud sledging. I have
> started working on ORACLE just a couple of months ago. No document
> provided answers to my questions and hence I posted them here. If
> someone claims any document has answerws to these questions, please
> provide me the link.
>
> But the positives I have got from my investigation and this
> discussion:
>
> 1. Flashback logs are more of a nice to have feature and its okay if
> we don't back them up as they are not required for recovery.
>
> 2. There is no command / workaround ORACLE provides for backing up
> Flashback logs to TAPE.
>
> 3. Given this if you still want to backup Flashback Logs its going to
> be a very tricky operation. You will have to find a way to backup
> Flashback log files, make sure that corresponding archive log also
> gets backed up and during restore all succeeding Flashback logs and
> Recovery logs should be brought from TAPE to Disk.
>
> Given my business need I will have to find some solution for this.
> Will definitely post my approach here if I succeed.
>
> It would have helped me a lot if someone would have just told me all
> the above things in simple language or at least provided me a link
> where I can get this info, if any such link is available.
>
> Thanks & Regards,
> Ganesh

See http://groups.google.com/group/ORACLE_DBA_EXPERTS/browse_thread/thread/629d03bb60c6c04f

Vladimir M. Zakharychev wrote:

>only fire extinguishers are not that expensive. :)

Depends :-) http://itmanager.blogs.com/notes/2004/05/fire_suppressio.html

jg

--
@home.com is bogus.
'Passengers wishing to smoke should only do so on the concourse in
located front of the main terminal. For the safety of fellow
passengers, please dispose of all cigarette butts carefully. In
particular, be aware of fast moving vehicles packed with gas
canisters, petrol and sharp objects, as these may cause damage if
inadvertently ignited by a stray cigarette.' - Andy C
Received on Thu Jul 05 2007 - 13:39:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US