| Archivelog Mode Change [message #53506] |
Tue, 24 September 2002 22:46  |
Soumen Ghosh
Messages: 9
Registered: May 2002
|
Junior Member |
|
|
Hello,
When an Oracle instance is running, how do I know whether it is running in archivelog or noarchivelog mode without looking at the archive directory?
Is there any view or table where this information is available.
Thanks in advance.
Soumen Ghosh
|
|
|
|
| Re: Archivelog Mode Change [message #53508 is a reply to message #53506] |
Wed, 25 September 2002 00:21  |
erpman
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
hello guy
select ARCHIVER from v$instance;
select LOG_MODE from v$database;
frist show whether oracle archive process is started .
below show whether database is runing under archive mode
|
|
|
|
|
|
| Re: Archivelog Mode Change [message #55027 is a reply to message #53518] |
Fri, 27 December 2002 06:50 |
Mustafa
Messages: 6
Registered: June 2002
|
Junior Member |
|
|
connect as sysdba and issue this query
select log_mode from v$database
to see in which mode db is running
and
select archiver from v$instance
to know that the archive process is started or not
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
