Problem solved. Ternyata timing backup dengan timing start database agak
dekat

 

Best regards,

Ahmad Zakki

Information Technology

PT. Mandala Airlines

Phone  : 5665434 

Fax     : 5663789

visit our website : www.mandalaair.com

  _____  

From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Ahmad Zakki
Sent: Monday, July 24, 2006 9:44 AM
To: [email protected]
Subject: [indo-oracle] Re: Datafile Recovery

 

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 indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.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]



--
-----------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/
 


Kirim email ke