Re: I want to re-install system, how can I backup and recover?

2001-05-11 Thread Rachel Carmichael

well if you are lucky and all the files are there, yes, backup the physical 
datafiles and when you bring the database up again, Oracle will recover.

You MAY have to open the database resetlogs.

Questions though:

is the database still up? Can you shut it down cleanly (shutdown) and then 
do a cold backup of all the files? You are golden then.

if the database is NOT up, do you run the database in archivelog or 
nonarchivelog mode.  This will determine what you have to do to 
restart/recover the database.

But no matter what take a backup of ALL the physical files on your system. 
This gives you a place to go back to if you do something incorrectly. Always 
good to have somewhere to go to start over.

Rachel


From: Robert Chen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: I want to re-install system, how can I backup and recover?
Date: Fri, 11 May 2001 08:35:39 -0800

hi,

Because a hacker hackered our system, I have to re-install the solaris. How
can I backup the oracle database?

Just backup all the physical files? I am not a back up and recover expert.
Please help me...

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Chen
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: I want to re-install system, how can I backup and recover?

2001-05-11 Thread Paul Drake

Robert Chen wrote:
 
 hi,
 
 Because a hacker hackered our system, I have to re-install the solaris. How
 can I backup the oracle database?
 
 Just backup all the physical files? I am not a back up and recover expert.
 Please help me...
 

Robert,

If your Solaris box is truly compromised, a backup of all files,
followed by a restore of all files, would give you the compromised box
back. Aim higher.
What is required is an install from original media, followed by a
restore of only the absolutely necessary files - init.ora, control
files, log files, data files. (from a cold shutdown).
Don't restore by directory - restore by individual file.

Leave everything else behind - on tape.

Here is your starting point:

http://www.cert.org/tech_tips/win-UNIX-system_compromise.html

snip
E.Recover from the intrusion

1.Install a clean version of your operating system

Keep in mind that if a machine is compromised, anything on that system
could have been modified, including
the kernel, binaries, datafiles, running processes, and memory. In
general, the only way to trust that a
machine is free from backdoors and intruder modifications is to
reinstall the operating system from the
distribution media and install all of the security patches before
connecting back to the network. Merely
determining and fixing the vulnerability that was used to initially
compromise this machine may not be enough.

We encourage you to restore your system using known clean binaries. In
order to put the machine into a
known state, you should re-install the operating system using the
original distribution media.
/snip

Now that you've gone through this, you may be tempted to use an
intrusion detection system.
Tripwire comes to mind - lots of other pieces of code for recording MD5
checksums of files.

http://www.cert.org/tech_tips/intruder_detection_checklist.html

Please don't reconnect the box to your network until it is completely
patched.

good luck - enjoy the learning experience.

Paul
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).