Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to query Standby database ...
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 script to delete only the logs that have been backed
up and applied. So here are my questions...
1. On the standby host I can get into the database
-- sqlplus '/ as sysdba' . How can I get onto it remotely since I need
to get in as somebody as SYSDBA. If I try
sqlplus '"sys/password_at_connect_string as sysdba'" it still asks
me for a password. What am I doing wrong.
2. This is an academic question. Am I
correct in assuming that password changes done in the production is passed
onto the standby database.
3. I try to logon to the standby database locally
as follows
sqlplus 'sys as sysdba' and get the following.. ORA-01033 Oracle
initialization or shutdown in progress
Any help will be greatly appreciated.
Thanks
Anjan
Received on Thu Oct 25 2001 - 11:27:56 CDT
![]() |
![]() |