Cold back: net stop OracleServiceSID

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 2 Sep 1999 14:21:16 GMT
Message-ID: <01bef557$01fd4d10$2c289a0a@apollo>

Hi!

Im about to implement a nightly, cold backup on an Oracle 8.0.5 database, running on a NT server. Archive mode is off. The database is running unattended at a customer. I dont want the customer to have system,sys or internal passwords, nor be able to read them in scripts. I dont have much experience in backup/recovery of Oracle.

My ideas are these:

Use At cmd to run script:
Stop database using net stop OracleServiceSID Copy datafiles, controlfiles, initsid and passwordfile. Should i get redologs too?
Startup database using net start
Later same night backup files to tape.

Questions:
Is net stop ... the same as a shutdown abort? Assume users are logged in, but have no active transactions, when the db shuts down, will that harm the database? To do recovey I simple owerwrite datafiles and controlfiles (and redo's?) from last nights backup and start the database again? Could I do a better scripts, ie shutting down more gracefully, without revealing passwords?

Thanks!
Peter Laursen Received on Thu Sep 02 1999 - 09:21:16 CDT