archieve log mode Turn off

[Former Member]

hi Experts ,

i have some doubts please clarefy me-->(at the time of client refresh in remote client copy)

1) why we are going to turn off Archieve log mode for client Refresh--> is it necessary

2) why we need to stop instance before Turn off Archieve log mode ..is it necessary to stop instance

3) in my test run it shows non-critical differences in the table structures --> i got this message what can i do , is that an error or just an information ..can i do client refresh

please reply me

Regards

[sunny_pahuja2]

Hi,

> 1) why we are going to turn off Archieve log mode for client Refresh--> is it necessary

Because client copy do read/write/delete very heavily as a result frequency of archive log will be more. So your archive directory will be frequently filled up and also your speed of writing will be very slow. Thats why, it is suggested to turn off archiving during client copy.

> 2) why we need to stop instance before Turn off Archieve log mode ..is it necessary to stop instance

You cannot turn off archiving when instance is up. You can only turn off archiving in mount state.

> 3) in my test run it shows non-critical differences in the table structures --> i got this message what can i do , is that an error >or just an information ..can i do client refresh

>

If it is not critical then you can run client copy.

Thanks

Sunny