Marcello - Sounds as if you have answered most of the issues. I am pretty much a Unix person, so someone may provide some more NT-specific answers. - For the cold backup, shut down the database (I always prefer SHUTDOWN IMMEDIATE). Copy all the files, including all data files, control files, initialization file. Yesterday we had a rousing discussion on the pros/cons of copying the redo log files. Rather than re-open that discussion, I hope you saved the emails. You can also research this issue on the net. - When you make structural changes to the database, enter the command ALTER DATABASE BACKUP CONTROLFILE TO TRACE. - When you get tired of manually shutting the database down, you can get fancy and create a script to do that. Again, there are probably examples to be found on the Internet. - In addition to the exports, I would try to do the cold backup each week, simply because it is an easy time frame to remember. These points should get you started. Good luck and I hope you enjoy your experiences with Oracle Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Tuesday, June 25, 2002 10:24 AM To: Multiple recipients of list ORACLE-L 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:[EMAIL PROTECTED]] 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. [EMAIL PROTECTED] -----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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marcello Savino 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).