Total Pageviews

Wednesday, October 25, 2017

Auto shutdown database and copy datafiles to desired location




sqlplus sys/oracle_4me@db11gdev as sysdba @G:\alert\shut.sql


1. This batch file will call the 2nd script (shut.sql).





Below script withh shutdown the database and copy the all datafiles to desired destination.



shutdown immediate


host copy G:\DB11GDEV\DB11GDEV\*.dbf   H:\target



No comments:

Post a Comment