Funda 2 > Online Backup 12 -- 13th 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 12 -- 13th May as PDF for free.

More details

  • Words: 900
  • Pages: 6
sql> archive log list database log mode archive mode automatic archival enabled archive destination d:\oracle oldest online log sequence 17 next log sequence to archive 19 current log sequence 19 sql> sql> sql> sql> sql> select name from v$datafile where ts#=9; name -------------------------------------------------------------------------------d:\bkp\users01.dbf sql> sql> alter tablespace users begin backup; alter tablespace users begin backup * error at line 1: ora-01109: database not open 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 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-00310: archived log contains sequence 8; sequence 7 required ora-00334: archived log: 'd:\oracle\bkp7.1' sql> clear screen sql> select name,status from v$datafile where ts$=9; select name,status from v$datafile where ts$=9 * error at line 1: ora-00904: "ts$": invalid identifier sql> ed wrote file afiedt.buf 1* select name,status from v$datafile where ts#=9 sql> /

name -------------------------------------------------------------------------------status ------d:\bkp\users01.dbf online 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 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-00310: archived log contains sequence 8; sequence 7 required ora-00334: archived log: 'd:\oracle\bkp7.1' sql> shutdown immediate; ora-01109: database not open database dismounted. oracle instance shut down. sql> startup; ora-12571: tns:packet writer failure sql> conn sys/oracle as sysdba connected. sql> clear screen sql> select name,status from v4datafile where ts#=9; select name,status from v4datafile where ts#=9 * error at line 1: ora-01219: database not open: queries allowed on fixed tables/views only sql> select name,status from v$datafile where ts#=9; name -------------------------------------------------------------------------------status ------d:\bkp\users01.dbf online sql> alter databse open;

alter databse open * error at line 1: ora-00940: invalid alter command 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 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-00310: archived log contains sequence 18; sequence 7 required ora-00334: archived log: 'd:\oracle\bkp7.1' sql> archive log list; database log mode archive mode automatic archival enabled archive destination d:\oracle oldest online log sequence 17 next log sequence to archive 19 current log sequence 19 sql> alter system switch logfile; alter system switch logfile * error at line 1: ora-01109: database not open sql> alter tablespace users offline; alter tablespace users offline * error at line 1: ora-01109: database not open sql> alter system datafile 'd:\bkp\users01.dbf' offline; alter system datafile 'd:\bkp\users01.dbf' offline * error at line 1: ora-02065: illegal option for alter system sql>

alter database datafile 'd:\bkp\users01.dbf' offline;

database altered.

sql> sql> create tablspace users datafile 'd:\oracle\oradata\iimdba\users01.dbf' size 1m; create tablspace users datafile 'd:\oracle\oradata\iimdba\users01.dbf' size 1m * error at line 1: ora-00901: invalid create command sql> ed wrote file afiedt.buf 1* create tablespace users datafile 'd:\oracle\oradata\iimdba\users01.dbf' size 1m sql> / create tablespace users datafile 'd:\oracle\oradata\iimdba\users01.dbf' size 1m * error at line 1: ora-01109: database not open sql> alter tablespace ; alter tablespace * error at line 1: ora-02140: invalid tablespace name 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 tablespace offline; ora-00931: missing identifier 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-00310: archived log contains sequence 18; sequence 7 required ora-00334: archived log: 'd:\oracle\bkp7.1' sql> shutdown immediate; ora-01109: database not open

database dismounted. oracle instance shut down. sql> startup ora-12571: tns:packet writer failure sql> conn sys/oracle as sysdba connected. sql> select name from v$datafile where ts#=9; name -------------------------------------------------------------------------------d:\bkp\users01.dbf sql> sql> clear screen 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 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-00310: archived log contains sequence 8; sequence 7 required ora-00334: archived log: 'd:\oracle\bkp7.1'

sql> alter database open resetlogs; alter database open resetlogs * error at line 1: ora-01139: resetlogs option only valid after an incomplete database recovery sql> recover database untill cancel; ora-00905: missing keyword sql> recover database until cancel; 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-00310: archived log contains sequence 8; sequence 7 required ora-00334: archived log: 'd:\oracle\bkp7.1'

ora-01547: warning: recover succeeded but open resetlogs would get error below ora-01152: file 1 was not restored from a sufficiently old backup ora-01110: data file 1: 'd:\oracle\oradata\iimdba\system01.dbf' sql> spool off;

Related Documents