Oracle认证:Oracle控制件文件修复
查看文件头SCN号:
SQL> select file#, checkpoint_change# from v;
FILE# CHECKPOINT_CHANGE#
1 18120070
2 18120070
3 18120070
4 18120070
5 18120070
6 18120070
7 18120070
8 18120070
9 18120070
10 18120070
11 18121207
FILE# CHECKPOINT_CHANGE#
12 18121196
12 rows selected.
查看控制文件SCN号:
SQL> select file#, checkpoint_change# from v;
FILE# CHECKPOINT_CHANGE#
1 18120070
2 18120070
3 18120070
4 18120070
5 18120070
6 18120070
7 18120070
8 18120070
9 18120070
10 18120070
11 18121207
FILE# CHECKPOINT_CHANGE#
12 18121196
12 rows selected.
SQL>
当数据文件SCN号大于控制文件scn号,即会发生控制文件太久的提示,
当数据文件SCN号小于控制文件scn号时, 则提示mediea recovery提示
当数据文件sCN号等于控制文件scn号,正常启动实例
SQL> ALter database backup controlfile to trace as '/u01/Oracle/admin/ora9i/udump/';
Database altered.
SQL>
/u01/Oracle/oradata/ora9i
[oracle@test ora9i]$ rm control0*
[oracle@test ora9i]$
SQL> shutdown immediate;
ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/u01/Oracle/oradata/ora9i/'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort;
ORACLE instance shut down.
SQL>
修改备份文件使用第一个sql
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORA9I" NORESETLOGS ARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 '/u01/Oracle/oradata/ora9i/' SIZE 100M,
GROUP 2 '/u01/Oracle/oradata/ora9i/' SIZE 100M,
GROUP 3 '/u01/Oracle/oradata/ora9i/' SIZE 100M
DATAFILE
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/app1_'
CHARACTER SET ZHS16GBK
;
# Configure RMAN configuration record 1
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := _BACKUP_ONFIG('CONTROLFILE AUTOBACKUP','ON');
# 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 '/u01/Oracle/oradata/ora9i/' REUSE;
# End of tempfile additions.
#
-
Oracle认证:oracle中小写转换成大写方法
在学习Oracle认证过程中,每个人会遇到每个人不同的问题,或小或大,真心希望同学们能少受些折磨,多得一些成就感与豁然开朗的'感觉,这样的学习才能化被动为主动,越学越快乐。Sql代码selectSPEC_CODE,item_number,self_item_code,MASTER_FLG,update_datefromif__mwhere...
-
oracle用户认证和密码设置技巧
ORACLE用户认证和密码字体:小中大|打印发表于:2007-11-3014:06作者:freellf来源:CNOUG博客首页ORACLE_HOME:oracle安装目录,ORACLE_SID:oracle实例名。以上两个环境变量都可以注册表里面找到,注册表的路径是:HKEY_LOCAL_MACHINE=>SOFTWARE=>ORACLE=>HOME0[size=10.5...
-
Oracle数据库语句大全
Oracle数据库是甲骨文公司的一款关系数据库管理系统。它是在数据库领域一直处于领先地位的产品。下面yjbys小编为大家分享的是Oracle数据库查询语句,希望能帮助到大家!一.入门部分1.创建表空间createtablespaceschooltbsdatafile‘D:\oracle\datasource...
-
OracleDBA面试题汇总
1.解释冷备份和热备份的不同点以及各自的优点解答:热备份针对归档模式的数据库,在数据库仍旧处于工作状态时进行备份。而冷备份指在数据库关闭后,进行备份,适用于所有模式的数据库。热备份的优点在于当备份时,数据库仍旧可以被使用并且可以将数据库恢复到任意一个时...
相关文章
- 高中生优秀英语作文:Have a break away from electronics
- Oracle认证:Oracle内存结构研究-PGA篇
- Oracle认证:oracle中小写转换成大写方法
- Oracle认证:Win7下Oracle11g完全删除
- Oracle认证:OracleTRUNC函数详解
- Oracle认证:ORACLE绑定变量BINDPEEKING
- Oracle认证:Oracle避免全表扫描方式
- Choice of large enterprises or small英语四级作文
- Oracle认证:Freebufferwaits等待事件总结
- 英语作文:大学生村官 College Graduates Work as Village Offic