Update table with data from other table in remote oracle db

The REDO logs should be copied.

Shutdown doesn't trigger a logfile switch.

If you are changing the paths for the files, then using the "create controlfile reuse noresetlogs" method is the best. If you do move it without REDO logs, then archivelog current and then use the "create controlfile set resetlogs" method. In general though, moving the redo logs are best.

--EDIT--

Based on what you said, you are mounting these in the exact same path, then do your self a favor and just put all of the files, DATAFILES TEMPFILES CONTROLFILES REDOLOGS, etc in the exact same file path. Nothing else to do and it comes up fine.

-Richard

Not using a built in command, but...

If an UPDATE really can satisfy your requirements as your title implies, then no inserts should be necessary and the primary key must be in sync between the databases.

Your requirements don't allow remote updates, but if you can remotely query the database, then you can join the local table to the remote table to create the statements that will need to be run the remote system. Here is a demonstration:

drop table t1;
drop table t2;
create table t1 as (select level c1, level c2 from dual connect by level <=7);
create table t2 as (select * from t1);
update t2 set c2 = null where c1 in (3,6);
select * from t1;
select * from t2;

select 'UPDATE t2 SET c2 = ' || t1.c2 || ' WHERE c1=' || t1.c1 || ';' sql from t1 
join t2 on t1.c1 = t2.c1
where t1.c2 <> t2.c2 OR t2.c2 is null;

If you cannot query the remote database, you can update every row like this:

drop table t1;
create table t1 as (select level c1, level c2 from dual connect by level <=7);

select 'UPDATE t2 SET c2 = ' || t1.c2 || ' WHERE c1=' || t1.c1 || ';' sql from t1;