Instance Name: Pcbmes
Migrate the ORACLE11GR2 database below the/oracle_ebs/pcbmes/db to the/ebs/pcbmes/db directory
First, pre-preparation
1. Create the Pfile file (db using SPFile boot case)
Create Pfile from SPFile;
2. Get the script to recreate the control file (see related document 01 for details)
ALTER DATABASE backup Controlfile to trace;
Generate a trace file, this operation generates file path at/oracle_ebs/pcbmes/db/diag/rdbms/pcbmes/pcbmes/trace, can use Ls-l-T | More to sort view files
More/oracle_ebs/pcbmes/db/diag/rdbms/pcbmes/pcbmes/trace/pcbmes_ora_16295.trc
Copy the displayed script into a new file script (Createctlf.sql), and edit and save according to the new path, and edit the generated script as follows:
CREATE controlfile Reuse DATABASE "Pcbmes" Resetlogs Noarchivelog
Maxlogfiles 16
Maxlogmembers 3
Maxdatafiles 100
Maxinstances 8
Maxloghistory 292
LOGFILE
GROUP 1 '/ebs/pcbmes/db/apps_st/data/pcbmes/redo01.log ' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/ebs/pcbmes/db/apps_st/data/pcbmes/redo02.log ' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/ebs/pcbmes/db/apps_st/data/pcbmes/redo03.log ' SIZE 50M BLOCKSIZE 512
--STANDBY LOGFILE
DataFile
'/ebs/pcbmes/db/apps_st/data/pcbmes/system01.dbf ',
'/ebs/pcbmes/db/apps_st/data/pcbmes/sysaux01.dbf ',
'/ebs/pcbmes/db/apps_st/data/pcbmes/undotbs01.dbf ',
'/ebs/pcbmes/db/apps_st/data/pcbmes/users01.dbf ',
'/ebs/pcbmes/db/apps_st/data/pcbmes/pcbmes_d_01.dbf ',
'/ebs/pcbmes/db/apps_st/data/pcbmes/pcbmes_d_02.dbf ',
'/ebs/pcbmes/db/apps_st/data/pcbmes/pcbmes_x_01.dbf ',
'/EBS/PCBMES/DB/APPS_ST/DATA/PCBMES/PCBMES_X_02.DBF '
CHARACTER SET ZHS16GBK
;
ALTER DATABASE OPEN resetlogs;
ALTER tablespace TEMP ADD tempfile '/ebs/pcbmes/db/apps_st/data/pcbmes/temp01.dbf '
SIZE 30408704 Reuse autoextend on NEXT 655360 MAXSIZE 32767M;
Second, copy the database file
1. Close the database and monitor
Shutdown immediate;
Lsnrctl stop;
2. Copy files
cp-rh/oracle_ebs/pcbmes/db/. /ebs/pcbmes/db/
Third, modify the target various configuration files
1. Modify the DB configuration file
Cd/ebs/pcbmes/db/tech_st/11.2.0/dbs
VI Initpcbmes.ora
Modify the original path of the configuration into a new path
2. Modify the Monitoring configuration
Cd/ebs/pcbmes/db/tech_st/11.2.0/network/admin
VI Listener.ora
VI Sqlnet.ora
3. Modify User Environment variables
Cd
CP. Profile. Profile.bak
Vi. profile
Iv. re-creation of control files
1. Re-login with the Orames user and check that the environment variables are correct and effective
2. Create a control file
Sqlplus/nolog
Sql> Conn/as sysdba;
sql> startup Nomount pfile= '/ebs/pcbmes/db/tech_st/11.2.0/dbs/initpcbmes.ora ';
sql> @createctlf. sql
Sql> create SPFile from Pfile;
sql> shutdown immediate;
Sql> startup;
3. Start monitoring
Lsnrctl start
ORACLE11G Entire DB migration