SYSTEM 表空间管理及备份恢复(国外英语资料).docVIP

SYSTEM 表空间管理及备份恢复(国外英语资料) SYSTEM table space management and backup recovery Personal classification: Oracle Backup recover = = = = = = SYSTEM table space management and backup recovery = = = = = = The SYSTEM table space is one of the most important Oracle database table space, storage of the DDL language information and PL/SQL packages, views, functions, procedures, etc., called the data dictionary, This table space also has its own particularity, which describes the relevant features and backup and recovery of SYSTEM table Spaces. Management of SYSTEM table Spaces It is recommended that no user data be stored to avoid user errors causing the system table space to be unavailable You should set the default default table space for the system to prevent user creation from using system table Spaces ALTERDATABASEDEFAULTTABLESPACE tablespace_name SQL col property_value format a30 SQL selectproperty_name property_valuefromdatabase_properties Whereproperty_namelike DEFAULT %; PROPERTY_NAME PROPERTY_VALUE -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- DEFAULT_TEMP_TABLESPACE TEMP DEFAULT_PERMANENT_TABLESPACE USERS -- this should be a non-system table space DEFAULT_TBS_TYPE SMALLFILE SYSTEM table space features No offline offline No read-only read only Cannot rename Cant delete -- the demo cant be offline SQL altertablespace system offline; Altertablespace system offline * The ERROR at line 1: ORA 01541: system tablespace cannot be brought offline; Shut downifnecessary SQL alterdatabasedatafile 1 offline; Alterdatabasedatafile 1 offline * The ERROR at line 1: ORA 01541: system tablespace cannot be brought offline; Shut downifnecessary Cannot be read-only SQL altertablespace systemreadonly; Altertablespace systemreadonly * The ERROR at line 1: ORA - 01643: system in tablespace cannotbe madereadonly -- no rename SQL altertablespace system re