When the Oracle tablespace is in hot backup, the instance restart error is disabled to reproduce and solve the problem.

When the Oracle tablespace is in hot backup, the instance restart error is disabled to reproduce and solve the problem.
A recent database of a customer reported an error during OPEN and needed to be restored. The reason was that a TABLESPACE was being hot BACKUP --> alter tablespace TEST1 begin backup; then, the instance is shut down abnormally (it may be ABORT or kill smon, which is said to be caused by direct storage shutdown), and this error occurs when it is restarted. This error is reproduced in Oracle 10.2.0.1 and 11.2.0.4. The error information is not the same in the two versions, as shown in the following figure: in version 10.2.0.1.0, when a hot backup is being performed on a tablespace, the instance restarts and an error is returned and solved: SQL> select * from v $ version where rownum = 1; BANNER login Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod view the STATUS of the data file at this time: SQL> select tablespace_name, STATUS from dba_tablespaces; set linesize 200 set pagesize 200col file_name for a50 Select file_name, tablespace_name, status from region; TABLESPACE_NAME STATUS --------- SYSTEM has been released without using onlineexample onlineindx onlinetools onlineusers onlineoltp using ONLINETEST1 ONLINETEST2 using ONLINE15 rows selected. SQL> FILE_NAME TABLESPACE_NAME STATUS --------------- Certificate certificate ---------/u01/app/PROD/disk1/system01.dbf system available/u01/app/PROD/disk1/undotbs01.dbf undotbs available/u01/app/PROD/disk1/sysaux01.dbf sysaux available/ u01/app/PROD/disk1/example. dbf example available/u01/app/PROD/disk1/indx. dbf indx available/u01/app/PROD/disk1/tools. dbf tools available/u01/app/PROD/disk1/users. dbf USERS AV AILABLE/u01/app/PROD/disk1/oltp. dbf oltp available/u01/app/PROD/disk1/REGISTRATION. dbf registration available/u01/app/PROD/disk1/test1.dbf TEST1 AVAILABLE/u01/app/PROD/disk1/test2.dbf TEST2 AVAILABLE/u01/app/PROD/disk1/paitest3 availablero12 selected. ######################################## ############### 3 --> Issue the Hot Backup tablespace command: SQL> ALTER TABLESPACE TEST1 BEGIN BACKUP; Tablespace altered. --> Query Data File STATUS: SQL> select tablespace_name, STATUS from region; TABLESPACE_NAME STATUS --------- SYSTEM has been released without ONLINEEXAMPLE ONLINEINDX ONLINETOOLS ONLINEUSERS ONLINEOLTP has been released ONLINETEST3 ONLINE15 rows selected. SQL> set linesize 200SQL> set pagesize 200SQL> col file_name A50SQL> select file_name, file_id, tablespace_name, status from dba_data_files; FILE_NAME FILE_ID TABLESPACE_NAME STATUS certificate ---------- certificate ---------/u01/app/PROD/disk1/system01.dbf 1 system available/u01/app/PROD/disk1/quota 2 undotbs available/u01/app/PROD /disk1/sysaux01.dbf 3 sysaux available/u01/app/PROD/disk1/exampl E. dbf 4 example available/u01/app/PROD/disk1/indx. dbf 5 indx available/u01/app/PROD/disk1/tools. dbf 6 tools available/u01/app/PROD/disk1/users. dbf 7 users available/u01/app/PROD/disk1/oltp. dbf 8 oltp available/u01/app/PROD/disk1/REGISTRATION. dbf 9 registration available/u01/app/PROD/disk1/test1.dbf 10 TEST1 AVAILABLE/u01/app/PROD/disk1/test2.dbf 11 TEST2 AVAILABLE/u01/app/PROD/disk1/test3.dbf 12 T EST3 AVAILABLE12 rows selected. 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 0 7 not active 0 8 NOT ACTIVE 0 9 not active 0 10 ACTIVE 195848 22:12:07 11 not active 0 12 not active 012 rows selected. --> you can see that a data file is ACTIVE at this time, combined with dba_d Ata_files, which belongs to the TEST1 tablespace in the hot backup. In this case, start a new session, KILL the SMON process, or use the shutdown abort command to close the database. Shutdown immediate close will prompt: SQL> shutdown immediate; ORA-01149: cannot shutdown-file 10 has online backup setORA-01110: data file 10: '/u01/app/PROD/disk1/test1.dbf' -- the ALERT Log prompts Tue Nov 11 22:50:55 2014 Shutting down instance: further logons disabled

For more details, please continue to read the highlights on the next page:

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

1 2 3 Next Page