Frank van Bortel wrote:
> Tof wrote:
>
>> Frank van Bortel wrote:
>>
>>> Tof wrote:
>>>
>>>>>
>>>>> There is a difference between a database in archive log
>>>>> *mode* and an archive process *running*.
>>>>> You stopped the latter, and queried the former.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Can you give me a example.
>>>>
>>>> Thanks
>>>
>>>
>>>
>>>
>>> Query v$database (Archive Log Mode, or NoArchive log mode, as well
>>> as automatic or manual archiving) and v$archive_processes.
>>
>>
>>
>> Excuse me, but i see in v$database and i see just LOG_MOD, it's for
>> mod of database.
>> I try the "alter system archive log " STOP and START but same in
>> v$archive_processes, two defaut process are active.
>>
>> SQL> select * from v$archive_processes;
>>
>> PROCESS STATUS LOG_SEQUENCE STAT
>> ---------- ---------- ------------ ----
>> 0 ACTIVE 0 IDLE
>> 1 ACTIVE 0 IDLE
>> 2 STOPPED 0 IDLE
>> 3 STOPPED 0 IDLE
>> 4 STOPPED 0 IDLE
>> 5 STOPPED 0 IDLE
>> 6 STOPPED 0 IDLE
>> 7 STOPPED 0 IDLE
>> 8 STOPPED 0 IDLE
>> 9 STOPPED 0 IDLE
>>
>> 10 rows selected.
>>
>> Thanks
>> Christophe
>
>
> So, you're not on 10G, then?
I am on 10g. There a difference between 9i and 10g ?
Received on Wed Mar 02 2005 - 03:52:05 CST
