RE: For all your Peoplesoft folks

RE: For all your Peoplesoft folks

 

  

Good point Amin, but there has to be two issues -- albeit not
communicated very well at all since they run together leading you to
your conclusion.

If a disk goes bad, the database continues to run is one point, but if
you drop a table, you cannot use the mirror to recover, is another point
-- these two are mutually exclusive.

Flashback of course might be considered in the case of dropped tables,
(as would be the fastest of all). In a production environment such an
occurrences would probably be a DBA thing... like a maintenance mistake,
or upgrade,... -- (coming back around to flashback again)... and the
fact that the database would probably not even be used at that
particular time.

However the discussion revolved around Development and test environments
-- where tables are often accidently dropped, or data truncated or
refreshed by mistake. Sometimes you have to read the whole thread to
get the context.


Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Amin Adatia
[mailto:oracledba-ezmlmshield-x27297171.[Email address protected]
Sent: Friday, July 27, 2007 10:22 PM
To: LazyDBA Discussion
Subject: Re: For all your Peoplesoft folks

And you think you can recover the table and be synchronized with the
data
from the backup? What if this was a detail table in a master
-detail-detail
setup? Must be an amazing application that would continue to run after
someone drops a table and an even more amazing environment where people
just
drop tables as they feel.

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "Dustin Hayden "
<oracledba-ezmlmshield-x30241333.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, July 27, 2007 9:53 PM
Subject: RE: For all your Peoplesoft folks


> No.
> The mirror in done automatically at the san level.
> So if a disk goes bad the database continues to run.
> The BC's are used for backups.
> If someone drops a tale it would also get dropped at the same time on
> the mirror. So you can not just rely on the internal mirroring at the
> san level.
>
>
> -----Original Message-----
> From: Amin Adatia [mailto:[Email address protected]
> Sent: Friday, July 27, 2007 7:31 PM
> To: Dustin Hayden; LazyDBA
> Subject: Re: For all your Peoplesoft folks
>
> If you have a mirrored SAN, then why also a disk backup? Does that not
> just
> defeat the purpose? Warm and fuzzy aside ...
>
> Regards
> Amin Adatia ([Email address protected]
> KnowTech Solutions Inc. (www.knowtech.ca)
> (613) 226-8378 Mobile (613) 864-8378
> ----- Original Message -----
> From: "Dustin Hayden" <[Email address protected]
> To: "Amin Adatia " <[Email address protected]
> Sent: Friday, July 27, 2007 4:34 PM
> Subject: RE: For all your Peoplesoft folks
>
>
> Would not be an issue for us. We also have a CA that can be snapped
and
> brought back up in about two minutes.
>
> Plus the disk we use for our backups in not resync'd until two hours
> before it is time to snap it for the next backup.
> So using that I can still be backup in under 20 minutes.
>
> Then worst case is using the compressed files for the restore and I
can
> restore that in about three hours.
>
> Not to bad for a 1 TB database.
>
> Not to mention all data is also mirrored on our san. So barring an all
> out nuclear war we should be good. :)
>
> -----Original Message-----
> From: Amin Adatia [mailto:[Email address protected]
> Sent: Friday, July 27, 2007 4:30 PM
> To: Dustin Hayden
> Subject: Re: For all your Peoplesoft folks
>
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address
as
> normal
> **Anything below this line is the original email text
>
>
> Have you calculated the time to recover in case of a disaster? Maybe
> better
> just to have RAID set up with 4 disk sets. Work out the probability of
> failure
>
> Regards
> Amin Adatia [Email address protected]
> KnowTech Solutions Inc. (www.knowtech.ca)
> (613) 226-8378 Mobile (613) 864-8378
> ----- Original Message -----
> From: "Dustin Hayden "
> [Email address protected]
> To: "LazyDBA Discussion" [Email address protected]
> Sent: Friday, July 27, 2007 4:15 PM
> Subject: RE: For all your Peoplesoft folks
>
>
>> Database is close to 1 TB.
>> Designed a custom backup solution using BC's that get snapped mounted
> to
>> another machine where data files are compress and backed up.
>> So we pretty much have a level 0 backup every night.
>>
>> I use these compressed data files to refresh four other instances.
>> We also have a full sized reporting instance and a full sized play
>> ground for me.
>>
>>
>> -----Original Message-----
>> From: Schleicher Jeremy D.
>> [mailto:oracledba-ezmlmshield-x31950696.[Email address protected]
>> Sent: Friday, July 27, 2007 2:08 PM
>> To: LazyDBA Discussion
>> Subject: For all your Peoplesoft folks
>>
>> What method do you guys use for refreshing your test and dev
databases
>> from production?
>>
>>
>>
>> Thanks!
>>
>>
>>
>> Jeremy Schleicher
>>
>> ERP Database Administrator
>>
>> Florida State University
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>> To post a dba job: http://jobs.lazydba.com
>> To Subscribe : http://www.LazyDBA.com
>> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>> To post a dba job: http://jobs.lazydba.com
>> To Subscribe : http://www.LazyDBA.com
>> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>>
>>
>>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page