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'
二: 创建密码文件:
三: 创建对应的路径: 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