修改数据库文件位置的脚本
 select 'alter database rename file '''||name|| ''' to '||'''/bk/orahf'||substr(name,23)||''';'  from v$datafile
 union
 select 'alter database rename file '''||member|| ''' to '||'''/bk/orahf'||substr(member,23)||''';'  from v$logfile
 union
 select 'alter database rename file '''||name|| ''' to '||'''/bk/orahf'||substr(name,23)||''';'  from v$tempfile;



'ALTERDATABASERENAMEFILE'''||NAME||'''TO'||'''/BK/ORAHF'||SUBSTR(NAME,23)||''';'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
alter database rename file '/ora10g/oradata/ora10g/example01.dbf' to '/bk/orahf/example01.dbf';
alter database rename file '/ora10g/oradata/ora10g/qq.dbf' to '/bk/orahf/qq.dbf';
alter database rename file '/ora10g/oradata/ora10g/redo01.log' to '/bk/orahf/redo01.log';
alter database rename file '/ora10g/oradata/ora10g/redo02.log' to '/bk/orahf/redo02.log';
alter database rename file '/ora10g/oradata/ora10g/redo03.log' to '/bk/orahf/redo03.log';
alter database rename file '/ora10g/oradata/ora10g/sysaux01.dbf' to '/bk/orahf/sysaux01.dbf';
alter database rename file '/ora10g/oradata/ora10g/system01.dbf' to '/bk/orahf/system01.dbf';
alter database rename file '/ora10g/oradata/ora10g/temp01.dbf' to '/bk/orahf/temp01.dbf';
alter database rename file '/ora10g/oradata/ora10g/undotbs01.dbf' to '/bk/orahf/undotbs01.dbf';
alter database rename file '/ora10g/oradata/ora10g/users01.dbf' to '/bk/orahf/users01.dbf';



热备数据库表空间的脚本

select 'alter tablespace '||tablespace_name||' begin backup;'
||chr(10)
||'host copy '||file_name||' c:\bk'
||chr(10)
||'alter tablespace '||tablespace_name||' end backup;'
 from dba_data_files order by tablespace_name;


'ALTERTABLESPACE'||TABLESPACE_NAME||'BEGINBACKUP;'||CHR(10)||'HOSTCOPY'||FILE_NAME||'C:\BK'||CHR(10)
----------------------------------------------------------------------------------------------------
alter tablespace EXAMPLE begin backup;
host copy /ora10g/oradata/ora10g/example01.dbf c:\bk
alter tablespace EXAMPLE end backup;


alter tablespace SYSAUX begin backup;
host copy /ora10g/oradata/ora10g/sysaux01.dbf c:\bk
alter tablespace SYSAUX end backup;


alter tablespace SYSTEM begin backup;
host copy /ora10g/oradata/ora10g/system01.dbf c:\bk
alter tablespace SYSTEM end backup;


alter tablespace UNDOTBS1 begin backup;
host copy /ora10g/oradata/ora10g/undotbs01.dbf c:\bk
alter tablespace UNDOTBS1 end backup;


alter tablespace USERS begin backup;
host copy /ora10g/oradata/ora10g/users01.dbf c:\bk
alter tablespace USERS end backup;


热备 控制文件
Alter database backup controlfile to ‘c:\bk\control。bak’;


重新建立新的控制文件。可以修改大小
使用noresetlogs 选项
CREATE CONTROLFILE REUSE DATABASE "O10" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'D:\ORACLE\ORADATA\O10\REDO01.LOG' SIZE 50M,
GROUP 2 'D:\ORACLE\ORADATA\O10\REDO02.LOG' SIZE 50M
DATAFILE
'D:\ORACLE\ORADATA\O10\SYSTEM01.DBF',
………………
CHARACTER SET ZHS16GBK;