Problem solve Get help with specific problems with your technologies, process and projects.

Nightly backup procedure for Oracle 8i

Hi, I'm new to UNIX and here is my question: I have an Oracle 8i on Solaris, and I need a nightly backup procedure to take care of the cold backup every night. This looks very simple in theory... stop Oracle, copy all the files to backup directory, start the Oracle. I have created this procedure on NT, but I have no idea how to make it on Unix! Thanks for your help.

To give you a full backup script here would be a bit too long, so I'm going to refer you to a couple of sources. First, an Oracle Press book written by Rama Velpuri and Anand Adkoli: Oracle8i Backup & Recovery Handbook. This book has a wealth of scripts for several different platforms, including UNIX. As a matter of fact, Chapter 5 is an entire chapter of backup scripts! The UNIX environment ones are very good and very thorough. The scripts are well-documented and should give you everything you need.

Another alternative, available on the Web, is a downloadable UNIX backup script located at http://www.orsweb.com/memberarea/downloads/source/420.htm. This site, The Oracle Resource Stop, has lots and lots of good scripts and this cold backup one is short and sweet.

For More Information

  • What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.
  • The Best Oracle Web Links: tips, tutorials, scripts, and more.
  • Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
  • Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
  • Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.