Create directory where to install.
mkdir -p /u01/app/oracle/oradata
Move pfile/spfile to $ORACLE/HOME/dbs
scp initorcl.ora spfileorcl.ora oracle@machine_name:$ORACLE/HOME/dbs
Rename controlfile location name in parameter file
Copy file controlfile, datafile, logfile
scp * oracle@machine_name:/u01/app/oracle/oradata
startup mount;
Rename datafile,logfile like below.
alter database rename file '/u01/app/oracle/system01.dbf' to '/u01/app/oracle/oradata/system01.dbf';
alter database rename file '/u01/app/oracle/sysaux01.dbf' to '/u01/app/oracle/oradata/sysaux01.dbf';
alter database rename file '/u01/app/oracle/log01.dbf' to '/u01/app/oracle/oradata/log01.dbf';
alter database open;
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন