oracle怎么关闭联机备份,Oracle表空间正在热备份时关闭实例重启报错的重现和解决...

11.2.0.4.0 版本表空间正在热备份时关闭实例重启报错的重现和解决:

-->11G此问题的报错信息比10G更清楚，根据报错信息就有了基本的判断方向。

SQL> select * from v$backup;

FILE# STATUS                CHANGE# TIME

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

1 NOT ACTIVE                  0

2 NOT ACTIVE                  0

3 NOT ACTIVE                  0

4 NOT ACTIVE                  0

5 NOT ACTIVE                  0

6 NOT ACTIVE            1149659 2014/11/11 21:49:55

7 NOT ACTIVE                  0

7 rows selected.

SQL> select sysdate from dual;

SYSDATE

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

2014/11/11 22:05:26

SQL> ALTER TABLESPACE TEST1 BEGIN BACKUP;

Tablespace altered.

SHUTDOWN ABORT实例并重启:

SQL> startup

Oracle instance started.

Total System Global Area  418484224 bytes

Fixed Size                  1365040 bytes

Variable Size             322964432 bytes

Database Buffers           88080384 bytes

Redo Buffers                6074368 bytes

Database mounted.

ORA-10873: file 6 needs to be either taken out of backup mode or media

recovered

ORA-01110: data file 6: '/u01/app/oracle/oradata/bys1/test01.dbf'

此时ALERT日志的报错信息:

Completed: ALTER DATABASE   MOUNT

Tue Nov 11 22:06:36 2014

ALTER DATABASE OPEN

Errors in file /u01/app/oracle/diag/rdbms/bys1/bys1/trace/bys1_ora_3910.trc:

ORA-10873: file 6 needs to be either taken out of backup mode or media recovered

ORA-01110: data file 6: '/u01/app/oracle/oradata/bys1/test01.dbf'

ORA-10873 signalled during: ALTER DATABASE OPEN...

Tue Nov 11 22:06:36 2014

Checker run found 1 new persistent data failures

Tue Nov 11 22:21:36 2014

SQL> select * from v$backup;

FILE# STATUS                CHANGE# TIME

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

1 NOT ACTIVE                  0

2 NOT ACTIVE                  0

3 NOT ACTIVE                  0

4 NOT ACTIVE                  0

5 NOT ACTIVE                  0

6 ACTIVE                1171509 2014/11/11 22:05:40

7 NOT ACTIVE                  0

7 rows selected.

END BACKUP或RECOVER DATAFILE即可

SQL> ALTER TABLESPACE TEST1 end BACKUP;

Tablespace altered.

ALERT日志:

Tue Nov 11 23:00:56 2014

ALTER TABLESPACE TEST1 end BACKUP

Completed: ALTER TABLESPACE TEST1 end BACKUP

Tue Nov 11 23:01:23 2014

RECOVER DATAFILE时的相关日志:

Tue Nov 11 21:51:02 2014

Checker run found 1 new persistent data failures

Tue Nov 11 22:00:46 2014

ALTER DATABASE RECOVER  datafile 6

Media Recovery Start

Serial Media Recovery started

Recovery of Online Redo Log: Thread 1 Group 3 Seq 48 Reading mem 0

Mem# 0: /u01/app/oracle/oradata/bys1/redo03.log

Recovery of Online Redo Log: Thread 1 Group 1 Seq 49 Reading mem 0

Mem# 0: /u01/app/oracle/oradata/bys1/redo01.log

Media Recovery Complete (bys1)

Completed: ALTER DATABASE RECOVER  datafile 6

Tue Nov 11 22:01:01 2014

alter database open

SQL> select * from v$backup;

FILE# STATUS                CHANGE# TIME

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

1 NOT ACTIVE                  0

2 NOT ACTIVE                  0

3 NOT ACTIVE                  0

4 NOT ACTIVE                  0

5 NOT ACTIVE                  0

6 NOT ACTIVE            1171509 2014/11/11 22:05:40

7 NOT ACTIVE                  0

7 rows selected.