sql> sql> sql> sql> shutdown immediate; database closed. database dismounted. oracle instance shut down. sql> startup mount; oracle instance started. total system global area
135338868 bytes
fixed size variable size
453492 bytes 109051904 bytes
database buffers
25165824 bytes
redo buffers
667648 bytes
database mounted. sql> alter tablesapce users offline; alter tablesapce users offline * error at line 1: ora-00940: invalid alter command sql> alter tablespace users offline; alter tablespace users offline * error at line 1: ora-01109: database not open sql> -------- we can't to offline the tablespace sql> sql> ------ but we can offline the datafile sql> sql> alter database datafile 'd:\bkp\users01.dbf' offline; database altered. sql> shutdown immediate; ora-01109: database not open database dismounted. oracle instance shut down. sql> sql> startup; oracle instance started. total system global area fixed size variable size
135338868 bytes 453492 bytes 109051904 bytes
database buffers redo buffers
25165824 bytes 667648 bytes
database mounted. ora-16068: redo log file activation identifier mismatch ora-00312: online log 1 thread 1: 'd:\oracle\oradata\iimdba\redo01.log' sql> select * from v$datafile where ts#=9; file# creation_change# creation_ ts# rfile# status enabled checkpoint_change# checkpoin unrecoverable_change# unrecover last_change# last_time offline_change# online_change# ---------- ---------------- --------- ---------- ---------- ------- --------------------------- --------- --------------------- --------- -------------------- --------------- -------------online_ti bytes blocks create_bytes block_size --------- ---------- ---------- ------------ ---------name -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------plugged_in block1_offset ---------- ------------aux_name -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------9 6401 12-may-02 9 9 offline disabled 325650 12-may-08 0 325650 12-may-08 320886 321333 12-may-08 0 0 0 8192 d:\bkp\users01.dbf 0
4294967295
none
sql> set linesize 200; sql> set pagesize 200; sql> select status,name from v$datafile where ts#=9; status -------
name -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------offline d:\bkp\users01.dbf
sql> alter database datafile 'd:\oracle\oradata\iimdba\users01.dbf' online; alter database datafile 'd:\oracle\oradata\iimdba\users01.dbf' online * error at line 1: ora-01516: nonexistent log file, datafile, or tempfile "d:\oracle\oradata\iimdba\users01.dbf" sql>
alter database datafile 'd:\bkp\users01.dbf' online;
database altered. sql> alter database open; alter database open * error at line 1: ora-01113: file 9 needs media recovery ora-01110: data file 9: 'd:\bkp\users01.dbf' sql> recover datafile; ora-02236: invalid file name sql> recover datafile users01; ora-02236: invalid file name sql> recover tablespace users; ora-00279: change 294480 generated at 05/10/2008 16:21:37 needed for thread 1 ora-00289: suggestion : d:\oracle\bkp7.1 ora-00280: change 294480 for thread 1 is in sequence #7 specify log: {=suggested | filename | auto | cancel} auto ora-00308: cannot open archived log 'd:\oracle\bkp7.1' ora-27041: unable to open file osd-04002: unable to open file o/s-error: (os 2) the system cannot find the file specified. ora-00308: ora-27041: osd-04002: o/s-error:
cannot unable unable (os 2)
open archived log 'd:\oracle\bkp7.1' to open file to open file the system cannot find the file specified.
sql> spool off