Manual apply of archive logs to standby database
801855Mar 5 2013 — edited Mar 5 2013Hi I am an Oracle DBA with minimal knowledge on shell scripting…Below is my query…
Source(Primary-production) and target DB’s(Standby database) are in 2 different data centers..
Our organization doesn’t want to build a physical standby database for our production DB. So they wanted me to write a script which does the below 4 steps…
1) zip all the archive logs once generated in primary DB
2) copy them over to SAN(this SAN is an NFS disk for both target and source databases)...
3) From SAN to target DB server
4) apply the logs on that target database(mount state)…
Is this kind of approach really possible ?
DB version--- 11.2.0.3 EE (Dataguard comes with EE but still my company don’t want to build becoz of network issues)
OS – AIX 6.1