I have been asigned for a server maintenance, with Oracle 8 installed...

I know that for making backup I need to do a sort of bat file that stops
Oracle, copy relevant files to another location and restart Oracle...

What are the commands ?

TIA

Loinex wrote:

With apologies ... I find your request offensive. If you aren't qualified
for the job you shouldn't be doing it.
Would you have accepted a job as a dentist with no knowledge of dentistry?
I, and others could give you
the commands ... heck we could give you the working file ... but what we
can't give you is the knowledge
required to get it all working properly and assure your employer that their
data is safe.

My suggestions would be as follows:
1. Hire a consultant to train you
2. Take a class and learn how to perform your job
3. Read books

Until then I can leave you with one, and only one, other bit of advice ....
ReadTheFineManual.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Since this is a 'bat' file you are looking for, I'm assuming a Windoze
platform. In that case, the commands are:

1. net stop OracleServiceSID
2. copy c:\oracle\oradata\SID\*.* c:\oracle\oradata\SID\Backup\*.*
3. net start OracleServiceSID

I highly urge you to heed Daniel's advice and read the Oracle docs and
other materials as knowing only the above is only the tip of the ice
berg.

HTh,
Brian

Loinex wrote:
--
================================================== =================

Brian Peasland
dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Maybe you do not fully understand..
If the data is needed ( even if only until the end of the year) then losing it can be a big problem..If you just back up the
file system with no knowledge of Oracle, you may not be able to use that backed up data if your oracle software should get
corrupted, or you have a disk failure, etc..

The use of EXP and IMP ( in addition to file system backup and knowing how to install and configure a new Oracle instance) is
a minimum need to be more sure of an ability to actually get any lost data back.
( The batch file commands you were shown will work if ALL your Oracle data files ( and what about the software files ?) are
in c:\oracle\oradata\SID\*.* - In most installations that will not be the case.).

Be afraid, be very afraid ( especially if your employer is going to hold you accountable for any data loss)



"Loinex" <loinex (AT) aserio (DOT) com> wrote:

"Loinex" <loinex (AT) aserio (DOT) com> wrote

I assume you moved the application, checked that the data was all there and
that clients could connect? Cause an Oracle service can start quite happily
with no database there at all.

You see the problem is that you do rather give that impression.

I don't know how to do X.
I have an imperative to do X.
Just tell me what I have to mindlessly type.

Doesn't inspire confidence.

It extraordinarily redolent of certified 'professionals' though. As indeed
is the I'm not curious about anything, unless it has a career payoff bit at
the end.


--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

I would like to live in your world :-)

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> escribió en el
mensaje news:3f1263e2$0$15035$ed9e5944 (AT) reading (DOT) news.pipex.net...