node-)rmantoRAC(迁移)(一)

2014-11-24 11:21:58 · 作者: · 浏览: 5
*.audit_file_dest='/dba/app/oracle/admin/dominic/adump' *.audit_trail='db' *.cluster_database=true *.compatible='11.2.0.4.0' *.control_files='+DATA_DISK/DOMINIC/controlfile/current.260.825093345','+LOG_DISK/DOMINIC/controlfile/current.256.825093345' --- DOMINIC 大写 *.db_block_size=8192 *.db_create_file_dest='+DATA_DISK' *.db_domain='' *.db_name='dominic' #*.log_file_name_convert='+DATA_DISK/dominic/logfile','/u01/app/oracle/logfile','+LOG_DISK/dominic/logfile','/u01/app/oracle/oradata/dominic' *.db_recovery_file_dest='+LOG_DISK' *.db_recovery_file_dest_size=4558159872 *.diagnostic_dest='/dba/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)' dominic2.instance_number=2 dominic1.instance_number=1 *.log_archive_format='%t_%s_%r.dbf' *.memory_target=1153433600 *.open_cursors=500 *.processes=300 *.remote_listener='dominic-scan:1521' *.remote_login_passwordfile='exclusive' *.sessions=350 dominic2.thread=2 dominic1.thread=1 dominic2.undo_tablespace='UNDOTBS2' dominic1.undo_tablespace='UNDOTBS1' *.undo_management='AUTO' 一 : 创建参数文件 to ASM [oracle@dominic1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 21 19:04:49 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance.
SQL> startup nomount ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/dba/app/oracle/product/11.2/dbhome_1/dbs/initdominic1.ora' --需要追加的路径
SQL> host [oracle@dominic1 ~]$ cd /dba/app/oracle/product/11.2/dbhome_1/dbs/
[oracle@dominic1 dbs]$ ls init.ora [oracle@dominic1 dbs]$ exit exit SQL> create spfile='+data_disk/dominic/parameterfile/initdominic.ora' from pfile='/dba/app/oracle/backup/s_pfile'; File created. SQL> HOST
[oracle@dominic1 ~]$ echo "SPFILE='+data_disk/dominic/parameterfile/initdominic.ora'" > /dba/app/oracle/product/11.2/dbhome_1/dbs/initdominic1.ora [oracle@dominic1 ~]$ cat /dba/app/oracle/product/11.2/dbhome_1/dbs/initdominic1.ora SPFILE='+data_disk/dominic/parameterfile/initdominic.ora' [oracle@dominic1 ~]$ ssh dominic2 [oracle@dominic2 ~]$ echo "SPFILE='+data_disk/dominic/parameterfile/initdominic.ora'" > /dba/app/oracle/product/11.2/dbhome_1/dbs/initdominic2.ora [oracle@dominic2 ~]$ cat /dba/app/oracle/product/11.2/dbhome_1/dbs/initdominic2.ora SPFILE='+data_disk/dominic/parameterfile/initdominic.ora'

ASMCMD> pwd +data_disk/dominic/parameterfile ASMCMD> ls initdominic.ora
二: 创建密码文件:

三: 创建对应的路径: ASM : +DATA_DISK /DOMINI/datafile 、logfile、controlfile、parameterfile。 + LOG_DISK /dominic/logfile, controlfil 等:
+++++++++++++++++++++++++++++++++++++++++++++失败++++++++++++++++++++++ RMAN> run { 2> set newname for datafile 1 to '+DATA_DISK/DOMINIC/datafile/system01.dbf'; 3> set newname for datafile 2 to '+DATA_DISK/DOMINIC/datafile/undotbs01.dbf'; 4> set newname for datafile 3 to '+DATA_DISK/DOMINIC/datafile/users01.dbf'; 5> set newname for datafile 4 to '+DATA_DISK/DOMINIC/datafile/undotbs01.dbf'; 6> set newname for datafile 5 to '+DATA_DISK/DOMINIC/datafile/example01.dbf'; 7> set newname for datafile 6 to '+DATA_DISK/DOMINIC/datafile/dominic_tbs01.dbf'; 8> restore database; 9> switch datafile all; 10> } executing command: SET NEWNAME executing command: SET NEWNAME execu