I am using oracle 19c on windows.
I am trying to figure out an existing setup of our database disaster recovery solutions, on two servers. One is the primary , the other is the secondary server/database,
At first I thought this maybe a data guard setup, but I did not see some parameters setup for that. or TNS names setup for both nodes in.
But it seems just used part of something like data guard or log shipping. I really don't know how to call this approach. And how it works comparing with data guard?
So we have .bat file running every 2 hours, It works fine.
basically the core part of the script is like below: this runs on the secondary server.
(
echo set escape on
echo set heading off
echo alter system set log_archive_dest_1='location=/\/\MyprodServerName\archivelog/\';
echo recover standby database until cancel;
echo auto
echo alter database open read only;
) | sqlplus -s / as sysdba >> F:\oradata\RecoverStandbyDB.log
Note the system set log_archive_dest_1 on secondary database is set to point to archive directory of primary database archive log directory.
So my question is what is this approach, I don't need to setup things like those for data guard for this to work,, right?
I know data guard is almost real time. but this is definitely not, but this is what we want for Disaster recovery purpose, '