ORACLE±¸·ÝÖеÄѹËõ
ĬÈϵÄÇé¿öÏ£¬Èç¹ûûÓÐÅäÖÃѹËõ±¸·Ý£¬»òÕß±¸·ÝµÄʱºòûÓз¢³öcompressed ÃüÁÄÇôORACLE»á²ÉÓÃNULLÊý¾Ý¿éµÄѹËõ·½·¨À´±¸·ÝÊý¾Ý¿â£¬²ÉÓÃÕâÖÖ·½·¨±¸·Ý£¬ORACLE¾Í²»»á±¸·Ý´ÓδʹÓùýµÄÊý¾Ý¿é¡£ÁíÍâÒ»ÖÖ±¸·Ý¾ÍÊDzÉÓÃcompressedÃüÁîѹËõ±¸·Ý£¬²ÉÓÃÕâÖÖ·½·¨£¬ORACLE»áʹÓÃѹËõËã·¨À´±¸·ÝÊý¾Ý£¬Í¨³£»áѹËõ´óÔ¼70%¡£11gµÄ±¸·ÝÓÖÓÐÁËÌá¸ß£¬ÌرðÊǶÔÓÚUNDO±í¿Õ¼äµÄ±¸·Ý£¬ÕâÀï²»×öÌÖÂÛ£¬ÏÂÃæÀ´±È½ÏÒ»ÏÂNULLÊý¾Ý¿éµÄѹËõ±¸·ÝÓëCOMPRESSEDѹËõ±¸·Ý
RMAN> show all;
RMAN ÅäÖòÎÊýΪ:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF; ---ûÓÐÉèÖÿØÖÆÎļþ×Ô¶¯±¸·Ý
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default -----ûÓÐÅäÖÃCOMPRESSED
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFROBINSON.ORA'; # default
RMAN> backup database; ----ÆÕͨµÄ±¸·Ý(NULLÊý¾Ý¿éѹËõ)
Æô¶¯ backup ÓÚ 30-10ÔÂ-09
·ÖÅäµÄͨµÀ: ORA_DISK_1
ͨµÀ ORA_DISK_1: sid=147 devtype=DISK
ͨµÀ ORA_DISK_1: Æô¶¯È«²¿Êý¾ÝÎļþ±¸·Ý¼¯
ͨµÀ ORA_DISK_1: ÕýÔÚÖ¸¶¨±¸·Ý¼¯ÖеÄÊý¾ÝÎļþ
ÊäÈëÊý¾ÝÎļþ fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_UNDOTBS1_5CLYNO9G_.DBF
ÊäÈëÊý¾ÝÎļþ fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_SYSTEM_5CLYNO0Q_.DBF
ÊäÈëÊý¾ÝÎļþ fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_SYSAUX_5CLYNO3J_.DBF
ÊäÈëÊý¾ÝÎļþ fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_ROBINSON_5CMKM0DV_.DBF
ÊäÈëÊý¾ÝÎļþ fno=
Ïà¹ØÎĵµ£º
1¡¢ÅäÖÃhibernate£º
1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ
org.springframework.orm.hibernate3.support.BlobByteArray ......
Êý¾Ý¿â¶ÔÏó
<1>±í(Ô¼Êø)
<2>ÈçºÎ×Ô¶¯±àºÅ
SQLserver
--IDENTITYÊôÐÔ
create table test(
xh int identity(1,2) primary key,
name varchar(20)
);
insert into test(name) values ('mike');
ORACLE
Ò»¸ö¶ÔÏó(ÐòÁÐsequenc ......
ÓÃ;: <1>Ä£¿é»¯
<Àý×Ó> --¹«Ë¾µÄÔ±¹¤µÄ¹ÜÀí
1.Ôö¼ÓÒ»¸öÔ±¹¤
2.Ô±¹¤ÀëÖ°
Óô洢¹ý³ÌºÍº¯ÊýÀ´ÊµÏÖ
1.Ôö¼ÓÒ»¸öÔ±¹¤
create sequence seq1 start with 7935;
create or replace function insert ......
ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓᣡ¡¡¡ ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ ......