I'm trying to synchronize 2 dbs which are not connected to each other, and located in a separated networks.
The 'copy db' (aka: standby) can be read only, but still should be active.
My intuition (which I'm not sure is correct) tells me I can synchronize the both using RMAN
backup / restore, then move the archive files from source (production) to copy (standby), open copy (standby) in read only
mode and apply changes when still open (similar to active data guard).
What I did is as follows (according this manual): I configured data guard according the manual, see link.
On source (production):
$ rman target=/
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
I moved the files and restored on the copy after configured as standby:
$ rman target=/
RMAN> STARTUP MOUNT;
RMAN> RESTORE DATABASE;
and got Finished restore at
Now on the copy (after all configurations from the manual) I've tried to open the db:
SQL> shutdown immediate;
...
Oracle instance shut down.
SQL> startup mount;
ORACLE instance started
...
Database mounted.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\PATH\TO\FILE\SYSTEM01.DBF'
I'm using oracle 11g DB on windows, I've tried also on Linux and reach the same results.
both machine are new, oracle 11g SW installed on both (with sample schemes), and DB was dropped on the copy before the restore.
file was copied after DB was dropped, no changes was made on the source DB except the configuration according to the manual.
I would like to ask:
is what I'm trying to achieve (active data guard without direct connection, manually move of archive once in a while, and auto apply of archive) looks possible?
why the database restore or open is failed?
is there simpler way to do so? (i.e. manual backup / restore without configure production / standby architecture, but still apply the archive of the source to the copy.)
Thanks for any reply.