Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown abort & consistent=Y
you won't lose anything by doing a shutdown abort followed by a startup restrict because upon the startup, oracle does an instance recovery using the online redo logs. This is a safe practice as long as you know what is happening on your database when you shutdown abort. For example, if you shutdown abort while tablespaces are in backup mode then the db will complain (file xyz needs media recovery.....) upon restart and you will need to take each datafile out of backup mode manually in order to open the db. Received on Tue Feb 02 1999 - 21:23:19 CST