alter database recover managed standby database cancel;
alter system set standby_file_management=MANUAL SID='*';
6.3. 将数据文件RENAME到备库的ASM磁盘路径中,不成功,报错如下:
SQL> alter database rename file '+DG_DATA02/racdb/blsp_temp.dbf' to '+DG_DDATA_02/racdbdg/datafile/blsp_temp.dbf';
alter database rename file '+DG_DATA02/racdb/blsp_temp.dbf' to '+DG_DDATA_02/racdbdg/datafile/blsp_temp.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 226 - new file '+DG_DDATA_02/racdbdg/datafile/blsp_temp.dbf' not found
ORA-01110: data file 226: '+DG_DATA02/racdb/blsp_temp.dbf'
ORA-17503: ksfdopn:2 Failed to open file +DG_DDATA_02/racdbdg/datafile/blsp_temp.dbf
ORA-15173: entry 'blsp_temp.dbf' does not exist in directory 'datafile'
SQL>
6.4. 在临时表空间里面新添加一个数据文件,成功
SQL> alter tablespace BLSP_TEMP add tempfile '+DG_DDATA_02/racdbdg/datafile/blsp_temp02.dbf' size 10240M;
Tablespace altered.
SQL>
查询临时表空间,还是报错
SQL> select file_id,file_name,bytes/1024/1024 MB,status,tablespace_name from dba_temp_files where file_name like '%blsp_temp%';
select file_id,file_name,bytes/1024/1024 MB,status,tablespace_name from dba_temp_files where file_name like '%blsp_temp%'
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 226 - see DBWR trace file
ORA-01110: data file 226: '+DG_DATA02/racdb/blsp_temp.dbf'
SQL>
这时候,再去删除报错的数据文件,成功
SQL> alter tablespace BLSP_TEMP drop tempfile '+DG_DATA02/racdb/blsp_temp.dbf';
Tablespace altered.
SQL>
查询表空间信息,正常
SQL> select file_id,file_name,bytes/1024/1024 MB,status,tablespace_name from dba_temp_files where file_name like '%blsp_temp%';