Funda 2 > Online Backup Data File - 12 May

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Funda 2 > Online Backup Data File - 12 May as PDF for free.

More details

  • Words: 418
  • Pages: 4
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

Related Documents