Black Hawk Down: Was: Installing Oracle on uncertified Linux, like Debian, Download RedHat, Gentoo ? (off-topic)

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 25 Mar 2003 21:08:40 -0000
Message-ID: <3e80c580_1@mk-nntp-1.news.uk.worldonline.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:%L1ga.8008$dE2.17842_at_newsfeeds.bigpond.com...
> That would be "Blackdown Java", which always makes me think of helicopters

Helicopters? Black Hawk is down and it needs to be brought back up?

Try this:

set ORACLE_SID=BLACK_HAWK
sqlplus "/ as sysdba"
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes

Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes

Database mounted.
Database opened.
SQL> BLACK_HAWK is back up!
Shame wars don't work like this.

Of course, if you want to be safe:

G:\Documents and Settings\BLACK_HAWK\Documents>rman target BLACK_HAWK

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

target database Password:
connected to target database: BLACK_HAWK (DBID=xxxxxxxxx)

RMAN> backup database;

Starting backup at 25-MAR-03
using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=12 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset

including current SPFILE in backupset
including current controlfile in backupset

input datafile fno=00001 name=G:\ORACLE\ORADATA\BLACK_HAWK\SYSTEM01.DBF
input datafile fno=00005 name=G:\ORACLE\ORADATA\BLACK_HAWK\EXAMPLE01.DBF
input datafile fno=00002 name=G:\ORACLE\ORADATA\BLACK_HAWK\UNDOTBS01.DBF
input datafile fno=00010 name=G:\ORACLE\ORADATA\BLACK_HAWK\XDB01.DBF
input datafile fno=00006 name=G:\ORACLE\ORADATA\BLACK_HAWK\INDX01.DBF
input datafile fno=00009 name=G:\ORACLE\ORADATA\BLACK_HAWK\USERS01.DBF
input datafile fno=00003 name=G:\ORACLE\ORADATA\BLACK_HAWK\CWMLITE01.DBF
input datafile fno=00004 name=G:\ORACLE\ORADATA\BLACK_HAWK\DRSYS01.DBF
input datafile fno=00007 name=G:\ORACLE\ORADATA\BLACK_HAWK\ODM01.DBF
input datafile fno=00008 name=G:\ORACLE\ORADATA\BLACK_HAWK\TOOLS01.DBF

channel ORA_DISK_1: starting piece 1 at 25-MAR-03 channel ORA_DISK_1: finished piece 1 at 25-MAR-03 piece handle=G:\ORACLE\ORA92\DATABASE\0AEITUBS_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:07 Finished backup at 25-MAR-03

Regards (and a grin),
Paul Received on Tue Mar 25 2003 - 15:08:40 CST