- 浏览: 96384 次
- 性别:
- 来自: 新力吐皮
最新评论
-
wpf523:
好,不错啊
Oracle 学习笔记: SYSDBA登陆权限问题 -
saup007:
thank you!~!
Oracle 中减小数据文件大小 -
orcl_zhang:
技术就是可以给老板挣钱,可以造福他人,可以被其他人所用,却可以 ...
什么是技术 -
rain2005:
现在的现实是真正懂js,css,html的开发人员太少了,我见 ...
企业应用UI开发模式 -
weihong01267:
开发出来了 是否开源 一下下 啊 哈哈
企业应用UI开发模式
1. 以sysdba登陆,导出控制文件
alter database backup controlfile to trace;
2. 在%oracle_base%\oradata\%oracle_sid%\udump下找到刚刚创建的trc文件,打开它。可以看到里面包含了两段sql脚本。
-- Below are two sets of SQL statements, each of which creates a new -- control file and uses it to open the database. The first set opens -- the database with the NORESETLOGS option and should be used only if -- the current versions of all online logs are available. The second -- set opens the database with the RESETLOGS option and should be used -- if online logs are unavailable. -- The appropriate set of statements can be copied from the trace into -- a script file, edited as necessary, and executed when there is a -- need to re-create the control file. -- -- Set #1. NORESETLOGS case -- -- The following commands will create a new control file and use it -- to open the database. -- Data used by Recovery Manager will be lost. -- Additional logs may be required for media recovery of offline -- Use this only if the current versions of all online logs are -- available. -- After mounting the created controlfile, the following SQL -- statement will place the database in the appropriate -- protection mode: -- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "EPCIT" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 454 LOGFILE GROUP 1 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITREDO01.LOG' SIZE 10M, GROUP 2 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITREDO02.LOG' SIZE 10M, GROUP 3 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITREDO03.LOG' SIZE 10M -- STANDBY LOGFILE DATAFILE 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITSYSTEM01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITUNDOTBS01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITSYSAUX01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITBLOBS01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITINDEX01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITUSERS01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITWCAUDIT01.DBF' CHARACTER SET UTF8 ; -- Configure RMAN configuration record 1 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','DEVICE TYPE DISK MAXPIECESIZE 100 M'); -- Configure RMAN configuration record 3 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON'); -- Configure RMAN configuration record 4 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON'); -- Configure RMAN configuration record 5 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1'); -- 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. -- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\FLASH_RECOVERY_AREA\EPCIT\ARCHIVELOG\2009_02_22\O1_MF_1_1_%U_.ARC'; -- Recovery is required if any of the datafiles are restored backups, -- or if the last shutdown was not normal or immediate. RECOVER DATABASE -- All logs need archiving and a log switch is needed. ALTER SYSTEM ARCHIVE LOG ALL; -- Database can now be opened normally. ALTER DATABASE OPEN; -- Commands to add tempfiles to temporary tablespaces. -- Online tempfiles have complete space information. -- Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITTEMP01.DBF' SIZE 209715200 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions. -- -- Set #2. RESETLOGS case -- -- The following commands will create a new control file and use it -- to open the database. -- Data used by Recovery Manager will be lost. -- The contents of online logs will be lost and all backups will -- be invalidated. Use this only if online logs are damaged. -- After mounting the created controlfile, the following SQL -- statement will place the database in the appropriate -- protection mode: -- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "EPCIT" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 454 LOGFILE GROUP 1 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITREDO01.LOG' SIZE 10M, GROUP 2 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITREDO02.LOG' SIZE 10M, GROUP 3 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITREDO03.LOG' SIZE 10M -- STANDBY LOGFILE DATAFILE 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITSYSTEM01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITUNDOTBS01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITSYSAUX01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITBLOBS01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITINDEX01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITUSERS01.DBF', 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITWCAUDIT01.DBF' CHARACTER SET UTF8 ; -- Configure RMAN configuration record 1 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','DEVICE TYPE DISK MAXPIECESIZE 100 M'); -- Configure RMAN configuration record 3 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON'); -- Configure RMAN configuration record 4 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON'); -- Configure RMAN configuration record 5 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1'); -- 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. -- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\FLASH_RECOVERY_AREA\EPCIT\ARCHIVELOG\2009_02_22\O1_MF_1_1_%U_.ARC'; -- 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 'D:\PTC\OCU_8.0\ORADATA\EPCIT\EPCITTEMP01.DBF' SIZE 209715200 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions.
第一段sql是在所有online redolog没有丢失,以noresetlogs选项打开数据库的情况下使用的。第二段则是在丢失了online redolog需要resetlogs的情况下使用。
3. 把"Set #1. NORESETLOGS case"下的sql拷贝出来,存为reCreateCtl.sql
4. 以sysdba登陆,shutdown immediate。然后删除所有控制文件。再运行reCreateCtl.sql。
SQL> @reCreateCtl ORACLE instance started. Total System Global Area 251658240 bytes Fixed Size 1248356 bytes Variable Size 83887004 bytes Database Buffers 159383552 bytes Redo Buffers 7139328 bytes Control file created. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. ORA-00283: recovery session canceled due to errors ORA-00264: no recovery required System altered. Database altered. Tablespace altered.
5. 成功创建了控制文件,数据库也正常打开。再没有使用Recovery Catalog的情况下,RMAN的备份资料是存在控制文件中的,重建控制文件会导致丢失备份资料库。
发表评论
-
android adb中查看database
2009-08-04 18:40 19251。首先,emulator必须跑起来。可以通过eclipse或 ... -
Oracle 动态性能表 v$session & v$process
2009-07-03 00:18 10389整理自google出来的网络资源。google是个好东东。没有 ... -
Statspack的Rollback per transaction计算方法
2009-06-27 17:23 2360今天研究statspack report, ... -
Oracle 学习笔记: Statspack安装使用
2009-06-18 10:17 1687俗话说,工欲善其事,必先利其器。做数据库性能分析,也要有一款好 ... -
Oracle 学习笔记:Oracle Explain Plan
2009-06-14 16:13 0运行@utlxplan即可创建plan_table。该文件位于 ... -
Oracle 中减小数据文件大小
2009-06-06 18:59 4214由于要做一个测试,我在users表空间中创建一个表并且插入了5 ... -
Oracle 学习笔记: 正则表达式
2009-05-31 02:36 3721Oracle 10g数据库内建了符 ... -
Oracle 查询表空间使用情况
2009-04-02 22:43 1291通过查询dba_free_space表可以了解一个tables ... -
Oracle 学习笔记: setup recovery catalog
2009-03-18 22:09 11881. Create the database "ca ... -
Oracle 常见问题解决方法 (未完,待续。。。)
2009-03-17 23:43 961. Windows下Oracle10g OEM的Host C ... -
behavior of database backup with "plus archivelog"
2009-03-17 23:40 1054The RMAN reference document say ... -
基本的RAID介绍
2009-03-10 23:23 7076RAID是英文Redundant Array of Indep ... -
Oracle 学习笔记: Backup & Recovery 常用命令
2009-03-06 20:49 41621 . set database to archivelog ... -
Oracle 学习笔记: SYSDBA登陆权限问题
2009-02-18 23:54 6034本文环境配置:Oracle10gR2,Windows XP ... -
Oracle 学习笔记: Oracle10g重新配置Database Control
2009-02-06 14:48 1265由于安装oracle的时候没有设置oracle_hostnam ... -
Oracle 学习笔记: Oracle10g监听端口改变后DB Control无法使用的解决方法
2009-02-03 23:21 1681修改前的listener.ora SID_LIST_L ... -
RAID-5与RAID-10内部分析(转载自piner)
2009-01-23 00:36 1950一直以来,看到关于raid5与raid10的性能之争还是非常多 ...
相关推荐
ORACLE学习笔记:日常应用、深入管理、性能优化.part1
ORACLE学习笔记:日常应用、深入管理、性能优化.part2。
资源名称:Oracle学习笔记-日常应用、深入管理、性能优化内容简介:Oracle学习笔记-日常应用、深入管理、性能优化Oracle 11g是最具代表性的高端关系型数据库管理系统,它在世界各地的大型商务数据库应用系统中被广泛...
Oracle 11g是最具代表性的高端关系型数据库管理系统,它在世界各地的大型商务数据库应用系统中被广泛应用。本书设计了大量的应用情景,介绍了数据库管理员和开发人员常用的管理、维护和优化Oracle 11g数据库的技术和...
Oracle Solaris 11 Oracle Solaris Administration:Devices and File Systems-382
Oracle学习笔记精华版Oracle学习笔记精华版Oracle学习笔记精华版Oracle学习笔记精华版
Oracle学习笔记 脚本运行环境PL/SQL Developer ·数据库的备份与恢复 ·存储过程精简实例
Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记
oracle学习笔记 oracle学习笔记oracle学习笔记 oracle学习笔记
Oracle非常有用的笔记。。。。。。。。。。。Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记
oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记
本文档主要是网易云李兴华老师进行授课时所作笔记,从Oracle11g数据库的安装到复杂查询做了详细的文档记录。
oracle学习笔记,包含所有oracle概念,包,函数,oracle的组成,oracle的plsq,oracle的存储过程,oracle的事务等
Oracle Solaris 11 Oracle Solaris Administration:ZFS File Systems-314
oracle学习笔记-入门基础-01-张园
Oracle学习笔记 以下是我这一周学习oracle整理的笔记,包括课堂的内容和自己看额外看的视频补充的一些内容,基本上囊括了所有oracle的基本知识。主要的形式是例子代码加代码解释加运行结果,我个人认为对于没有学习...
分享给需要的朋友们韩顺平oracle学习笔记.pdf 大家来下载吧!
oracle只能手动添加jar包 下载 sdoapi-11.2.0.jar 包到本地 ...mvn install:install-file -DgroupId=oracle -DartifactId=sdoapi -Dversion=11.2.0 -Dpackaging=jar -Dfile=E:\Dnloads\sdoapi-11.2.0.jar