ʹÓÃRmanʵÏÖoracleÊý¾Ý¿âµÄ±¸·Ý»¹Ô
´ò¿ªRman
·½·¨1£º¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë”rman£¬»Ø³µ£¬´ò¿ªrmanÃüÁîÐÐÌáʾ´°¿Ú£¬ÊäÈ룺connect target;Á¬½ÓÉÏÊý¾Ý¿â£¬½ÓÏÂÀ´¾Í¿ÉÒÔ½øÐвÙ×÷ÁË¡£
·½·¨2£º¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë” rman target username/userpwd@Orcl £¬£¨ºìÉ«×ÖÌå±íʾÊý¾Ý¿âʵÀýÃû£©»Ø³µ£¬´ò¿ªµÄrmanÃüÁîÐд°¿Ú£¬ÒѾÁ¬½ÓÉÏÊý¾Ý¿âÁË£¬½ÓÏÂÀ´¾Í¿ÉÒÔÖ±½Ó½øÐвÙ×÷ÁË
±¸·ÝÊý¾Ý¿â
ÔÚÃüÁîÐÐģʽÏ£¬ÊäÈëÒÔÏÂÃüÁ
backup as copy database;
//´ËÃüÁî±íʾ¶ÔÊý¾Ý¿â½øÐÐÍêÈ«±¸·Ý£¬Ä¬ÈÏÇé¿öÏÂÊý¾Ý¿â´¦ÔÚ“·Ç¹éµµÄ£Ê½”Ï¡£ÔÚÖ´ÐÐÉÏÃæµÄ
//ÃüÁîʱ£¬»á³öÏÖÏÂÃæµÄ´íÎó“ÎÞ·¨°´ noarchivelog ģʽ±¸·Ý»ò¸´ÖÆÎļþ”£¬Õë¶ÔÕâ¸ö´íÎ󣬿ÉÒÔ°´ÏÂÃæµÄ·½Ê½½â¾ö¡£
¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë” sqlplus / as sysdba£¬»Ø³µ£¬ÒÔ¹ÜÀíÔ±µÄÉí·ÝÁ¬½ÓÊý¾Ý¿â£¬ÒÀ´ÎÖ´ÐÐÒÔÏÂÃüÁ
shutdown immediate //¹Ø±ÕÊý¾Ý¿â
startup mount //Æô¶¯Êý¾Ý¿âµ½“×°Ôؔ״̬
alter database archivelog //ÐÞ¸ÄÊý¾Ý¿âΪ“¹éµµÄ£Ê½”
alter database open //´ò¿ªÊý¾Ý¿â
È»ºó£¬Ôٻص½Rman¡£Ö´ÐÐbackup²Ù×÷
backup database;
´Ëʱ³öÏÖÁËÁíÒ»¸ö´íÎó£ºora-19809:³¬³öÁ˻ָ´ÎļþÊýµÄÏÞÖÆ
ora-19804:ÎÞ·¨»ØÊÕ 52428800 ×Ö½Ú´ÅÅÌ¿Õ¼ä ´Ó<2147483648ÏÞÖÆÖÐ>
½â¾ö°ì·¨1£ºÍ¨¹ýSqlplusÒÔ¹ÜÀíÔ±µÄÉí·ÝÁ¬½ÓOracleÊý¾Ý¿â£¬Ö´ÐÐÏÂÃæµÄÃüÁ
show parameter db_recovery_file_dest_size; //ĬÈÏÊÇ2G
alter system set db_recovery_file_dest_size=4G; //Ôö´ó¿Õ¼äºó£¬±¸·Ý³É¹¦¡£
½â¾ö°ì·¨2£º¸Ä±ä±¸·Ý·¾¶
backup database format 'd:\oracle\backup\%U.dbf'
plus archivelog format 'd:\oracle\backup\%U.arc';
±¸·ÝѹËõ¹¦ÄÜ
¿ÉÒÔÑ¡ÔñÔÚ±¸·ÝÃüÁîÀïÏÔʾָ¶¨Ñ¹ËõÑ¡Ïî:
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
--½ö¶Ô1,5ÎļþѹËõ±¸·Ý
BACKUP AS COMPRESSED BACKUPSET DATAFILE 1,5;
Ò²¿ÉÒÔÅäÖÃRMANÖ¸¶¨Ñ¹ËõÑ¡Ïî:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
--±¸·ÝѹËõµ½Ö¸¶¨Â·¾¶
backup as Compressed backupset database format 'd:\oracle\backup\%U.dbf'
plus archivelog for
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
String sql = "select t.FILE_INFO from T_FILE_DB_DETAIL t where t.id= "
+ fileDBUpDownDetail.getId() + " for update";
rs = stmt.executeQuery(sql);
if (rs.next()) {
// ÔÚweblogicϲ¿Êðʱ£¬ÐèÒª¸ü¸ÄΪBea We ......
Oracle SQLÓëANSI SQLÇø±ð
ÏàÐÅ´ó¼Ò¶¼Ê¹ÓùýSQL SERVER¡£½ñÌì¸ø´ó¼Ò¼òµ¥½éÉÜÒ»ÏÂOracle SQLÓëANSI SQLÇø±ð¡£Æäʵ£¬SQL SERVERÓëÓëANSI SQLÒ²ÓÐÇø±ð¡£
1¡¢Ê×ÏÈ´ó¼ÒÒªÃ÷°×ʲôÊÇANSI
ANSI£ºÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨American National Standards Institute£©¡£µ±Ê±£¬ÃÀ¹úµÄÐí¶àÆóÒµºÍרҵ¼¼ÊõÍÅÌ壬ÒÑ¿ªÊ¼Á˱ê×¼»¯¹¤×÷£¬µ«Òò±Ë ......
SELECT * from ALL_SOURCE
where TYPE='PROCEDURE' AND TEXT LIKE
'%0997500%';
--²éѯALL_SOURCEÖУ¬£¨½Å±¾´úÂ룩ÄÚÈÝÓë0997500Ä£ºýÆ¥ÅäµÄÀàÐÍΪPROCEDURE£¨´æ´¢¹ý³Ì£©µÄÐÅÏ¢¡£
¸ù¾ÝGROUP
BY TYPE
¸ÃALL_SOURCEÖÐÖ»ÓÐÒÔÏÂ5ÖÖÀàÐÍ
1 FUNCTION
2 JAVA
SOURCE
3 PACKAGE
4 P ......
Ò»£ºSQL Loader µÄÌصã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄǨÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌص㡣
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµ ......