Re: System Problems

Hi Damon,

andersd_at_iia.org / 26.12.94 / "System Problems":

> I have had a server crash and could use some guidance in making sure it
> doesn't happen again. I am running Oracle 7

What did crash? Just the instance or the database? Which database-files did you loose? If you have mirrored your redolog-files and are running in archive-log-mode, you will always get back all data including the last committed record, even if you have a media-crash and you have to use an old backup!

> have another question concerning SQLDBA. I am unable to run PL/SQL
> commands that format reports. The manual says that you can do this. I
> cannot. Appreciate any assistance.

I think, you have mixed up something...

1. YOU CAN ========== start PL/SQL-Scripts in SQL*DBA, but you have to use the masterspace-sign instead of START:

sqldba>_at_myscript.sql instead of sqldba>start myscript.sql

2) YOU CAN
========== do a very little formatting by useing SET NUMWITH 7
SET CHARWITH 15 (eg)

3) but YOU CAN'T

================ use the SQL*PLUS-Commands "COLUMN xx format a15"...

Regards

Harald

--
Harald Wakonig, Graz/Austria/Europe

## CrossPoint v3.0 R ##