SYS and SYSTEM Passwords for production and test databases
Here is the process which we are following.
1) We are receiving the archive logs through a 3rd party ftp software (FASTCOPY) then on an hourly basis we are moving them into the archive log destination directory.
2) Then we are shutting down the database and starting it in nomount state.
3) once it is in nomount state we are issuing the command "alter database mount standby database" and then issuing the command "recover standby database" with AUTO.
4) Once the applying of the logs are done we are altering the database to open read only.
So basically it is not replication but applying of logs from production to the test machine.
Thank you