Outils pour utilisateurs

Outils du site


informatique:base_de_donnees:verifier_si_une_base_est_en_archivelog

Vérifier si une base est en archivelog

oracle@machine::9.2.0:/apps/oracle/ export ORACLE_SID=SOMESID
oracle@machine:SOMESID:9.2.0:/apps/oracle/ sqlplus "/ as sysdba" 

SQL*Plus: Release 9.2.0.7.0 - Production on Mon Jul 10 13:58:57 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

SQL> select name,log_mode from v$database;  

NAME      LOG_MODE
--------- ------------
SOMESID   NOARCHIVELOG

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
informatique/base_de_donnees/verifier_si_une_base_est_en_archivelog.txt · Dernière modification: 2009/06/29 21:04 (modification externe)