sqlserv ogg oracle

sqlserver  20008r2

1、源端设置

2、创建ogg 用户

3、创建odbc连接

备份查询最后一次备份时间。。

select a.database_name, b.physical_device_name,a.position ,a.type,
a.last_lsn,a.backup_start_date,a.backup_finish_date
from msdb..backupset a, msdb..backupmediafamily b
where a.media_set_id=b.media_set_id and a.database_name='EIS' AND A.type='D'
ORDER BY A.backup_finish_date DESC；

backup database eis to disk='' with init

go

 查出最后一次：last_lsn：61249000000033700001

把备份文件拷贝到中间库 还原

把中间机数据库重命名，还原eis数据库。。

。。。。。。。。。。。。。。。。。。。。。。。

目标：创建容器数据库 ，并创建表空间。一个是通过developer还原的默认表空间..一个是ogg管理的表空间。

创建developer还原的用户mig

CREATE USER mig IDENTIFIED BY mig
  DEFAULT TABLESPACE ogg_tsp TEMPORARY TABLESPACE temp;
 
GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW,
   CREATE PUBLIC SYNONYM TO mig WITH ADMIN OPTION;
 
GRANT  ALTER ANY ROLE, ALTER ANY SEQUENCE, ALTER ANY TABLE, ALTER TABLESPACE,
ALTER ANY TRIGGER, COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,
CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE, CREATE USER, DROP ANY
SEQUENCE, DROP ANY TABLE, DROP ANY TRIGGER, DROP TABLESPACE, DROP USER, DROP ANY
ROLE, GRANT ANY ROLE, INSERT ANY TABLE, SELECT ANY TABLE, UPDATE ANY TABLE TO 
mig;