Alter TABLESPACE users begin backup;
Power
Startup
Select status from V$instance;
Alter TABLESPACE users end backup;
ALTER DATABASE open;
-----------------------------------------------------
[Email protected]>alter tablespace users begin backup;
Tablespace altered.
[Email Protected]>shutdown abort
ORACLE instance shut down.
[Email Protected]>startup
ORACLE instance started.
Total System Global area 830930944 bytes
Fixed Size 2231048 bytes
Variable Size 616563960 bytes
Database buffers 205520896 bytes
Redo buffers 6615040 bytes
Database mounted.
Ora-10873:file 4 needs to being either taken out of backup mode or media
Recovered
Ora-01110:data file 4: ' +data/ora11g/datafile/users.259.833721555 '
[Email protected]>select status from V$instance;
STATUS
----------
Mounted
[Email protected]>alter tablespace users end backup;
Tablespace altered.
[Email protected]>alter database open;
Database altered.
A sudden power outage when hot backup