【Oracle数据库复制(改名)】

noel0217

*********************************************　　生成控制文件
　　-bash-3.00# cd /opt/oracle/product/10.2.0/admin/YAN/udump
　　-bash-3.00# cat orcl_ora_3901.trc
　　将最后一段考呗出来

　　-- >　　STARTUP NOMOUNT
　　CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS  NOARCHIVELOG
　　MAXLOGFILES 16
　　MAXLOGMEMBERS 3
　　MAXDATAFILES 100
　　MAXINSTANCES 8
　　MAXLOGHISTORY 292
　　LOGFILE

　　GROUP 1 '/opt/oracle/product/10.2.0/oradata/ORCL/redo01.log' >
　　GROUP 2 '/opt/oracle/product/10.2.0/oradata/ORCL/redo02.log' >
　　GROUP 3 '/opt/oracle/product/10.2.0/oradata/ORCL/redo03.log' >　　-- STANDBY LOGFILE
　　DATAFILE
　　'/opt/oracle/product/10.2.0/oradata/ORCL/system01.dbf',
　　'/opt/oracle/product/10.2.0/oradata/ORCL/undotbs01.dbf',
　　'/opt/oracle/product/10.2.0/oradata/ORCL/sysaux01.dbf',
　　'/opt/oracle/product/10.2.0/oradata/ORCL/users01.dbf'
　　CHARACTER SET WE8ISO8859P1
　　;
　　-- Commands to re-create incarnation table
　　-- Below log names MUST be changed to existing filenames on
　　-- disk. Any one log file from each branch can be used to
　　-- re-create incarnation records.

　　-->
　　-->　　-- Recovery is required if any of the datafiles are restored backups,
　　-- or if the last shutdown was not normal or immediate.
　　RECOVER DATABASE USING BACKUP CONTROLFILE
　　-- Database can now be opened zeroing the online logs.
　　ALTER DATABASE OPEN RESETLOGS;
　　-- Commands to add tempfiles to temporary tablespaces.
　　-- Online tempfiles have complete space information.
　　-- Other tempfiles may require adjustment.
　　ALTER TABLESPACE TEMP ADD TEMPFILE '/opt/oracle/product/10.2.0/oradata/ORCL/temp01.dbf'

　　>　　-- End of tempfile additions.
　　--