Hi List,

On my server m/c 2 instances are running for sql server 2000, I have applied
service pack 3 (sp3) for default instance.Now when i am trying to install
sp3 for my non default server instance its now allow to change me default
instance.Do we need to install sp3 for every instance if yes . How can we
change instance name while installing sp3 for non default instances.

TIA,

Sheilesh

----- Original Message -----
From: "Vijay K Singh" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, February 28, 2003 10:58 AM
Subject: RE: Recovery from Cold Backup ?


>
> Thanks for the Help Ganesh ...... Actually one of my project mate was
> betting me on this, his point was that you cannot recover your database
> with cold backup till the point of failure ... and i said you have backup
> of lasted controlfile then you can .. but he was not agreeing .. anyway ..
> thanks
> of the response ..
>
> I understand MTTR will be very high in our scrnario but we have discussed
> it with client, he agreed upon it and doesnt want to spend much
> money on backup since it has be outsourced to other company.
>
>
> Thanks & Regards
> Vijay Kr. Singh
>
>
>
>
> [Email Address Removed] gilent.com To:
[Email Address Removed] cc: [Email Address Removed] 02/28/2003 10:53 Subject: RE: Recovery
from Cold Backup ?
> AM
>
>
>
>
>
>
> Yes ... Possible but u should leave your Redo and Control Files Intact ..
U
> should not overwrite them If you do that then you have lost the state in
> which the DB was before the crash. Oracle Only knows now that the SCN on
> the file Headsr and Controlfiles match one to one.
>
> And another thing that you need to know and be aware of is that the MTTR
> [Mean time to recover] from a Cold Back which ais a Month old will be
GHigh
> compared to n Hotbackup that was a Week old.
>
> HTH
>
> Best Regards,
> Ganesh R
> Everest Reporting Team
> DID: +65-6215-8413
> Tel: 215-8413
> HP : +65-9067-8474
>
>
>
> -----Original Message-----
> From: Vijay K Singh [mailto:[Email Address Removed] Sent: Friday, February 28, 2003 1:14 PM
> To: LazyDBA.com Discussion
> Subject: Recovery from Cold Backup ?
>
>
> Hi All,
>
> There is question troubling me for which i need your help.
>
> Is it possible to recover database till Point of failure with cold backup
> and having all archives from the last cold Backup?
>
> In scenario we take cold backup once in month and take backup of all
> the archive generated on daily basis.
> Now suppose our database crashes some take, then we can restore it from
our
> previous month's cold backup. But now the question is
> Can i apply all the archive which was generated after the cold backup to
> recover my database till Point of failure.
>
> I know it can be done in case of Hot backups but is it possible with cold
> backups also ?
>
> Any help in this regard will be highly appriciated.
>
> We are running on Sun Solaris 5.8 and Oracle 8.1.7.0.
>
> Thanks in Advance
> Vijay Kr. Singh
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:
> http://www.lazydba.com/legal.html
>
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003

Oracle LazyDBA home page