Re: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread Anjo Kolk
That is correct. TX recovery was done in the background and foreground (if a user would hit a transaction that needed to be rollback, but wasn't yet by the background). Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, February 08, 2

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread Jeremiah Wilton
John, In 7.3.4, wasn't background TX recovery already a feature? In other words, weren't large rollbacks delayed until after the database was already open and available? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 7 Feb 2003, John Kanagaraj wrote: > Just to add another aspect:

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread John Kanagaraj
HUTDOWN ABORT -- was RE: Debate on rc > commands Solaris > an > > > Hi Robert, > > For problem 1, you mean transaction recovery, i.e. rollback, right? > Did this problem happen only with fast start parallel rollback or also > with normal version 7-on background TX roll

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread Jeremiah Wilton
Hi Robert, For problem 1, you mean transaction recovery, i.e. rollback, right? Did this problem happen only with fast start parallel rollback or also with normal version 7-on background TX rollback? How about user rollbacks (user 1 rolls back large transaction, user 2 truncates the table in the m

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread Farnsworth, Dave
got it Thanks, Dave -Original Message- Sent: Friday, February 07, 2003 11:30 AM To: Multiple recipients of list ORACLE-L an Dave Just add one more line before to shutdown abort... alter system checkpoint; SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN IMMEDIATE Regards Rafiq Reply-T

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread M Rafiq
Dave Just add one more line before to shutdown abort... alter system checkpoint; SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN IMMEDIATE Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 07 Feb 2003 07:28:43 -0800 I do my cold bac

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread Farnsworth, Dave
RajendraSent: Monday, February 03, 2003 9:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an When we do cold backups, our script issues 'shutdown immediate', if within 3 minutes the db is not shut

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-07 Thread Jamadagni, Rajendra
Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an Thanks Robert, I wasn't aware of that issue. Plus now that we have all instances on 9202, we hope it won't bite us. As for adding tablespaces dynamically, no chance. We *require* that development team reques

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-06 Thread Robert Freeman
2003 9:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an When we do cold backups, our script issues 'shutdown immediate', if within 3 minutes the db is not shut down, we cancel and issue 'shutdown abo

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

2003-02-03 Thread Jamadagni, Rajendra
Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and When we do cold backups, our script issues 'shutdown immediate', if within 3 minutes the db is not shut down, we cancel and issue 'shutdown abort'. In either case, we (again issue) startup/shutdown to make it clean befor