Apakah nggak ada perintah untuk clean shutdown dulu di scriptnya? Cold backup perlu clean database shutdown, supaya semua datafilenya consistent dengan controlfilenya. Kalo gak consistent pasti instancenya minta recovery.
pastikan sebelum copy dijalankan databasenya sudah bener2 down. On 7/24/06, Ahmad Zakki <[EMAIL PROTECTED]> wrote: > > scriptnya untuk backup file ini : > > del G:\Oracle_BACKUP\E\Proddata\A*.DBF > del G:\Oracle_BACKUP\E\Proddata\B*.DBF > del G:\Oracle_BACKUP\E\Proddata\C*.DBF > del G:\Oracle_BACKUP\E\Proddata\D*.DBF > del G:\Oracle_BACKUP\E\Proddata\E*.DBF > del G:\Oracle_BACKUP\E\Proddata\F*.DBF > del G:\Oracle_BACKUP\E\Proddata\G*.DBF > del G:\Oracle_BACKUP\E\Proddata\H*.DBF > del G:\Oracle_BACKUP\E\Proddata\I*.DBF > del G:\Oracle_BACKUP\E\Proddata\J*.DBF > del G:\Oracle_BACKUP\E\Proddata\K*.DBF > del G:\Oracle_BACKUP\E\Proddata\L*.DBF > del G:\Oracle_BACKUP\E\Proddata\M*.DBF > del G:\Oracle_BACKUP\E\Proddata\N*.DBF > del G:\Oracle_BACKUP\E\Proddata\O*.DBF > del G:\Oracle_BACKUP\E\Proddata\P*.DBF > del G:\Oracle_BACKUP\E\Proddata\Q*.DBF > del G:\Oracle_BACKUP\E\Proddata\R*.DBF > del G:\Oracle_BACKUP\E\Proddata\S*.DBF > del G:\Oracle_BACKUP\E\Proddata\T*.DBF > del G:\Oracle_BACKUP\E\Proddata\U*.DBF > del G:\Oracle_BACKUP\E\Proddata\V*.DBF > del G:\Oracle_BACKUP\E\Proddata\W*.DBF > del G:\Oracle_BACKUP\E\Proddata\X*.DBF > del G:\Oracle_BACKUP\E\Proddata\Y*.DBF > del G:\Oracle_BACKUP\E\Proddata\Z*.DBF > > del G:\Oracle_BACKUP\F\Proddata\A*.DBF > del G:\Oracle_BACKUP\F\Proddata\B*.DBF > del G:\Oracle_BACKUP\F\Proddata\C*.DBF > del G:\Oracle_BACKUP\F\Proddata\D*.DBF > del G:\Oracle_BACKUP\F\Proddata\E*.DBF > del G:\Oracle_BACKUP\F\Proddata\F*.DBF > del G:\Oracle_BACKUP\F\Proddata\G*.DBF > del G:\Oracle_BACKUP\F\Proddata\H*.DBF > del G:\Oracle_BACKUP\F\Proddata\I*.DBF > del G:\Oracle_BACKUP\F\Proddata\J*.DBF > del G:\Oracle_BACKUP\F\Proddata\K*.DBF > del G:\Oracle_BACKUP\F\Proddata\L*.DBF > del G:\Oracle_BACKUP\F\Proddata\M*.DBF > del G:\Oracle_BACKUP\F\Proddata\N*.DBF > del G:\Oracle_BACKUP\F\Proddata\O*.DBF > del G:\Oracle_BACKUP\F\Proddata\P*.DBF > del G:\Oracle_BACKUP\F\Proddata\Q*.DBF > del G:\Oracle_BACKUP\F\Proddata\R*.DBF > del G:\Oracle_BACKUP\F\Proddata\S*.DBF > del G:\Oracle_BACKUP\F\Proddata\T*.DBF > del G:\Oracle_BACKUP\F\Proddata\U*.DBF > del G:\Oracle_BACKUP\F\Proddata\V*.DBF > del G:\Oracle_BACKUP\F\Proddata\W*.DBF > del G:\Oracle_BACKUP\F\Proddata\X*.DBF > del G:\Oracle_BACKUP\F\Proddata\Y*.DBF > del G:\Oracle_BACKUP\F\Proddata\Z*.DBF > > del G:\Oracle_BACKUP\I\Proddata\A*.DBF > del G:\Oracle_BACKUP\I\Proddata\B*.DBF > del G:\Oracle_BACKUP\I\Proddata\C*.DBF > del G:\Oracle_BACKUP\I\Proddata\D*.DBF > del G:\Oracle_BACKUP\I\Proddata\E*.DBF > del G:\Oracle_BACKUP\I\Proddata\F*.DBF > del G:\Oracle_BACKUP\I\Proddata\G*.DBF > del G:\Oracle_BACKUP\I\Proddata\H*.DBF > del G:\Oracle_BACKUP\I\Proddata\I*.DBF > del G:\Oracle_BACKUP\I\Proddata\J*.DBF > del G:\Oracle_BACKUP\I\Proddata\K*.DBF > del G:\Oracle_BACKUP\I\Proddata\L*.DBF > del G:\Oracle_BACKUP\I\Proddata\M*.DBF > del G:\Oracle_BACKUP\I\Proddata\N*.DBF > del G:\Oracle_BACKUP\I\Proddata\O*.DBF > del G:\Oracle_BACKUP\I\Proddata\P*.DBF > del G:\Oracle_BACKUP\I\Proddata\Q*.DBF > del G:\Oracle_BACKUP\I\Proddata\R*.DBF > del G:\Oracle_BACKUP\I\Proddata\S*.DBF > del G:\Oracle_BACKUP\I\Proddata\T*.DBF > del G:\Oracle_BACKUP\I\Proddata\U*.DBF > del G:\Oracle_BACKUP\I\Proddata\V*.DBF > del G:\Oracle_BACKUP\I\Proddata\W*.DBF > del G:\Oracle_BACKUP\I\Proddata\X*.DBF > del G:\Oracle_BACKUP\I\Proddata\Y*.DBF > del G:\Oracle_BACKUP\I\Proddata\Z*.DBF > > # from drive E > xcopy E:\oracle\proddata\A*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\B*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\C*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\D*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\E*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\F*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\G*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\H*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\I*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\J*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\K*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\L*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\M*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\N*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\O*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\P*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\Q*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\R*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\S*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\T*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\U*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\V*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\W*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\X*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\Y*.DBF G:\Oracle_BACKUP\E\Proddata > xcopy E:\oracle\proddata\Z*.DBF G:\Oracle_BACKUP\E\Proddata > #from drive F > xcopy F:\oracle\proddata\A*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\B*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\C*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\D*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\F*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\F*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\G*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\H*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\I*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\J*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\K*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\L*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\M*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\N*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\O*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\P*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\Q*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\R*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\S*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\T*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\U*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\V*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\W*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\X*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\Y*.DBF G:\Oracle_BACKUP\F\Proddata > xcopy F:\oracle\proddata\Z*.DBF G:\Oracle_BACKUP\F\Proddata > #from drive I > xcopy I:\oracle\proddata\A*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\B*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\C*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\F*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\F*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\G*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\H*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\I*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\J*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\K*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\L*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\M*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\N*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\O*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\P*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\Q*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\R*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\S*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\T*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\U*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\V*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\W*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\X*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\Y*.DBF G:\Oracle_BACKUP\I\Proddata > xcopy I:\oracle\proddata\Z*.DBF G:\Oracle_BACKUP\I\Proddata > # Zip the files > # Drive E > wzzip G:\Zip\E\proddata\A.zip G:\Oracle_Backup\E\proddata\A*.dbf > wzzip G:\Zip\E\proddata\B.zip G:\Oracle_Backup\E\proddata\B*.dbf > wzzip G:\Zip\E\proddata\C.zip G:\Oracle_Backup\E\proddata\C*.dbf > wzzip G:\Zip\E\proddata\D.zip G:\Oracle_Backup\E\proddata\D*.dbf > wzzip G:\Zip\E\proddata\E.zip G:\Oracle_Backup\E\proddata\E*.dbf > wzzip G:\Zip\E\proddata\F.zip G:\Oracle_Backup\E\proddata\F*.dbf > wzzip G:\Zip\E\proddata\G.zip G:\Oracle_Backup\E\proddata\G*.dbf > wzzip G:\Zip\E\proddata\H.zip G:\Oracle_Backup\E\proddata\H*.dbf > wzzip G:\Zip\E\proddata\I.zip G:\Oracle_Backup\E\proddata\I*.dbf > wzzip G:\Zip\E\proddata\J.zip G:\Oracle_Backup\E\proddata\J*.dbf > wzzip G:\Zip\E\proddata\K.zip G:\Oracle_Backup\E\proddata\K*.dbf > wzzip G:\Zip\E\proddata\L.zip G:\Oracle_Backup\E\proddata\L*.dbf > wzzip G:\Zip\E\proddata\M.zip G:\Oracle_Backup\E\proddata\M*.dbf > wzzip G:\Zip\E\proddata\N.zip G:\Oracle_Backup\E\proddata\N*.dbf > wzzip G:\Zip\E\proddata\O.zip G:\Oracle_Backup\E\proddata\O*.dbf > wzzip G:\Zip\E\proddata\P.zip G:\Oracle_Backup\E\proddata\P*.dbf > wzzip G:\Zip\E\proddata\Q.zip G:\Oracle_Backup\E\proddata\Q*.dbf > wzzip G:\Zip\E\proddata\R.zip G:\Oracle_Backup\E\proddata\R*.dbf > wzzip G:\Zip\E\proddata\S.zip G:\Oracle_Backup\E\proddata\S*.dbf > wzzip G:\Zip\E\proddata\T.zip G:\Oracle_Backup\E\proddata\T*.dbf > wzzip G:\Zip\E\proddata\U.zip G:\Oracle_Backup\E\proddata\U*.dbf > wzzip G:\Zip\E\proddata\V.zip G:\Oracle_Backup\E\proddata\V*.dbf > wzzip G:\Zip\E\proddata\W.zip G:\Oracle_Backup\E\proddata\W*.dbf > wzzip G:\Zip\E\proddata\X.zip G:\Oracle_Backup\E\proddata\X*.dbf > wzzip G:\Zip\E\proddata\Y.zip G:\Oracle_Backup\E\proddata\Y*.dbf > wzzip G:\Zip\E\proddata\Z.zip G:\Oracle_Backup\E\proddata\Z*.dbf > # Drive F > wzzip G:\Zip\F\proddata\A.zip G:\Oracle_Backup\F\proddata\A*.dbf > wzzip G:\Zip\F\proddata\B.zip G:\Oracle_Backup\F\proddata\B*.dbf > wzzip G:\Zip\F\proddata\C.zip G:\Oracle_Backup\F\proddata\C*.dbf > wzzip G:\Zip\F\proddata\D.zip G:\Oracle_Backup\F\proddata\D*.dbf > wzzip G:\Zip\F\proddata\E.zip G:\Oracle_Backup\F\proddata\E*.dbf > wzzip G:\Zip\F\proddata\F.zip G:\Oracle_Backup\F\proddata\F*.dbf > wzzip G:\Zip\F\proddata\G.zip G:\Oracle_Backup\F\proddata\G*.dbf > wzzip G:\Zip\F\proddata\H.zip G:\Oracle_Backup\F\proddata\H*.dbf > wzzip G:\Zip\F\proddata\I.zip G:\Oracle_Backup\F\proddata\I*.dbf > wzzip G:\Zip\F\proddata\J.zip G:\Oracle_Backup\F\proddata\J*.dbf > wzzip G:\Zip\F\proddata\K.zip G:\Oracle_Backup\F\proddata\K*.dbf > wzzip G:\Zip\F\proddata\L.zip G:\Oracle_Backup\F\proddata\L*.dbf > wzzip G:\Zip\F\proddata\M.zip G:\Oracle_Backup\F\proddata\M*.dbf > wzzip G:\Zip\F\proddata\N.zip G:\Oracle_Backup\F\proddata\N*.dbf > wzzip G:\Zip\F\proddata\O.zip G:\Oracle_Backup\F\proddata\O*.dbf > wzzip G:\Zip\F\proddata\P.zip G:\Oracle_Backup\F\proddata\P*.dbf > wzzip G:\Zip\F\proddata\Q.zip G:\Oracle_Backup\F\proddata\Q*.dbf > wzzip G:\Zip\F\proddata\R.zip G:\Oracle_Backup\F\proddata\R*.dbf > wzzip G:\Zip\F\proddata\S.zip G:\Oracle_Backup\F\proddata\S*.dbf > wzzip G:\Zip\F\proddata\T.zip G:\Oracle_Backup\F\proddata\T*.dbf > wzzip G:\Zip\F\proddata\U.zip G:\Oracle_Backup\F\proddata\U*.dbf > wzzip G:\Zip\F\proddata\V.zip G:\Oracle_Backup\F\proddata\V*.dbf > wzzip G:\Zip\F\proddata\W.zip G:\Oracle_Backup\F\proddata\W*.dbf > wzzip G:\Zip\F\proddata\X.zip G:\Oracle_Backup\F\proddata\X*.dbf > wzzip G:\Zip\F\proddata\Y.zip G:\Oracle_Backup\F\proddata\Y*.dbf > wzzip G:\Zip\F\proddata\Z.zip G:\Oracle_Backup\F\proddata\Z*.dbf > # Drive I > wzzip G:\Zip\I\proddata\A.zip G:\Oracle_Backup\I\proddata\A*.dbf > wzzip G:\Zip\I\proddata\B.zip G:\Oracle_Backup\I\proddata\B*.dbf > wzzip G:\Zip\I\proddata\C.zip G:\Oracle_Backup\I\proddata\C*.dbf > wzzip G:\Zip\I\proddata\D.zip G:\Oracle_Backup\I\proddata\D*.dbf > wzzip G:\Zip\I\proddata\E.zip G:\Oracle_Backup\I\proddata\E*.dbf > wzzip G:\Zip\I\proddata\F.zip G:\Oracle_Backup\I\proddata\F*.dbf > wzzip G:\Zip\I\proddata\G.zip G:\Oracle_Backup\I\proddata\G*.dbf > wzzip G:\Zip\I\proddata\H.zip G:\Oracle_Backup\I\proddata\H*.dbf > wzzip G:\Zip\I\proddata\I.zip G:\Oracle_Backup\I\proddata\I*.dbf > wzzip G:\Zip\I\proddata\J.zip G:\Oracle_Backup\I\proddata\J*.dbf > wzzip G:\Zip\I\proddata\K.zip G:\Oracle_Backup\I\proddata\K*.dbf > wzzip G:\Zip\I\proddata\L.zip G:\Oracle_Backup\I\proddata\L*.dbf > wzzip G:\Zip\I\proddata\M.zip G:\Oracle_Backup\I\proddata\M*.dbf > wzzip G:\Zip\I\proddata\N.zip G:\Oracle_Backup\I\proddata\N*.dbf > wzzip G:\Zip\I\proddata\O.zip G:\Oracle_Backup\I\proddata\O*.dbf > wzzip G:\Zip\I\proddata\P.zip G:\Oracle_Backup\I\proddata\P*.dbf > wzzip G:\Zip\I\proddata\Q.zip G:\Oracle_Backup\I\proddata\Q*.dbf > wzzip G:\Zip\I\proddata\R.zip G:\Oracle_Backup\I\proddata\R*.dbf > wzzip G:\Zip\I\proddata\S.zip G:\Oracle_Backup\I\proddata\S*.dbf > wzzip G:\Zip\I\proddata\T.zip G:\Oracle_Backup\I\proddata\T*.dbf > wzzip G:\Zip\I\proddata\U.zip G:\Oracle_Backup\I\proddata\U*.dbf > wzzip G:\Zip\I\proddata\V.zip G:\Oracle_Backup\I\proddata\V*.dbf > wzzip G:\Zip\I\proddata\W.zip G:\Oracle_Backup\I\proddata\W*.dbf > wzzip G:\Zip\I\proddata\X.zip G:\Oracle_Backup\I\proddata\X*.dbf > wzzip G:\Zip\I\proddata\Y.zip G:\Oracle_Backup\I\proddata\Y*.dbf > wzzip G:\Zip\I\proddata\Z.zip G:\Oracle_Backup\I\proddata\Z*.dbf > > nah yang suka corrupt itu APD01.DBF yang ada di drive I > > thx > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Yoel < > [EMAIL PROTECTED]> wrote: > > > > detail plz. :) > > bisa kasih liat backup scriptnya? > > > > > > On 7/21/06, Ahmad Zakki <[EMAIL PROTECTED]> wrote: > > > > > > Dear all, > > > Aplikasi : Oracle Finance 11.5.7 > > > Database : 8.1.7.3 > > > > > > saya coba buat script backup datafile dengan cara cold backup, > tapi ada > > > begitu database di start open selalu muncul error yang bilang kalo > > > datafile APD01.DBF itu error dan perlu untuk di recover. > > > waktu kemaren hal ini bisa di tangani dan perkiraan mungkin hanya > file > > > yang corrupt, tapi pagi ini setelah di backup terjadi lagi. ada > yang > > > tau gak pemecahannya > > > > > > thx > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/7EuRwD/fOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
