Re: shutdown Abort...Open normal??
STARUP FORCE - Issue a shutdown abort and then try to immediately restart the database. STARTUP RESTRICT - Open the database and only allow access to users with the RESTRICTED SESSION role. STARTUP MOUNT - Mounts the database, but doesn't open it for use. STARTUP NOMOUNT - Does not mount the database STARTUP RECOVER - Similar to the recover database command. It starts the database and attempts a recovery. STARTUP OPEN - Mounts and Opens the database STARTUP - Default open, which is STARTUP OPEN. "Raghu Kota" [EMAIL PROTECTED] 02/16/01 04:10PM Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shutdown Abort...Open normal??
Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: shutdown Abort...Open normal??
Recovery from a shutdown abort is automatic. David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Friday, February 16, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shutdown Abort...Open normal??
No Manual recovery is required in this case. Oracles background process takes care of this and rolls back any uncommited transaction. You can read about this any beginners oracle book which talks about oracle's architecture. Hope this helps. Raghu Kota [EMAIL PROTECTED] wrote: Hi FriendsCould you explain this..SVRMGR connect sys as sysoper;Password:Connected.SVRMGR shutdown abortORACLE instance shut down.SVRMGR startup open;ORACLE instance started.Database mounted.Database opened.SVRMGRI thought recovery is needed, But its opened?ThanksRaghu._Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Raghu KotaINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailin! ! g list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!
RE: shutdown Abort...Open normal??
Instance recovery, not database recovery, occurs after a shutdown abort or other abnormal instance termination. No DBA intervention is required; Oracle takes care of it automatically. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Friday, February 16, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shutdown Abort...Open normal??
See your alertSID.log file for recovery message. By default recovery is automatic. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 16 Feb 2001 13:10:47 -0800 Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).