Shulou(Shulou.com)06/01 Report--

1. Add temporary files SQL > create temporary tablespace temp_1 tempfile'+ datadg' size 10m to the main library Tablespace created.SQL > alter system archive log current;System altered.col file_name for A50 to set lines 150select file_name,tablespace_name from dba_temp_files FILE_NAME TABLESPACE_NAME----+ DATADG/ORCL/TEMPFILE/temp.265.954623079 TEMP+DATADG/ORCL/TEMPFILE/temp_1.605.963692313 TEMP_1SQL > 2. Check the repository SQL > select open_mode from vested database ONLY WITH APPLYSQL > col file_name for A50 position SQL > set lines 150SQL > select file_name,tablespace_name from dba_temp_files FILE_NAME TABLESPACE_NAME----+ DATADG/ORCLDG/TEMPFILE/temp.406.962961491 TEMPSQL >-- View the database log * WARNING: The following temporary tablespaces contain no files. This condition can occur when a backup controlfile has been restored. It may be necessary to add files to these tablespaces. That can be done using the SQL statement: ALTER TABLESPACE ADD TEMPFILE Alternatively, if these temporary tablespaces are no longer needed, then they can be dropped. Empty temporary tablespace: TEMP_1**** solution repository directly add a temporary file 3. Prepare the database to execute SQL > alter tablespace temp_1 add tempfile'+ datadg' size 10m Tablespace altered.SQL > col file_name for A50 Singapore SQL > set lines 150SQL > select file_name,tablespace_name from dba_temp_files FILE_NAME TABLESPACE_NAME----+ DATADG/ORCLDG/TEMPFILE/temp.406.962961491 TEMP+DATADG/ORCLDG/TEMPFILE/temp_1.342.963694567 TEMP_1 restart the standby library Check the alarm log and there is no error.

Summary

1. Temporary tablespaces are added to the main library, and tablespace information exists in the standby database data dictionary.

two。 There are no temporary file records in the repository dba_temp_files data dictionary.

3. Add a temporary file directly to the slave open status.

The file management mode of 4.ADG is different from that of stand-alone and RAC, so we need to test it more.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.