Re: Fwd: How to shutdown 9i?
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <cjpengel.dbalert@xxxxxxxxx>, <revoohc@xxxxxxxxx>
- Date: Tue, 14 Jun 2005 06:14:32 -0400
if you can connect through sql plus as sysdba you should be able to do a
shutdown immediate
Also oracle does do instance recovery applying all of the online redo log
information before it opens the database if the database does not open
gracefully
Still get a good backup first making sure to archive your redo and backup your
archives would ensure 0 data loss
Carel's questions about archives when a backup will be as well as questions of
ensuring your application, batches and backups are not hitting the db at the
same time ensures a fallback plan
--------------------------
Sent from my BlackBerry Wireless Handheld
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
To: revoohc@xxxxxxxxx <revoohc@xxxxxxxxx>
CC: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
Sent: Mon Jun 13 19:49:54 2005
Subject: Re: Fwd: How to shutdown 9i?
Hi Chris,
Are backups scheduled? Will the server be booted before or after the
backup? How much data-loss is allowed? Do you have all archives
available on tape/another system? Just in case the reboot doesn't help
and the server won't start nor allows 'shell' access after the init
0/init 6. You will probably get access to the disks after a while, but
is that fast enough?
Best regards, Carel-Jan Engel
On Tue, 2005-06-14 at 01:21, Chris Hoover wrote:
> ---------- Forwarded message ----------
> From: Chris Hoover <revoohc@xxxxxxxxx>
> Date: Jun 13, 2005 4:08 PM
> Subject: How to shutdown 9i?
> To: Oracle-L@xxxxxxxxxxxxx
>
>
> We are having a very strange problem. Our AIX server is having issues
> and is not allowing shell access from the terminal or from the
> network.
>
> The decision has been made to reboot this server tonight. However, it
> is our Oracle 9i db server. Is there anyway to get Oracle to shutdown
> w/o being able to log onto the box? We can connect to the db fine
> with our application and sql plus, we just can't get a shell on the
> box. We do not have an Enterprise manager server since we only run
> this on copy of Oracle.
>
> thanks for any advice.
>
> Chris
> --
> //www.freelists.org/webpage/oracle-l
===
If you think education is expensive, try ignorance. (Derek Bok)
===
DBA!ert, Independent Oracle consultancy
Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands
tel. +31 (0) 182 64 04 28
fax +31 (0) 182 64 04 29
e-mail info.dbalert@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 35212458) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=s&i=35212458&m=967dfd008f33
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=n&i=35212458&m=967dfd008f33
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=f&i=35212458&m=967dfd008f33
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
//www.freelists.org/webpage/oracle-l
Other related posts:
