Windows Cold backup with ORADMIN or NET STOP
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 ?