Introduction to DB Recovery after Oracle is in hot backup mode shutdown abort

A few days ago, a friend of the group said DB in the beginning of backup mode after shutdown not come up, today said backup recovery test a bit, found that can be up, but the production environment or to pay attention, it is best not to do so.

sql> alter TABLESPACE users begin backup;

Tablespace altered.

sql> shutdown Immediate

Ora-01149:cannot Shutdown-file 4 has online backup set

Ora-01110:data file 4: ' E:oracleoradatatestusers01. DBF '

sql> Shutdown Abort

ORACLE instance shut down.

Sql> Startup

ORACLE instance started.

Total System Global area 1071333376 bytes

Fixed Size 1379384 bytes

Variable Size 901776328 bytes

Database buffers 163577856 bytes

Redo buffers 4599808 bytes

Database mounted.

Ora-10873:file 4 needs to is either taken out of backup mode or media

Recovered

Ora-01110:data file 4: ' E:oracleoradatatestusers01. DBF '

Sql> select status from V$instance;

STATUS

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

Mounted

Sql> select file#,checkpoint_change# from V$datafile;

file# checkpoint_change#

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

1 6277229

2 6277229

4 6277333

5 6277229

Sql>

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45567.htm

Sql> select file#,checkpoint_change# from V$datafile_header;

file# checkpoint_change#

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

1 6277229

2 6277229

4 6277333

5 6277229

--The state here is unknown ERROR

Sql> select * from V$backup;

file# STATUS change# Time

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

1 UNKNOWN ERROR 6277229 16-dec-12

2 UNKNOWN ERROR 6277229 16-dec-12

4 ACTIVE 6277333 16-dec-12

5 Not ACTIVE 6277229 16-dec-12

Sql> alter TABLESPACE users end backup;

Tablespace altered.

Sql> select status from V$instance;

STATUS

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

Mounted

Sql> select * from V$backup;

file# STATUS change# Time

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

1 not ACTIVE 6277229 16-dec-12

2 Not ACTIVE 6277229 16-dec-12

4 Not ACTIVE 6277333 16-dec-12

5 Not ACTIVE 6277229 16-dec-12

Sql> select file#,checkpoint_change# from V$datafile;

file# checkpoint_change#

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

1 6277229

2 6277229

4 6277333

5 6277229

Sql> select file#,checkpoint_change# from V$datafile_header;

file# checkpoint_change#

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

1 6277229

2 6277229

4 6277333

5 6277229

sql> ALTER DATABASE open;

Database altered.

Sql>