Oracle用户手工备份控制文件，trace和映像副本

最新推荐文章于 2021-04-12 19:58:43 发布

Demonson

最新推荐文章于 2021-04-12 19:58:43 发布

阅读量1k

点赞数

分类专栏： Oracle数据库备份恢复文章标签：备份 controlfile trace

本文链接：https://blog.csdn.net/demonson/article/details/39580997

版权

Oracle数据库同时被 2 个专栏收录

146 篇文章 8 订阅

订阅专栏

备份恢复

52 篇文章 0 订阅

订阅专栏

用户备份控制文件的方式包括： 1.创建为映像副本，写入到指定名称的文件：

SQL> ALTER DATABASE BACKUP CONTROLFILE TO
'/u01/backup/controlfile.bak';

Database altered.

2.生成重新创建控制文件的脚本，写入到跟踪文件：

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Database altered. --重建控制文件的脚本在$ORACLE_BASE/diag/rdbms/prod/PROD/trace

查看刚生成脚本文件，会发现里面会有两种创建控制文件的方式：

1.NORESETLOGS ARCHIVELOG，表示日志文件等完好，重启数据库是不用resetlog；

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD" NORESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
    '/u01/app/oracle/oradata/PROD/onlinelog/o1_mf_1_b2255npg_.log',
    '/u01/app/oracle/fast_recovery_area/PROD/onlinelog/o1_mf_1_b2255nxl_.log'
) SIZE 50M BLOCKSIZE 512,
GROUP 2 (
    '/u01/app/oracle/oradata/PROD/onlinelog/o1_mf_2_b2255zsg_.log',
    '/u01/app/oracle/fast_recovery_area/PROD/onlinelog/o1_mf_2_b22560gb_.log'
) SIZE 50M BLOCKSIZE 512,
GROUP 3 (
    '/u01/app/oracle/oradata/PROD/onlinelog/o1_mf_3_b22567o2_.log',
    '/u01/app/oracle/fast_recovery_area/PROD/onlinelog/o1_mf_3_b2256827_.log'
) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_system_b2251bs1_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_b2251bvo_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_b2251bw5_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_users_b2251byw_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_example_b2257d0c_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/tbs_move_01.dbf'
CHARACTER SET AL32UTF8
;

2.RESETLOGS ARCHIVELOG；日志文件损坏丢失，不能执行完全恢复，将日志组号清零；

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
    '/u01/app/oracle/oradata/PROD/onlinelog/o1_mf_1_b2255npg_.log',
    '/u01/app/oracle/fast_recovery_area/PROD/onlinelog/o1_mf_1_b2255nxl_.log'
) SIZE 50M BLOCKSIZE 512,
GROUP 2 (
    '/u01/app/oracle/oradata/PROD/onlinelog/o1_mf_2_b2255zsg_.log',
    '/u01/app/oracle/fast_recovery_area/PROD/onlinelog/o1_mf_2_b22560gb_.log'
) SIZE 50M BLOCKSIZE 512,
GROUP 3 (
    '/u01/app/oracle/oradata/PROD/onlinelog/o1_mf_3_b22567o2_.log',
    '/u01/app/oracle/fast_recovery_area/PROD/onlinelog/o1_mf_3_b2256827_.log'
) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_system_b2251bs1_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_b2251bvo_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_b2251bw5_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_users_b2251byw_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/o1_mf_example_b2257d0c_.dbf',
'/u01/app/oracle/oradata/PROD/datafile/tbs_move_01.dbf'
CHARACTER SET AL32UTF8
;