oracle 11g b表空间什么情况下自动增加,ORACLE 11G 扩展表空间增加数据文件导致DG日志应用失败...

ORACLE 11G 扩展表空间增加数据文件导致DG日志应用失败

SQL> select sequence#, first_time, next_time, applied from v$archived_log where applied='NO' order by sequence# ;

SEQUENCE# FIRST_TIME          NEXT_TIME           APPLIED

---------- ------------------- ------------------- ---------

5854 2017-03-07 09:45:15 2017-03-07 10:25:32 NO

5855 2017-03-07 10:25:32 2017-03-07 11:07:54 NO

5856 2017-03-07 11:07:54 2017-03-07 13:11:58 NO

5857 2017-03-07 13:11:58 2017-03-07 13:53:35 NO

5858 2017-03-07 13:53:35 2017-03-07 13:56:08 NO

5859 2017-03-07 13:56:08 2017-03-07 13:57:02 NO

7934 2017-03-07 10:11:37 2017-03-07 10:25:29 NO

7935 2017-03-07 10:25:29 2017-03-07 10:39:35 NO

7936 2017-03-07 10:39:35 2017-03-07 10:53:36 NO

7937 2017-03-07 10:53:36 2017-03-07 11:07:53 NO

7938 2017-03-07 11:07:53 2017-03-07 11:22:17 NO

SEQUENCE# FIRST_TIME          NEXT_TIME           APPLIED

---------- ------------------- ------------------- ---------

7939 2017-03-07 11:22:17 2017-03-07 12:01:19 NO

7940 2017-03-07 12:01:19 2017-03-07 13:11:57 NO

7941 2017-03-07 13:11:57 2017-03-07 13:26:16 NO

7942 2017-03-07 13:26:16 2017-03-07 13:39:49 NO

7943 2017-03-07 13:39:49 2017-03-07 13:53:34 NO

7944 2017-03-07 13:53:34 2017-03-07 13:56:11 NO

7945 2017-03-07 13:56:11 2017-03-07 13:56:17 NO

18 rows selected.

alert日志报错如下：

Errors in file /home/db/oracle/diag/rdbms/shdbdg/shdbdg/trace/shdbdg_pr00_13185.trc:

ORA-01119: error in creating database file '+DATADG/db/trade07.dbf'

ORA-17502: ksfdcre:4 Failed to create file +DATADG/db/trade07.dbf

ORA-15001: diskgroup "DATADG" does not exist or is not mounted

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Synchronization Service

File #13 added to control file as 'UNNAMED00013'.

处理过程如下：

ALTER SYSTEM SET db_create_file_dest='/home/db/oracle/oradata/shassdbdg' SCOPE=BOTH;

shutdown immediate

startup mount

alter database recover managed standby database disconnect from session

Errors in file /home/db/oracle/diag/rdbms/shassdbdg/shassdbdg/trace/shassdbdg_pr00_20795.trc:

ORA-01111: name for data file 13 is unknown - rename to correct file

ORA-01110: data file 13: '/app/oracle/ora11g/dbs/UNNAMED00013'

ORA-01157: cannot identify/lock data file 13 - see DBWR trace file

ORA-01111: name for data file 13 is unknown - rename to correct file

ORA-01110: data file 13: '/app/oracle/ora11g/dbs/UNNAMED00013'

Completed: alter database recover managed standby database disconnect from session

Recovery Slave PR00 previously exited with exception 1111

MRP0: Background Media Recovery process shutdown (shassdbdg)

Tue Mar 07 13:56:33 2017

Archived Log entry 13168 added for thread 1 sequence 7944 ID 0xf2cfba52 dest 1:

Tue Mar 07 13:57:02 2017

Primary database is in MAXIMUM PERFORMANCE mode

ALTER DATABASE RECOVER  managed standby database cancel

ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH;

alter database create datafile  '/app/oracle/ora11g/dbs/UNNAMED00013' as '/home/db/oracle/oradata/shass

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;

ALTER DATABASE RECOVER  managed standby database using current logfile disconnect from session