¶ÔoracleÊý¾Ý¿âÖеÄÊý¾Ý±í½øÐб¸·Ý
public ActionForward backUpAction(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
Calendar cDay = Calendar.getInstance();
SimpleDateFormat myf = new SimpleDateFormat("yyyyMMddHHmmss");
String day = myf.format(cDay.getTime());
// »ñµÃConstantÖж¨ÒåµÄÊý¾Ý¿â±¸·ÝÎļþ´æ·Å·¾¶£¬¸ñʽÈ磺
// public static final String DataBaseBackUpPath = "D:\\sOADB\\";
String outputFile = Constant.DataBaseBackUpPath;
// Èç¹û·þÎñÆ÷¶ËÓ²ÅÌÉϲ»´æÔÚoutputFileĿ¼£¬Ôò´´½¨Õâ¸öĿ¼
File mydir = new File(outputFile);
if (!(mydir.exists())) {
mydir.mkdir();
}
// ±¸·ÝÎļ
Ïà¹ØÎĵµ£º
1 ²é¿´oracleµÄ°æ±¾ÐÅÏ¢
£¨1£©Óÿͻ§¶ËÁ¬½Óµ½Êý¾Ý¿â£¬Ö´ÐÐselect * from v$instance
²é¿´versionÏî
£¨2£©select * from product_component_version
£¨3£©»ò²éѯV$VERSION²é¿´×é¼þ¼¶ÐÅÏ¢ ......
ÔÚÆô¶¯oracle·þÎñʱ,Ê×ÏÈ»áÔÚ·þÎñ¶ËÕÒ
1.spfile<sid>.ora
ÓÃÓÚÆô¶¯Àý³Ì,Èç¹ûÕÒ²»µ½spfile<sid>.ora,ÔòʹÓ÷þÎñ¶ËȱʡµÄ
2.spfile
À´Æô¶¯,Èç¹ûȱʡµÄspfileÒ²ÕÒ²»µ½,ÔòʹÓÃ
3.init<sid>.ora
À´Æô¶¯Àý³Ì,×îºóÔòÊÇʹÓÃȱʡµÄ
4.pfile
.µ±È»ÄãÒ²¿ÉÒÔÖ¸¶¨pfileÀ´¸²¸ÇȱʡspfileÆô¶¯Àý³Ì,»òͨ¹ýspfile= ......
Oracle ±íɾ³ý´óÁ¿Êý¾Ýºó£¬¼´Ê¹±íÖÐÖ»Óм¸ÐмǼ£¬µ«ÓÃselect count(*) from table À´²éѯ·¢¾õ¶¼²»»áÂíÉϳöÀ´£¬ÔÒòÊǸñíµÄ¿Õ¼ä´óÁË£¬²éѯÆðÀ´ºÜÂý¡£½â¾öµÄ·½·¨ÊǰѸñíËùÕ¼Óõıí¿Õ¼äËõС£¬»òÕß˵Êͷűí¿Õ¼ä¡£
alter table XXXX move; ÕâÑù´¦Àíºó¾ÍÊÍ·ÅÁ˱í¿Õ¼äÁË¡£µ«ÊÇÊͷűí¿Õ¼äºó£¬±íµÄÐкÅrowid»á·¢Éú±ä»¯£¬¶ø»ùÓÚ ......