[每日一题] 11gOCP 1z0-052 :2013-09-8 用户管理下的热备报错:ORA-01123.................................A45
来源:互联网 发布:特朗普段子知乎 编辑:程序博客网 时间:2024/06/04 23:41
转载请注明出处:http://blog.csdn.net/guoyjoe/article/details/11408889
正确答案:B
做热备的前提条件是一定要开归档,可以用以下几种方式查一下有没有开归档:
方法一:
sys@OCM> archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination /archOldest online log sequence 2Next log sequence to archive 4Current log sequence 4
方法二:查视图
sys@OCM> select log_mode from v$database;LOG_MODE------------NOARCHIVELOG
方法三:转出CONTROLFILE的创建脚本:
sys@OCM> alter database backup controlfile to trace as '/tmp/control.txt';Database altered.CREATE CONTROLFILE REUSE DATABASE "OCM" NORESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 '/u01/app/oracle/oradata/ocm/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '/u01/app/oracle/oradata/ocm/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '/u01/app/oracle/oradata/ocm/redo03.log' SIZE 50M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE '/u01/app/oracle/oradata/ocm/system01.dbf', '/u01/app/oracle/oradata/ocm/sysaux01.dbf', '/u01/app/oracle/oradata/ocm/undotbs01.dbf', '/u01/app/oracle/oradata/ocm/users01.dbf', '/u01/app/oracle/oradata/ocm/example01.dbf', '/u01/app/oracle/oradata/ocm/gyj01.dbf', '/u01/app/oracle/oradata/ocm/gyj02.dbf', '/u01/app/oracle/oradata/ocm/tp01.dbf'CHARACTER SET ZHS16GBK;
提供用户管理热备的脚本:
sys@OCM> SELECT 'alter tablespace '||tablespace_name||' begin backup;'||chr(10)|| 2 '!cp '||file_name||' /backup/hot'||chr(10)|| 3 'alter tablespace '||tablespace_name||' end backup;' 4 FROM dba_data_files;'ALTERTABLESPACE'||TABLESPACE_NAME||'BEGINBACKUP;'||CHR(10)||'!CP'||FILE_NAME||'/BACKUP/HOT'||CHR(10)||'ALTERTABLESPACE'||TABLESPACE_NAME||'ENDBACKUP;'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------alter tablespace TP1 begin backup;!cp /u01/app/oracle/oradata/ocm/tp01.dbf /backup/hotalter tablespace TP1 end backup;alter tablespace GYJ begin backup;!cp /u01/app/oracle/oradata/ocm/gyj02.dbf /backup/hotalter tablespace GYJ end backup;alter tablespace GYJ begin backup;!cp /u01/app/oracle/oradata/ocm/gyj01.dbf /backup/hotalter tablespace GYJ end backup;alter tablespace EXAMPLE begin backup;!cp /u01/app/oracle/oradata/ocm/example01.dbf /backup/hotalter tablespace EXAMPLE end backup;alter tablespace USERS begin backup;!cp /u01/app/oracle/oradata/ocm/users01.dbf /backup/hotalter tablespace USERS end backup;alter tablespace UNDOTBS1 begin backup;!cp /u01/app/oracle/oradata/ocm/undotbs01.dbf /backup/hotalter tablespace UNDOTBS1 end backup;alter tablespace SYSAUX begin backup;!cp /u01/app/oracle/oradata/ocm/sysaux01.dbf /backup/hotalter tablespace SYSAUX end backup;alter tablespace SYSTEM begin backup;!cp /u01/app/oracle/oradata/ocm/system01.dbf /backup/hotalter tablespace SYSTEM end backup;
对于用户管理下热备的底层原理在以后的题目中到再来解析。。。
QQ:252803295
技术交流QQ群:
DSI&Core Search Ⅰ 群:127149411(2000人技术群:未满)
DSI&Core Search Ⅱ 群:177089463(1000人技术群:未满)
DSI&Core Search Ⅲ 群:284596437(500人技术群:未满)
DSI&Core Search Ⅳ 群:192136702(500人技术群:未满)
DSI&Core Search Ⅴ 群:285030382(500人闲聊群:未满)
MAIL:dbathink@hotmail.com
BLOG: http://blog.csdn.net/guoyjoe
WEIBO:http://weibo.com/guoyJoe0218
ITPUB: http://www.itpub.net/space-uid-28460966.html
OCM: http://education.oracle.com/education/otn/YGuo.HTM
- [每日一题] 11gOCP 1z0-052 :2013-09-8 用户管理下的热备报错:ORA-01123.................................A45
- [每日一题] 11gOCP 1z0-052 :2013-09-19 创建用户...................................................B41
- [每日一题] 11gOCP 1z0-052 :2013-09-28 ORA-01555: snapshot too old......................C52
- [每日一题] 11gOCP 1z0-052 :2013-08-30 差异的增量备份.....................................................A1
- [每日一题] 11gOCP 1z0-052 :2013-08-31 数据库的存储结构....................................................A8
- [每日一题]11gOCP 1z0-052 :2013-09-11 MGR_ROLE role..........................................A66
- [每日一题] 11gOCP 1z0-052 :2013-09-1 RMAN-- repair failure........................................A20
- [每日一题] 11gOCP 1z0-052 :2013-09-3 Because of frequent checkpoints...........................A30
- [每日一题] 11gOCP 1z0-052 :2013-09-4 block header grows............................................A33
- [每日一题] 11gOCP 1z0-052 :2013-09-6 DBMS_STATS.SET_TABLE_PREFS()使用...............................A37
- [每日一题] 11gOCP 1z0-052 :2013-09-9 PL/SQL package body...........................................A46
- [每日一题] 11gOCP 1z0-052 :2013-09-10 ABOUT ALERTS...............................................A50
- [每日一题] 11gOCP 1z0-052 :2013-09-12 SELECT_CATALOG_ROLE角色....................................A68
- [每日一题] 11gOCP 1z0-052 :2013-09-13 FAST_START_MTTR_TARGET.........................................A69
- [每日一题] 11gOCP 1z0-052 :2013-09-14 repeated parsing activity.................................A70
- [每日一题] 11gOCP 1z0-052 :2013-09-15 Enterprise Manager Support Workbench..................B9
- [每日一题] 11gOCP 1z0-052 :2013-09-16 shared server mode........................................B21
- [每日一题] 11gOCP 1z0-052 :2013-09-17 DRA--Data Recovery Advisor.............................B31
- webgrind安装使用详细说明
- 新浪微博布局学习——活用RelativeLayout
- UVa 11752 The Super Powers (数学)
- CString常用方法简介
- 第三十三篇·构建个人的服务器
- [每日一题] 11gOCP 1z0-052 :2013-09-8 用户管理下的热备报错:ORA-01123.................................A45
- Android图像开源视图:SmartImageView
- Java内存泄露
- 默写js日历控件和详细注释(非原创 原作者:@author KimSoft (jinqinghua [at] gmail.com)
- Ubuntu下安装Bochs各种奇怪错误汇总
- 分享功能实现
- 用C++模板来展示new与delete操作符原理
- 我是如何开发一个连锁企业的信息系统的,NO.1
- HDU 4714 Tree2cycle 构造出一种链的方法