Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sample cold backup script

Sample cold backup script

From: eg <eg.kua_at_felda.net.my>
Date: 27 Nov 2003 00:16:28 -0800
Message-ID: <b05eb676.0311270016.696cc2c1@posting.google.com>


I am new to oracle backup. Can someone show me how to write unix shell script to do a cold backup?

I would like to do the following:

  1. Prompt the user to select an option.
  2. Say option 2 is to do cold backup.
  3. Connect to db to get datafiles, control files, redolog files' names.
  4. Shutdown db.
  5. Send the files' name to a file.
  6. Perform tar -cvf of the files' name.
  7. Startup db.
  8. Show option again.

Thanks,
eg Received on Thu Nov 27 2003 - 02:16:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US