首页 > Linux操作系统 > Linux操作系统 > 手动热备份异常关机的处理
SQL> alter tablespace users begin backup;
Tablespace altered.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 440401920 bytes
Fixed Size 2021408 bytes
Variable Size 130025440 bytes
Database Buffers 306184192 bytes
Redo Buffers 2170880 bytes
Database mounted.
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: '/u01/app/oracle/oradata/XUHM/users01.dbf'
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 ACTIVE 633476 16-OCT-12
5 NOT ACTIVE 0
SQL> alter tablespace users end backup;
Tablespace altered.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 NOT ACTIVE 633476 16-OCT-12
5 NOT ACTIVE 0
SQL> alter database open;
Database altered.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26655292/viewspace-746580/ ,如需转载,请注明出处,否则将追究法律责任。