Oracle 10g r2 standby startup question

[treedstang]

We are on Oracle 10G R2 on SLES 10-/SPK2.

Could someone tell me the proper way to startup a standby database after a reboot so it can start applying arcfiles.. In past I always used startup but apparently that's not it because the Arcfiles keep increasing.

I already have the listener started I see that running..

do I use a startup nomount and something else?


Thanks

[LKBrwn_DBA]

Else, you could just look it up in the fine Oracle® Data Guard Concepts and Administration manual.

[giteshtrivedi]

Hi,

Use "startup nomount" while want to start data guard or standby database.

Thanks and regards,
Gitesh Trivedi

[treedstang]

giteshtrivedi, Thanks for the response ..

So if I use startup nomount it automatically start applying arcfiles..

I'm using dataguard

[vnktummala]

it will NOT. Please look into the link given by LKB.

Thanks,

[davey23uk]

Hi,

Use "startup nomount" while want to start data guard or standby database.

Thanks and regards,
Gitesh Trivedi

thats just stupid advice as it doesnt do anything!