Re: Sample cold backup script

Sorry, I forgot part of my answer.
(please don't trash me for that, I'm still sleeping ;)

"eg" <eg.kua_at_felda.net.my> a écrit dans le message news: b05eb676.0311270016.696cc2c1_at_posting.google.com...
> I am new to oracle backup. Can someone show me how to write unix shell
> script to do a cold backup?

You may be new to O's backup but you seems to know what a cold backup is. I suggest that you read a good book on ksh (o'reilly korn shell is pretty good)

Alkos

> 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 - 03:00:51 CST