This content has been marked as final. Show 3 replies
In case of manual DR, You need to manually copy and paste and apply the redo log on manual DR on hourly basis since the archives will keep increasing on daily so copy command will not get how many archives needs to be copy.
You can use (if you are using windows) windows copy command to copy all the files from one place to other(server to server.)
I am creating a manual standby database (Not DataGuard) in oracle 10g using Unix OS.I need to transfer archive files from primary to standby database on hourly basis.In case of manual standby, the more simple will be not to transfer files to standby site, but make them available by nfs. So, there will be no need to check what logs were sent and applied. Recovery script on standby will just periodically perform recovery from this destination. Script will always ends with message like this that can be ignored:
For this purpose I need script that can help me to transfer archive files.
Your usual cooperation will be highly appreciated.
ORA-00308: cannot open archived log '.......' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory
You can use RSYNC utility to accomplish it.
As archivelog in this case is a regular file and you will use only OS command (i.e not a Oracle Database issue). I recommend you move (close here and open new) this thread to forum which have matters related.
Or other forum outside of Oracle Forum.