修改數據庫名稱:

SQL> alter database backup controlfile to trace resetlogs;
在/u01/app/oracle/admin/qhfpcdb01/udump下找到剛創建的跟蹤文件,并把REUSE修改為SET,同時修改數據庫名稱.

CREATE CONTROLFILE REUSE DATABASE "QHFPCDB01" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 200
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '/u01/oradata/qhfpcdb01/redo01a.log',
    '/u02/oradata/qhfpcdb01/redo01b.log',
    '/u03/oradata/qhfpcdb01/redo01c.log'
  ) SIZE 100M,
  GROUP 2 (
    '/u01/oradata/qhfpcdb01/redo02a.log',
    '/u02/oradata/qhfpcdb01/redo02b.log',
    '/u03/oradata/qhfpcdb01/redo02c.log'
  ) SIZE 100M,
  GROUP 3 (
    '/u01/oradata/qhfpcdb01/redo03a.log',
    '/u02/oradata/qhfpcdb01/redo03b.log',
    '/u03/oradata/qhfpcdb01/redo03c.log'
  ) SIZE 100M
-- STANDBY LOGFILE
DATAFILE
  '/u02/oradata/qhfpcdb01/system01.dbf',
  '/u02/oradata/qhfpcdb01/undotbs01.dbf',
  '/u02/oradata/qhfpcdb01/sysaux01.dbf',
  '/u02/oradata/qhfpcdb01/users01.dbf',
  '/u02/oradata/qhfpcdb01/tbs_swr01.dbf',
  '/u02/oradata/qhfpcdb01/ndx_swr01.dbf'
CHARACTER SET ZHT16MSWIN950;

創建pfile文件
SQL> create pfile from spfile;

關閉數據庫,并修改pfile中db_name及db_unique_name參數,
備份控制文件并刪除之,若不刪除會在後續創建控制文件時提示錯誤.

用修改后的pfile啟動數據庫:
SQL> startup nomount pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initqhfpcdb01.ora';

創建spfile:
SQL> create spfile from pfile;

使用修改后的trace文件創建控制文件:
SQL> @2.sql
Control file created.

使用RESETLOGS方式打開數據庫.
SQL> alter database open RESETLOGS;
Database altered.

SQL> select name from v$database;
NAME
---------
QHFPCDB

修改完畢.