迁移库
1.在/etc/oratab里写入注册信息
2.sftp 登录
3.tar -czvf znjl.tar.gz znjl
4.spfile和passwd拷贝过去 
get /oracle/product/10.2.0/db_1/dbs/orapweptsdb  /oracle/product/10.2.0/db_1/dbs/
get /oracle/product/10.2.0/db_1/dbs/spfileeptsdb.ora  /oracle/product/10.2.0/db_1/dbs/
tar -xzvf znjl.tar.gz
chown oracle:oinstall

mkdir adump
mkdir bdump
mkdir cdump
mkdir dpdump
mkdir pfile
mkdir udump
cp init.ora.1132010165145 pfile/

5.create pfile='/home/oracle/pfile2.ora' from spfile;
get /home/oracle/pfile.ora /home/oracle/pfile.ora
startup pfile='/oracle/admin/znjl/pfile/init.ora.628201015108' mount;

alter database rename file '/oracle/oradata/qhznjl/system01.dbf' to '/oradata/qhznjl/system01.dbf';
alter database rename file '/oracle/oradata/qhznjl/users01.dbf' to '/oradata/qhznjl/users01.dbf';
startup pfile='/oracle/admin/znjlbt/pfileinit.ora.1132010165145' UPGRADE
startup pfile='/oracle/admin/znjlbt/pfile/init.ora.1132010165145' UPGRADE;

STARTUP UPGRADE

6.建立归档日志目录 /oradata/archivelog/sgpmdb
cd /oradata/archivelog/
mkdir eptsdb
-- mkdir -p /oradata/archivelog/znjlbt
[oracle@standby archivelog]$ pwd
/oradata/archivelog
[oracle@standby archivelog]$ tar -czvf znjlbt.tar.gz znjlbt
get /oradata/archivelog/znjlbt.tar.gz /oradata/archivelog/znjlbt/
tar -xzvf znjl.tar.gz

7.拷贝跟踪日志admin

export ORACLE_SID=

 

export ORACLE_SID=
orapwd file="/oracle/product/10.2.0/db_1/dbs/orapweptsdb" password=odc_long_316 entries=5
cp orapweptsdb orapw
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

--编译失效对象
SQL>@/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP RUL        2012-07-09 21:22:55
DBUA_TIMESTAMP RUL        VALID       2012-07-09 21:22:55