ORACLE11G Entire DB migration

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