Database Administration (MOSC)

MOSC Banner

Windows Cold backup with ORADMIN or NET STOP

edited Feb 19, 2009 3:06AM in Database Administration (MOSC) 2 comments
 We have recently implemented Oracle 10g on windows. We are currently doing cold backups every night. We are currently using the following command to stop the database/service before copying the Oracle datafiles

oradim -SHUTDOWN -SID <sid> -USRPWD <passwd> -SHUTTYPE srvc,inst -SHUTMODE i

This seems to work fine, the alert.log shows "Shutting down instance (immediate)" and "Completed: alter database close normal", so the database shutdown is good, and we have restored the datafiles successfully in a test environment,

.

My question is:

Is there a difference between using ORADIM versus NET STOP <oracleservice> to stop the database/service before copying the files for a cold backup ?  Is there one better than the other ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center