| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Backup and restore
Why do not bring down the DB and then copy the whole directory
to another place on the disk.
In case of trouble just copy back.
Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, June 25, 2002 5:23 PM
Ok Oracle 8i
1 development DB (a very small one) installed on a W2K Pro (NT)
I can shutdown DB at any time.
I need a cold backup just in case i have to recover the whole DB.
An Export/import script (dump/load to/from ascii files) would be enough for
me.
Tanks in advance, Marcello
PS(the wizard does not work , other way ...)
-----Messaggio originale-----
Da: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Inviato: marted́ 25 giugno 2002 16.08
A: Multiple recipients of list ORACLE-L
Oggetto: RE: Backup and restore
Marcello - Oracle backup and recovery is an extensive subject because different organization's requirements vary so widely. For example, a small personal test database has very simple backup requirements, while a large eCommerce Web site that absolutely must be up 24x7 has very complex ones. Backup & recovery is one of the most important requirements for an Oracle site and it is absolutely critical that you have a competent backup scheme that matches your site's requirements. One good way to begin is to take the Oracle Education class for Backup and Recovery, if that is available to you.
Why don't you give us a hint as to what your requirements are, and some of us can better advise you how to start. What Oracle version are you using? How many databases? What type of server (Unix, NT)? Are you easily able to shut the database down in evenings or weekends for a cold (offline) backup? Include any other factors that you feel are significant to your backup and recovery situation.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, June 25, 2002 3:33 AM
To: Multiple recipients of list ORACLE-L
Hi i am an oracle newbie.
I can't find an exaustive explanation about backup and restore in Oracle.
I mean policy, commands and syntax without using wizards.
I did a fast run cross orafaq, but i can't find it ...
Any help ....
thank you, Marcello
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Marcello Savino
INET: marcello.savino_at_siaspa.it
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: adar76_at_inter.net.il
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Tue Jun 25 2002 - 12:31:45 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |