1.主库添加临时文件
SQL> create temporary tablespace temp_1 tempfile '+datadg' size 10m;
Tablespace created.
SQL> alter system archive log current;
System altered.
col file_name for a50;
set lines 150
select 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_1
SQL>
2.查看备库
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
SQL> col file_name for a50;
SQL> set lines 150
SQL> select file_name,tablespace_name from dba_temp_files;
FILE_NAME TABLESPACE_NAME
-------------------------------------------------- ------------------------------
+DATADG/ORCLDG/TEMPFILE/temp.406.962961491 TEMP
SQL>
--查看备库日志
*********************************************************************
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 <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP_1
*********************************************************************
解决方法
备库直接添加一个临时文件
3.备库执行
SQL> alter tablespace temp_1 add tempfile '+datadg' size 10m;
Tablespace altered.
SQL> col file_name for a50;
SQL> set lines 150
SQL> 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
重启备库,查看告警日志,无报错。
小结
1.主库添加临时表空间,备库数据字典存在表空间信息。
2.备库dba_temp_files数据字典不存在临时文件记录。
3.备库open状态直接添加一个临时文件即可。
4.ADG的文件管理方式和单机、RAC管理方式不同,需要大家多去测试。
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。