• 博客访问: 557147
  • 博文数量: 72
  • 用 户 组: 普通用户
  • 注册时间: 2008-11-26 14:59
个人简介

暂无介绍

文章分类

全部博文(72)

文章存档

2016年(1)

2012年(1)

2009年(3)

2008年(8)

2007年(6)

2006年(22)

2005年(29)

2004年(2)

我的朋友

分类: IT综合

2005-03-08 13:37:32

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方式备份控制文件,获取控制文件创建脚本,方便手工创建控制文件.

[@more@]

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
;

阅读(473719) | 评论(0) | 转发(0) |
1

上一篇:表空间级数据库备份恢复

下一篇:crontab

给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册