1> 最首要的备份方法是将控制文件备份为二进制文件.
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/cf.bak' REUSE;
reuse:参数reuse的含义是可以直接将/oracle/backup/cf.bak代替现在的控制文件
2>
A binary backup is preferable to a trace file backup because it
contains additional information such as the archived log history, offline range for
read-only and offline tablespaces, and backup sets and copies (if you use RMAN).
Note that binary control file backups do not include tempfile entries.
3> to trace方式备份控制文件,获取控制文件创建脚本,方便手工创建控制文件.
1> 最首要的备份方法是将控制文件备份为二进制文件.
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/cf.bak' REUSE;
reuse:参数reuse的含义是可以直接将/oracle/backup/cf.bak代替现在的控制文件
2>
A binary backup is preferable to a trace file backup because it
contains additional information such as the archived log history, offline range for
read-only and offline tablespaces, and backup sets and copies (if you use RMAN).
Note that binary control file backups do not include tempfile entries.
3> to trace方式备份控制文件,获取控制文件创建脚本,方便手工创建控制文件.
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
数据库已更改。
SQL> show parameter user_dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string D:oracleadminliyongudump
通过打开D:oracleadminliyongudump目录最近产生的trace文件,
可以手工创建控制文件.
CREATE CONTROLFILE REUSE DATABASE "LIYONG" NORESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'D:ORACLEORADATALIYONGREDO01.LOG' SIZE 100M,
GROUP 2 'D:ORACLEORADATALIYONGREDO02.LOG' SIZE 100M,
GROUP 3 'D:ORACLEORADATALIYONGREDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'D:ORACLEORADATALIYONGSYSTEM01.DBF',
'D:ORACLEORADATALIYONGUNDOTBS01.DBF',
'D:ORACLEORADATALIYONGCWMLITE01.DBF',
'D:ORACLEORADATALIYONGDRSYS01.DBF',
'D:ORACLEORADATALIYONGEXAMPLE01.DBF',
'D:ORACLEORADATALIYONGINDX01.DBF',
'D:ORACLEORADATALIYONGODM01.DBF',
'D:ORACLEORADATALIYONGTOOLS01.DBF',
'D:ORACLEORADATALIYONGUSERS01.DBF',
'D:ORACLEORADATALIYONGXDB01.DBF',
'D:ORACLEORADATALIYONGBUSINESS.DBF',
'D:ORACLEORADATALIYONGBILLING.DBF'
CHARACTER SET ZHS16GBK
;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/76065/viewspace-791939/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/76065/viewspace-791939/