数据库在手工热备份的过程中出现停电,如何解决?

郑全

数据库在手工热备份的过程中出现停电,如何解决?

1.首先启动数据库在mount状态,

2.检查目前哪些表空间处于备份模式

select a.name,b.status
from v$datafile a, v$backup b
where a.file#=b.file# and b.status='ACTIVE';

or

select a.tablespace_name,a.file_name,b.status
from dba_data_files a,v$backup b
where a.file_id=b.file#
and b.status='ACTIVE';

3.结束备份

This statement lists files with ACTIVE status. If the file is in ACTIVE state,
the corresponding tablespace is in backup mode.

The second statement gives the tablespace name also,
but this can't be used unless the database is open.

You need to end the backup mode of the tablespace with the following command:

alter tablespace tablespace_name end backup;

4.启动数据库