f



why do we need to shutdown database or application server to backup Oracle Home?

Dear Group,

We are using Oracle 10g on Linux.

While it is easy to understand we need to shutdown database to backup
database files, I do not quite understand why do we need to shutdown
database or oracle application server to backup Oracle Homes.

It is my understanding that oracle processes will only read those
files inside the Oracle home, but not writing to them, except log
files.

Any explanations will be highly appreciated.

Thanks

0
cs35261 (4)
3/14/2008 12:52:16 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

11 Replies
1722 Views

Similar Articles

[PageSpeed] 40

On Thu, 13 Mar 2008 17:52:16 -0700, cs3526 wrote:

> While it is easy to understand we need to shutdown database to backup
> database files,

Reading books and manuals can sometimes be beneficial.

-- 
Mladen Gogala
http://mgogala.freehostia.com
0
mgogala1572 (354)
3/14/2008 8:14:32 AM
cs3526@yahoo.com wrote:

> While it is easy to understand we need to shutdown database to backup
> database files, I do not quite understand why do we need to shutdown
> database or oracle application server to backup Oracle Homes.

According to Tom Kyte, thou shalt not schedule unattended shutdowns.

C.
0
yossarian99 (106)
3/14/2008 9:16:37 AM
On 14 mar, 01:52, cs3...@yahoo.com wrote:
> Dear Group,
>
> We are using Oracle 10g on Linux.
>
> While it is easy to understand we need to shutdown database to backup
> database files, I do not quite understand why do we need to shutdown
> database or oracle application server to backup Oracle Homes.
>
> It is my understanding that oracle processes will only read those
> files inside the Oracle home, but not writing to them, except log
> files.
>
> Any explanations will be highly appreciated.
>
> Thanks

On Linux/Unix, you don't need to stop your instances to back up their
Oracle Homes.
No idea regarding Oracle application server.
0
vitalisman (104)
3/14/2008 8:10:22 PM
vitalisman@gmail.com wrote:
> On Linux/Unix, you don't need to stop your instances to back up their
> Oracle Homes.
> No idea regarding Oracle application server.
-------------------------------------------------

Would you tell me why it is not necessary to stop the instance in UNIX?

Thanks.

--
Johnson Chow
0
wschow (94)
3/15/2008 12:22:33 AM
"Mr. Chow Wing Siu" <wschow@Comp.HKBU.Edu.HK> wrote in news:frf4s9$p2o$1
@net44p.hkbu.edu.hk:

> vitalisman@gmail.com wrote:
>> On Linux/Unix, you don't need to stop your instances to back up their
>> Oracle Homes.
>> No idea regarding Oracle application server.
> -------------------------------------------------
> 
> Would you tell me why it is not necessary to stop the instance in UNIX?
> 
One can not prove a negative; which is what you asking for.

Prove why it is NECESSARY to stop the instance in UNIX?
0
anacedent (475)
3/15/2008 3:29:59 AM
On 15 mar, 01:22, "Mr. Chow Wing Siu" <wsc...@Comp.HKBU.Edu.HK> wrote:
> vitalis...@gmail.com wrote:
> > On Linux/Unix, you don't need to stop your instances to back up their
> > Oracle Homes.
> > No idea regarding Oracle application server.
>
> -------------------------------------------------
>
> Would you tell me why it is not necessary to stop the instance in UNIX?
>
> Thanks.

Because when files are open, there are no filesystem locks that would
prevent these files from being read and backed up.

And in the Oracle Homes, you don't have to be concerned about
consistency between files (questions like: what is the first file of
O_H is backed up at 10:00 and the last one at 10:03?) or about fuzzy
files (files that might be written during their backup.)

Now if you put your datafiles in O_H, that's another story. ;-)
0
vitalisman (104)
3/15/2008 8:31:19 AM
On Thu, 13 Mar 2008 17:52:16 -0700 (PDT), cs3526@yahoo.com wrote:

>Dear Group,
>
>We are using Oracle 10g on Linux.
>
>While it is easy to understand we need to shutdown database to backup
>database files, I do not quite understand why do we need to shutdown
>database or oracle application server to backup Oracle Homes.
>
>It is my understanding that oracle processes will only read those
>files inside the Oracle home, but not writing to them, except log
>files.
>
>Any explanations will be highly appreciated.

learn RMAN, or even 'hot backup'
........
We run Oracle 9iR2,10gR1/2, 10gRAC on RH4/RH5 and Solaris 10 (Sparc)
remove NSPAM to email
0
3/15/2008 6:32:50 PM
On Mar 15, 11:32=A0am, NetComrade <netcomradeNS...@bookexchange.net>
wrote:
> On Thu, 13 Mar 2008 17:52:16 -0700 (PDT), cs3...@yahoo.com wrote:
> >Dear Group,
>
> >We are using Oracle 10g on Linux.
>
> >While it is easy to understand we need to shutdown database to backup
> >database files, I do not quite understand why do we need to shutdown
> >database or oracle application server to backup Oracle Homes.
>
> >It is my understanding that oracle processes will only read those
> >files inside the Oracle home, but not writing to them, except log
> >files.
>
> >Any explanations will be highly appreciated.
>
> learn RMAN, or even 'hot backup'

Do you use RMAN or 'hot backup' to backup your Oracle Homes?

My experience on hp-ux has been that fbackup will not backup at least
one oracle executable if it is open (I forget which one and looks like
someone cleaned up the mail from that time, dang it).  Normally, one
wouldn't back up the oracle executables, as one can simply reinstall
oracle if some catastrophe wipes out the Oracle Home.  However, one
might want to make a backup of certain areas (for example, everything
_except_ the oracle data files) if one want to make a rapid recovery
tape or disk, ie, get new hardware and jam in the disk and everything
and be up a lot faster than an RMAN restore and/or reinstall plus
patching.  Whether such a capability is needed is site dependent, as
well as management-bias dependent, but it does seem to require a brief
shutdown of Oracle to copy everything.

I don't know if linux has the same issue and have no way to try it, so
I personally am curious if anyone has.  Not that I don't trust Jerome
Vitalis, but I would want to verify.

jg
--
@home.com is bogus.
It took 85 years to build Bear Stearns and four days for it to
dissolve.
0
joel-garry (4553)
3/17/2008 8:47:37 PM
>
> My experience on hp-ux has been that fbackup will not backup at least
> one oracle executable if it is open (I forget which one and looks like
> someone cleaned up the mail from that time, dang it).  Normally, one
> wouldn't back up the oracle executables, as one can simply reinstall
> oracle if some catastrophe wipes out the Oracle Home.  However, one
> might want to make a backup of certain areas (for example, everything
> _except_ the oracle data files) if one want to make a rapid recovery
> tape or disk, ie, get new hardware and jam in the disk and everything
> and be up a lot faster than an RMAN restore and/or reinstall plus
> patching.  Whether such a capability is needed is site dependent, as
> well as management-bias dependent, but it does seem to require a brief
> shutdown of Oracle to copy everything.
>
> I don't know if linux has the same issue and have no way to try it, so
> I personally am curious if anyone has.  Not that I don't trust Jerome
> Vitalis, but I would want to verify.
>
> jg
> --
> @home.com is bogus.
> It took 85 years to build Bear Stearns and four days for it to
> dissolve.

we do not shutdown oracle to backup Oracle Home, but we do need to
backup OH, as there are lots of patches, bug fix applied, which we do
not have track.

We tried to restore of those backups, they restore well and everything
seems to be working fine.





0
3/17/2008 11:18:48 PM
On Mon, 17 Mar 2008 13:47:37 -0700 (PDT), joel garry
<joel-garry@home.com> wrote:

>On Mar 15, 11:32�am, NetComrade <netcomradeNS...@bookexchange.net>
>wrote:
>> On Thu, 13 Mar 2008 17:52:16 -0700 (PDT), cs3...@yahoo.com wrote:
>> >Dear Group,
>>
>> >We are using Oracle 10g on Linux.
>>
>> >While it is easy to understand we need to shutdown database to backup
>> >database files, I do not quite understand why do we need to shutdown
>> >database or oracle application server to backup Oracle Homes.
>>
>> >It is my understanding that oracle processes will only read those
>> >files inside the Oracle home, but not writing to them, except log
>> >files.
>>
>> >Any explanations will be highly appreciated.
>>
>> learn RMAN, or even 'hot backup'
>
>Do you use RMAN or 'hot backup' to backup your Oracle Homes?

 :)

>
>I don't know if linux has the same issue and have no way to try it, so
>I personally am curious if anyone has.  Not that I don't trust Jerome
>Vitalis, but I would want to verify.

We don't have such an issue on linux.. you can always just tar oracle
home on nfs, tar is happy to backup whatever you ask it to do.. and u
can exclude files (or directories), if I remember correctly.
........
We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
remove NSPAM to email
0
3/18/2008 12:26:30 AM
On 17 mar, 21:47, joel garry <joel-ga...@home.com> wrote:

> Do you use RMAN or 'hot backup' to backup your Oracle Homes?
>
> My experience on hp-ux has been that fbackup will not backup at least
> one oracle executable if it is open (I forget which one and looks like
> someone cleaned up the mail from that time, dang it).  Normally, one

I don't know for fbackup, but some tools won't backup open files on
Unix/Linux if their content changes during the backup (some tools will
retry several times.) This is not caused by a feature at OS level
though.
0
vitalisman (104)
3/18/2008 9:40:25 PM
Reply:

Similar Artilces:

automate startup /shutdown oracle database server 9i on redhat advance server 3.0
how i automate the oracle database 9i on RedHat Advance server 3.0 automatic startup and shutdown database in linux advance server 3.0 On Mon, 2 Aug 2004 17:06:37 +0500, "Kashif Hameed" <kashifh@shoa.net> wrote: >how i automate the oracle database 9i on RedHat Advance server 3.0 automatic >startup and shutdown database in linux advance server 3.0 > as usual: just read the documentation http://download-uk.oracle.com/docs/pdf/A96167_01.pdf (and please do so prior to posting as to avoid this type of questions) -- Sybrand Bakker, Senior Oracle DBA ...

moving oracle database server into a new server
Hi all I will be moving oracle from one Solaris server into another Solaris server, the IP address and box name will be changed. Oracle version is 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). Does any one know what I need to do in order to get oracle up and running again on the new server. I know that I will need to change the tnsnames.ora and listner.ora, but is there anything else that I need to do? Thanks Teresa Teresa wrote: > Hi all > > I will be moving oracle from one Solaris server into another Solaris > server, the IP address and box name will...

How do I check which Oracle Patches are appplied to an Oracle DataBase Server
I would like to know if someone could help me with this topic, I'm traying to analize and chek which Oracle Patches are appplied to an Oracle DataBase Server >chek which Oracle Patches are appplied to an Oracle DataBase Server If they were applied with oPatch, then "opatch lsinventory" should show you what's there. If you did not use oPatch, then I have no clue. ;-) BD wrote: > >chek which Oracle Patches are appplied to an Oracle DataBase Server > > If they were applied with oPatch, then "opatch lsinventory" should show > you what's ther...

Oracle 9i Database Server on Windows 2003 Server
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B. Sc. Computer Science Teacher http://info.cegepat.qc.ca/siteyvon I've installed it on windows 2003 enterprise ed. about 1 month ago without any problem. I've installed the version 9.2.0.1 with the patch to 9.2.0.3. 9.2.0.3 is the only version certified by oracle for win 2003. Ciao "Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio n...

install oracle database server at home
Hi I am thinking of setting up an oracle database on my home computer - possibly Oracle 9i. I am wondering what spec (in terms of RAM especially) I would need. Any assistance would be appreciated. Cheers B. Baz wrote: > Hi > > I am thinking of setting up an oracle database on my home computer - > possibly Oracle 9i. I am wondering what spec (in terms of RAM > especially) I would need. Any assistance would be appreciated. > > Cheers > B. Practical minimums: - Pentium 600 - 512M Ram - 5G free disk - NOT Windows "Home" edition (XP Home, ME ...) - Prefer ...

Do I have to shutdown database in order to backup Oracle HOME?
I would like to do an Oracle Patch on a 9i database on linux. To minimize the downtime, I first take a hot backup of database. Now I need to take a backup of Oracle_HOME. Do I have to shutdown the database to do that? Your help is highly appreciated. I have not checked that .. but It is better if you can take every service which is using that ORACLE_HOME like Database + LISTENER + ORACLE HTTP SERVER + etc ... It is matter of just 15 minutes .. And while applying patch that is REQUIRED all the services should be stopped. I had 1 incident where I did not stop listener...

Oracle databases on a server
I have Oracle installation on a SUN UNIX server. I tappears that it is running Oracle 10.2 and Solaris 8. I want to find out how many databases are installed on this server. Would it be true to say that all databases installed on this server are listed in tnsnames.ora where the 'HOST' entry points to this server? On Feb 20, 9:00=A0am, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want to find out how many databases are installed on this server. > > Would it be true to s...

I need to move oracle database from one to another server
Hello. Please take into consideratio a scenarrio... on left and hardware the same server on right SUN server SUN server Solaris Oracle database And now. Left server is working. But I stopped whole server one month ago and did _full_ backup of all filesystems. After that server and database were operating back for one month. Now. I have second SUN identical server on the right. I did full restore on this server (of all filesystems). But of course database is not up to date. I can stop oracle on left and move some files to right server. My idea is to do: On the ...

SqlSpec
Do you wish you had comprehensive, easily navigable documentation for your SQL Server, Oracle, Analysis Server, MySQL, and Access databases? Are you a SQL Developer or DBA that just inherited a huge, complex database with no supporting docs and don't know where to start learning how it's put together? Are you an independent contractor working with SQL Server, Oracle, Analysis Server, MySQL, or Access? Your clients would LOVE you if you could provide comprehensive documentation about the databases you build. Are you a Project Manager who is tired of developers making chan...

How to configure application server to connect to a two-node oracle RAC database
We have a java based application which will access the two node RAC database via the Orion Application Server. What should be done so that the Orion Application Server uses both the nodes to make connections? Right now the orion application server accesses the RAC database via the jdbc thin client where you have to specify the ip address of the database server and the listerner port and the instance name. If I do it this way then the application server just connects to the particular instance that I give it. Thanks Can you use the OCI driver? Regards, Steve I can use the OCI driver if ...

How much memory and CPU does the HP server need for a 4 terabytes Oracle database
I am asked to provide a ball park estimate for how many CPUs and how much memory are needed for a 4 terabytes disk space Oracle database running under HP Unix server? Any helpful information is greatly appreciated. Thanks in advance. Peter vu wrote: > I am asked to provide a ball park estimate for how many CPUs and how > much memory are needed for a 4 terabytes disk space Oracle database > running under HP Unix server? Any helpful information is greatly > appreciated. > > Thanks in advance. If you do mainly "select 1 from DUAL", not much... ( ;) * 0.5 ) The ...

How can i connect Oracle 9i database with J2EE application server 1.4
I am using JAVA VERSION :- 1.4.03 OS:-WINDOWS XP PROFESSIONAL SP2 ORACLE 9I DATABASE How can i connect Oracle 9i database with my j2ee version i try to do a lot but where can i start? Please give me some reading suggestions? How can i connect oracle with Type 4 driver? Hello, partoti_ajay@yahoo.co.in schrieb: > I am using > > JAVA VERSION :- 1.4.03 > OS:-WINDOWS XP PROFESSIONAL SP2 > ORACLE 9I DATABASE > > How can i connect Oracle 9i database with my j2ee version > i try to do a lot but where can i start? try google and you find more tha...

it's compatible oracle 8i client, compatible whith oracle 9i server (or oracle 10g server)
Hi all, I have a client/server application that work on the client with oracle 8i client connected to oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) , and I wonder if the client will work fine without upgrade version. Thanks Angel R. wrote: > Hi all, > I have a client/server application that work on the client with oracle 8i > client connected to > oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) > , and > I wonder if the client will work fine without upgrade version. > > Thanks If...

oracle application server, ibm websphere, sun application server �T�̥i���i�H�@�Ӥ���O?
~ Let us linux ~ -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- ...

Web resources about - why do we need to shutdown database or application server to backup Oracle Home? - comp.databases.oracle.server

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Report: Apple’s quest for retail stores in India on track as government plans to approve application
... Apple , and India . What do you think? Discuss "Report: Apple’s quest for retail stores in India on track as government plans to approve application" ...

Stugan Games Accelerator Opens Applications for 2016
Games accelerator Stugan has opened its application process for its 2016 summer program. The program will accept 20 aspiring game developers, ...

eHosting DataFort to provide next generation data centre services with its Cisco Application-Centric ...
Al-Bawaba eHosting DataFort to provide next generation data centre services with its Cisco Application-Centric Infrastructure ... Al-Bawaba ...

Remote application server streamlines Windows desktop delivery
... that they need is therefore a challenging task. Cross platform solutions specialist Parallels is launching a new version of its Remote Application ...

Tech City UK received just 37 applications for a visa route that allows 200
Tech City UK, a taxpayer-funded government organisation, has received just 37 applications since April 2015 for a dedicated technology visa that ...

Toshiba Launches 40V N-ch Low ON-resistance Power MOSFET for Automotive Applications
Toshiba launched a 40V N-ch power MOSFET, &quot;TKR74F04PB,&quot; for automobile applications, including DC-DC converters, high capacity motor ...

MBA: Mortgage Applications Increased in Latest Weekly Survey, Purchase Applications up 22% YoY
From the MBA: Mortgage Applications Increase as Rates Continue to Drop in Latest MBA Weekly Survey Mortgage applications increased 8.8 percent ...

Mortgage applications up 8.8%
Defying expectations for the start of 2016, mortgage rates spiraled down further last week, spurring more applications.

The USPTO updates their refusal of Sony's 'Let's Play' trademark application
... and Trademarks Office shot them down. What was interesting was the USPTO’s justification for doing so. They didn’t originally deny the application ...

Resources last updated: 2/9/2016 2:42:05 PM