主oracle服务器
set ORACLE_SID=duxiu
sqlplus / as sysdba
show parameter name;
create pfile from spfile;
将生成的pfile 拷贝到备机上
oradim -NEW -SID duxiu
set ORACLE_SID=duxiu
sqlplus / as sysdba
startup mount pfile='F:\oracle\product\10.2.0\db_1\dbs\initduxiu.ora';
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\SYSTEM01.DBF
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\UNDOTBS01.DBF
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\SYSAUX01.DBF
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\USERS01.DBF
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\NBDL
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\UNDOTBS01.DBF
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\SYSAUX01.DBF
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\USERS01.DBF
F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\NBDL
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\SYSTEM01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\system01.dbf';
\SYSTEM01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\system01.dbf';
数据库已更改。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\UNDOTBS01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\UNDOTBS01.dbf';
\UNDOTBS01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\UNDOTBS01.dbf';
数据库已更改。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\SYSAUX01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\SYSAUX01.dbf';
\SYSAUX01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\SYSAUX01.dbf';
数据库已更改。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\USERS01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\USERS01.dbf';
\USERS01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\USERS01.dbf';
数据库已更改。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\REDO01.LOG' to 'F:\oracle\product\10.2.0\oradata\duxiu\REDO01.LOG';
\REDO01.LOG' to 'F:\oracle\product\10.2.0\oradata\duxiu\REDO01.LOG';
数据库已更改。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\REDO02.LOG' to 'F:\oracle\product\10.2.0\oradata\duxiu\REDO02.LOG';
\REDO02.LOG' to 'F:\oracle\product\10.2.0\oradata\duxiu\REDO02.LOG';
数据库已更改。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\REDO03.LOG' to 'F:\oracle\product\10.2.0\oradata\duxiu\REDO03.LOG';
\REDO03.LOG' to 'F:\oracle\product\10.2.0\oradata\duxiu\REDO03.LOG';
数据库已更改。
SQL> ALTER DATABASE OPEN;
数据库已更改。
SQL> CREATE SPFILE FROM pfile='F:\oracle\product\10.2.0\db_1\dbs\initduxiu.ora';
文件已创建。
SQL> SHUTDOWN IMMEDIATE
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> STARTUP MOUNT
ORACLE 例程已经启动。
Total System Global Area 1258291200 bytes
Fixed Size 1250548 bytes
Variable Size 486542092 bytes
Database Buffers 763363328 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\TEMP01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\TEMP01.DBF';
Fixed Size 1250548 bytes
Variable Size 486542092 bytes
Database Buffers 763363328 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> alter database rename file 'F:\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU
\TEMP01.DBF' to 'F:\oracle\product\10.2.0\oradata\duxiu\TEMP01.DBF';
数据库已更改。
SQL> ALTER DATABASE OPEN;
数据库已更改。
SQL> SELECT * FROM DBA_TEMP_FILES;
FILE_NAME
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\TEMP01.DBF
1 TEMP 20971520 2560 AVAILABLE
1 YES 3.4360E+10 4194302 80 19922944 2432
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\TEMP01.DBF
1 TEMP 20971520 2560 AVAILABLE
1 YES 3.4360E+10 4194302 80 19922944 2432
SQL>