cd $ORACLE_BASE/oradata
tar -zxvf PROD1.tar
1.5 check path and SID
vi initPROD1.ora
modify "/u01" to "/s01"
PROD1.__db_cache_size=687865856
PROD1.__java_pool_size=16777216
PROD1.__large_pool_size=16777216
PROD1.__oracle_base='/s01/app/oracle'#ORACLE_BASE set from environment
PROD1.__pga_aggregate_target=687865856
PROD1.__sga_target=1006632960
PROD1.__shared_io_pool_size=0
PROD1.__shared_pool_size=268435456
PROD1.__streams_pool_size=0
*.audit_file_dest='/s01/app/oracle/admin/PROD1/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/app/oracle/oradata/PROD1/control01.ctl','/s01/app/oracle/oradata/PROD1/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='PROD1'
*.diagnostic_dest='/s01/app/oracle'
*.memory_target=1686110208
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
according to :*.audit_file_dest='/s01/app/oracle/admin/PROD1/adump'
[oracle@oel6 oradata]$ mkdir -p /s01/app/oracle/admin/PROD1/adump
vi control01.txt
modify "/u01" to "/s01"
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD1" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/s01/app/oracle/oradata/PROD1/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/s01/app/oracle/oradata/PROD1/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/s01/app/oracle/oradata/PROD1/redo03.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/s01/app/oracle/oradata/PROD1/system01.dbf',
'/s01/app/oracle/oradata/PROD1/sysaux01.dbf',
'/s01/app/oracle/oradata/PROD1/undotbs01.dbf',
'/s01/app/oracle/oradata/PROD1/users01.dbf'
CHARACTER SET AL32UTF8
;
cd /s01/app/oracle/oradata/PROD1
rm control*
1.6 create spfile from pfile-137 PROD1
[oracle@oel6 PROD1]$ export ORACLE_SID=PROD1
[oracle@oel6 PROD1]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 31 16:15:13 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
@>connect sys/oracle as sysdba
Connected to an idle instance.
SYS@PROD1>create spfile from pfile;
File created.
SYS@PROD1>startup nomount
ORACLE instance started.
Total System Global Area 1686925312 bytes
Fixed Size 2213976 bytes
Variable Size 989857704 bytes
Database Buffers 687865856 bytes
Redo Buffers 6987776 bytes
SYS@PROD1>CREATE CONTROLFILE REUSE DATABASE "PROD1" RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 '/s01/app/oracle/oradata/PROD1/redo01.log' SIZE 50M BLOCKSIZE 512,
9 GROUP 2 '/s01/app/oracle/oradata/PROD1/redo02.log' SIZE 50M BLOCKSIZE 512,
10 GROUP 3 '/s01/app/oracle/oradata/PROD1/redo03.log' SIZE 50M BLOCKSIZE 512
11 -- STANDBY LOGFILE
12 DATAFILE
13 '/s01/app/oracle/oradata/PROD1/system01.dbf',
14 '/s01/app/oracle/oradata/PROD1/sysaux01.dbf',
15 '/s01/app/oracle/oradata/PROD1/undotbs01.dbf',
16 '/s01/app/oracle/oradata/PROD1/users01.dbf'
17 CHARACTER SET AL32UTF8
18 ;
Control file created.
SYS@PROD1>shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS@