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;