How to query Standby database ...

2001-10-25 Thread Anjan Thakuria
Hi, We have a standby environment where due to application constraints we have to apply logs based on the application progress. However before I was made responsible the remote archiving was not enabled, and files were transferred through a script. Now to clear the archive dest I need to write a

Re: How to query Standby database ...

2001-10-25 Thread Larry Strickland
Anjan, First off, the answer to your question is to make sure that REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the paramter file for your DB and that you have used orapwd to create a (current) password file with an appropriate password. Then login as internal/that_secret_password or as