system表空间管理及备份恢复

《system表空间管理及备份恢复》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、SYSTEM表空间管理及备份恢复SYSTEMtablespacemanagementandbackuprecoveryPersonalclassification:OracleBackup&recoverSYSTEMtablespacemanagementandbackuprecoveryTheSYSTEMtablespaceisoneofthemostimportantOracledatabasetablespace,storageoftheDDLlanguageinformationandPL/SQLpacka

2、ges,views,functions,procedures,etc・，calledthedatadictionary,Thistablespacealsohasitsownparticularity,whichdescribestherelevantfeaturesandbackupandrecoveryofSYSTEMtableSpaces・ManagementofSYSTEMtableSpacesItisrecommendedthatnouserdatabestoredtoavoidusererrorscau

3、singthesystemtablespacetobeunavailableYoushouldsetthedefaultdefaulttablespaceforthesystemtopreventusercreationfromusingsystemtableSpacesALTERDATABASEDEFAULTTABLESPACEtablespacenameSQL>colpropertyvalueformata30SQL>selectproperty_nameproperty_valuefromdatabase_p

4、ropertiesWhereproperty_namelike'DEFAULT%';PROPERTY_NAMEPROPERTY_VALUEDEFAULT_TEMP_TABLESPACETEMPDEFAULT_PER1ANENT_TABLESPACEUSERS―thisshouldbeanon-systemtablespaceDEFAULT_TBS_TYPESMALLFILESYSTEMtablespacefeaturesNoofflineofflineNoread-onlyreadonlyCannotrename

5、Can，tdelete——thedemocan'tbeofflineSQL>altertablespacesystemoffline;Altertablespacesystemoffline*TheERRORatline1:ORA01541:systemtablespacecannotbebroughtoffline;ShutdownifnecessarySQL>alterdatabasedatafile1offline;Alterdatabasedatafile1offline*TheERRORatline1:O

6、RA01541:systemtablespacecannotbebroughtoffline;ShutdownifnecessaryCannotberead-onlySQL>altertablespacesystemreadonly;Altertablespacesystemreadonly*TheERRORatline1:ORA一01643:systemintablespacecannotbemadereadonly——norenameSQL>altertablespacesystemrenametosystem

7、2;Altertablespacesystemrenametosystem2*TheERRORatline1:ORA-00712:alwaysrenamesystemintablespaceYoucan，tdeleteitSQL>droptablespacesystem;Droptablespacesystem*TheERRORatline1:ORA-01550:cannotdropsystemintablespaceSQL>droptablespacesystemocontentsanddatafiles:Dro

8、ptablespacesystemocontentsanddatafilesTheERRORatline1:ORA-01550:cannotdropsystemtablespacSummary:thesystemtablespaceisasentenee,thenameofacommontablespacehasthenamechange,delete,re