ocp課件v1dbaii-19.空間管理

Oracle——ManagingOracle——ManagingSpacefortheOracle——Objectives?AftercompletingOracle——Objectives?Aftercompletingthislesson,youshouldbeable–Describetheconceptsanduseof4KB-sector描述的概念，并使用4KB扇區(qū)磁盤UsetransportabletablespaDescribetheconceptsoftransportable––Oracle——DatabaseRedologSharedslogfilessDatalogfilesOracle——DatabaseRedologSharedslogfilessDatalogfilesOracle——4-KB–Emulation?NativeLogicalPhysicalOracle——4-KB–Emulation?NativeLogicalPhysical4,096-bytephysical4,096-bytephysicalOracle——4-KB?Emulation?Native–mended4-KBblocksizeforlogsmended4-KBblocksize(orOracle——4-KB?Emulation?Native–mended4-KBblocksizeforlogsmended4-KBblocksize(orlarger)fordatafiles–Mandatory4-KBblocksizeforlogsMandatory4-KBblocksize(orlarger)fordata––Not?Controllocksize:16logfileslogfilesDataOracle——用SECTOR_SIZE和BLOCKSIZE語句––––CREATEOracle——用SECTOR_SIZE和BLOCKSIZE語句––––CREATEALTERDefaultsizeonhardware(notr512-CREATEDATABASEsampleNORESETLOGSFORCELOGGINGGROUP1SIZEGROUP2'$ORACLE_BASE/oradata/sample/redo02.log‘SIZE100MBLOCKSIZEBLOCKSIZEOracle——––Solaris[tm]OE（32位）HP-UX（64位）WindowsIA（64位）Solaris[tm]OE（64位）HPTru64Oracle——––Solaris[tm]OE（32位）HP-UX（64位）WindowsIA（64位）Solaris[tm]OE（64位）HPTru64IBMzSeriesHP-UXIA（64位適用AMD64WindowsIA（32位）LinuxIA（32位）LinuxIA（64位AppleMacAIX的系統(tǒng)（64位）HPOpenWindows64HPIAOpenSolarisx86erOracle——–––。。讀/讀/Oracle——–––。。讀/讀/讀/Oracle——––。。最低兼容Oracle——––。。最低兼容性設源數(shù)據(jù) 目標數(shù)據(jù)移動基于相 的數(shù)據(jù) 表空間的數(shù)據(jù)庫 大小與目標數(shù)據(jù)庫不基于不 的數(shù)據(jù) Oracle——源endian否是將表空間置于讀/Oracle——源endian否是將表空間置于讀/le——Endian源SELECTle——Endian源SELECT v$transportable_platformtp,v$databasedWHEREtp.platform_name=d.platform_name;Oracle——?–––轉(zhuǎn)表空間Oracle——?–––轉(zhuǎn)表空間數(shù)據(jù)文件SQL'ALTERTABLESPACEhrREADONLY';CONVERTTABLESPACEhrTOPLATFORM'Solaris[tm]OE(64-bit)'FORMAT'/tmp/transport_to_solaris/%U';;Oracle——Oracle——Oracle——Oracle——Oracle——Oracle——Oracle——–––。相同的endianYXOracle——–––。相同的endianYXOracle——COMPATIBLE=10.0.0只 只Oracle——COMPATIBLE=10.0.0只 只TO只 只Oracle——COMPATIBLE=10.0.0 ONOrac