TO GO ONLINE
Posted in 2005
Topics: Security, Permissions & Auditing
HI GURUS: ONE QUESTION. WE HAVE TO RESTORE OUR DB, FOR 01/JAN/2005 FOR AUDIT IT. THE LEVEL 0 RESTORE (WITH HP OMNI BACK STORE DATA PROTECTOR V5.1), DID FINISH WELL, AND I DON'T HAVE LOGS FOR RESTORE, THE IBM INFORMIX DATA BASE WERE BRING ON 'QUIESCENT' MODE. HOW I DO FOR TAKE TO 'ON-LINE' MODE, THE DATA BASE ?? I DON'T CARE THE PENDING TRANSACTIONS, ONLY I WANT TO ACCESS TO THE TABLES, TO THE DATA. THANKS A LOT FOR YOUR HELP. JUAN VALERIANO VILLEGAS
onmode
-m
Regardz.
-----Mensaje original-----
De: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] En nombre de
Valeriano V....
Enviado el: Miércoles, 20 de Julio de 2005 03:43 p.m.
Para: ids@iiug.org
Asunto: TO GO ONLINE [5473]
HI GURUS:
ONE QUESTION.
WE HAVE TO RESTORE OUR DB, FOR 01/JAN/2005 FOR AUDIT IT.
THE LEVEL 0 RESTORE (WITH HP OMNI BACK STORE DATA PROTECTOR V5.1),
DID FINISH WELL,
AND I DON'T HAVE LOGS FOR RESTORE,
THE IBM INFORMIX DATA BASE WERE BRING ON 'QUIESCENT' MODE.
HOW I DO FOR TAKE TO 'ON-LINE' MODE, THE DATA BASE ??
I DON'T CARE THE PENDING TRANSACTIONS,
ONLY I WANT TO ACCESS TO THE TABLES, TO THE DATA.
THANKS A LOT FOR YOUR HELP.
JUAN VALERIANO VILLEGAS
AVISO LEGAL:
Esta información es privada y confidencial y está dirigida únicamente a su
destinatario. Si usted no es el destinatario original de este mensaje y por
este medio pudo acceder a dicha información por favor elimine el mensaje. La
distribución o copia de este mensaje está estrictamente prohibida. Esta
comunicación es sólo para propósitos de información y no debe ser considerada
como propuesta, aceptación ni como una declaración de voluntad oficial de
REPSOL YPF S.A. y/o subsidiarias y/o afiliadas. La transmisión de e-mails no
garantiza que el correo electrónico sea seguro o libre de error. Por
consiguiente, no manifestamos que esta información sea completa o precisa.
Toda información está sujeta a alterarse sin previo aviso.
This information is private and confidential and intended for the recipient
only. If you are not the intended recipient of this message you are hereby
notified that any review, dissemination, distribution or copying of this
message is strictly prohibited. This communication is for information purposes
only and shall not be regarded neither as a proposal, acceptance nor as a
statement of will or official statement from REPSOL YPF S.A. and/or
subsidiaries and/or affiliates. Email transmission cannot be guaranteed to be
secure or error-free. Therefore, we do not represent that this information is
complete or accurate and it should not be relied upon as such. All information
is subject to change without notice.
onmode -m
HTH,
Zev Berezin
Date sent: Wed, 20 Jul 2005 14:42:48 -0400 (EDT)
To: ids@iiug.org
From: "Valeriano V...." <jvaleriano@ref.pemex.com>
Subject: TO GO ONLINE [5473]
> HI GURUS:
>
> ONE QUESTION.
>
> WE HAVE TO RESTORE OUR DB, FOR 01/JAN/2005 FOR AUDIT IT.
>
> THE LEVEL 0 RESTORE (WITH HP OMNI BACK STORE DATA PROTECTOR V5.1),
> DID FINISH WELL,
> AND I DON'T HAVE LOGS FOR RESTORE,
> THE IBM INFORMIX DATA BASE WERE BRING ON 'QUIESCENT' MODE.
>
> HOW I DO FOR TAKE TO 'ON-LINE' MODE, THE DATA BASE ??
>
> I DON'T CARE THE PENDING TRANSACTIONS,
> ONLY I WANT TO ACCESS TO THE TABLES, TO THE DATA.
>
> THANKS A LOT FOR YOUR HELP.
>
> JUAN VALERIANO VILLEGAS
>
>
>
Valeriano V.... said:
> HI GURUS:
>
> ONE QUESTION.
>
> WE HAVE TO RESTORE OUR DB, FOR 01/JAN/2005 FOR AUDIT IT.
>
> THE LEVEL 0 RESTORE (WITH HP OMNI BACK STORE DATA PROTECTOR V5.1),
> DID FINISH WELL,
> AND I DON'T HAVE LOGS FOR RESTORE,
> THE IBM INFORMIX DATA BASE WERE BRING ON 'QUIESCENT' MODE.
>
> HOW I DO FOR TAKE TO 'ON-LINE' MODE, THE DATA BASE ??
onmode -m
????
> I DON'T CARE THE PENDING TRANSACTIONS,
> ONLY I WANT TO ACCESS TO THE TABLES, TO THE DATA.
>
> THANKS A LOT FOR YOUR HELP.
>
> JUAN VALERIANO VILLEGAS
>
>
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche
A smile is a gift that is free to the giver and precious to the recipient.
But giving someone the finger is free too, and I find it more personal and
sincere.
--0__=C7BBFAD6DF9F27E38f9e8a93df938690918cC7BBFAD6DF9F27E3
Content-transfer-encoding: quoted-printable
Content-type: text/plain; charset=US-ASCII
To check the status of the informix
run : onstat -
since it is already in "QUIESCENT" as you mentioned,
you can run : onmode -m
then run : onstat -
you should see the status as "On-Line"
Regards
Dominic Seah
64616826
-----forum.subscriber@iiug.org wrote: -----
To: ids@iiug.org
From: "Valeriano V...." <jvaleriano@ref.pemex.com>
Sent by: forum.subscriber@iiug.org
Date: 07/21/2005 02:42AM
Subject: TO GO ONLINE [5473]
HI GURUS:
ONE QUESTION.
WE HAVE TO RESTORE OUR DB, FOR 01/JAN/2005 FOR AUDIT IT.
THE LEVEL 0 RESTORE (WITH HP OMNI BACK STORE DATA PROTECTOR V5.1),
DID FINISH WELL,
AND I DON'T HAVE LOGS FOR RESTORE,
THE IBM INFORMIX DATA BASE WERE BRING ON 'QUIESCENT' MODE.
HOW I DO FOR TAKE TO 'ON-LINE' MODE, THE DATA BASE ??
I DON'T CARE THE PENDING TRANSACTIONS,
ONLY I WANT TO ACCESS TO THE TABLES, TO THE DATA.
THANKS A LOT FOR YOUR HELP.
JUAN VALERIANO VILLEGAS
Disclaimer:-
The information contained and transmitted by this e-mail is intended fo=
r
use only by the individual or entity to which it is addressed and may
contain information that is privileged, confidential or exempt from
disclosure under applicable law.
If you are not the intended recipient or it appears that this mail has =
been
forwarded to you without proper authority, you are hereby notified
that any use, distribution, printing, copying or dissemination of this
e-mail in any manner or taking action in reliance on the contents of th=
is
e-mail is strictly prohibited.
If you have received this e-mail in error, please notify us immediately=
at
paullee@parkway.sg and permanently delete the original and
any copy of this e-mail and any printout thereof.=
--0__=C7BBFAD6DF9F27E38f9e8a93df938690918cC7BBFAD6DF9F27E3
Content-transfer-encoding: quoted-printable
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
<html><body>
<p><tt>To check the status of the informix<br>
</tt><tt>run : onstat -<br>
</tt><tt>since it is already in "QUIESCENT" as you mentioned,=
<br>
</tt><tt>you can run : onmode -m<br>
</tt><tt>then run : onstat -<br>
</tt><tt>you should see the status as "On-Line"<br>
</tt><br>
<br>
<br>
<tt>Regards<br>
</tt><tt>Dominic Seah<br>
</tt><tt>64616826<br>
</tt><br>
<br>
<br>
<tt>-----forum.subscriber@iiug.org wrote: -----<br>
</tt><br>
<br>
<tt>To: ids@iiug.org<br>
</tt><tt>From: "Valeriano V...." <jvaleriano@ref.pemex.com=
><br>
</tt><tt>Sent by: forum.subscriber@iiug.org<br>
</tt><tt>Date: 07/21/2005 02:42AM<br>
</tt><tt>Subject: TO GO ONLINE [5473]<br>
</tt><br>
<tt>HI GURUS:<br>
</tt><br>
<tt>ONE QUESTION.<br>
</tt><br>
<tt>WE HAVE TO RESTORE OUR DB, FOR 01/JAN/2005 FOR AUDIT IT.<br>
</tt><br>
<tt>THE LEVEL 0 RESTORE (WITH HP OMNI BACK STORE DATA PROTECTOR V5.1),<=
br>
</tt><tt>DID FINISH WELL,<br>
</tt><tt>AND I DON'T HAVE LOGS FOR RESTORE,<br>
</tt><tt>THE IBM INFORMIX DATA BASE WERE BRING ON 'QUIESCENT' MODE.<br>=
</tt><br>
<tt>HOW I DO FOR TAKE TO 'ON-LINE' MODE, THE DATA BASE ??<br>
</tt><br>
<tt>I DON'T CARE THE PENDING TRANSACTIONS,<br>
</tt><tt>ONLY I WANT TO ACCESS TO THE TABLES, TO THE DATA.<br>
</tt><br>
<tt>THANKS A LOT FOR YOUR HELP.<br>
</tt><br>
<tt>JUAN VALERIANO VILLEGAS<br>
</tt><br>
<tt>Disclaimer:-<br>
</tt><tt>The information contained and transmitted by this e-mail is in=
tended for use only by the individual or entity to which it is addresse=
d and may contain information that is privileged, confidential or exemp=
t from disclosure under applicable law.<br>
</tt><br>
<tt>If you are not the intended recipient or it appears that this mail =
has been forwarded to you without proper authority, you are hereby noti=
fied<br>
</tt><tt>that any use, distribution, printing, copying or dissemination=
of this e-mail in any manner or taking action in reliance on the conte=
nts of this<br>
</tt><tt>e-mail is strictly prohibited.<br>
</tt><br>
<tt>If you have received this e-mail in error, please notify us immedia=
tely at paullee@parkway.sg and permanently delete the original and </tt=
><br>
<tt>any copy of this e-mail and any printout thereof.</tt></body></html=
>=
--0__=C7BBFAD6DF9F27E38f9e8a93df938690918cC7BBFAD6DF9F27E3--