ITPub博客

http://space.itpub.net/175005/viewspace-231106[@more@]重建当前incarnation 3的控制文件:*I%_"mmm-iD$X r `ITPUB个人空间'GT"neZ Dl
_ ?Foracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSQL> conn / as sysdbaE"u8p*?o$r*x4EConnected.n7d Rs.f-}"kKgsSQL> alter database backup controlfile to trace;
i1j4V2V FZDatabase altered. G"j?/GVv9fSQL> shutdown immediate8?2S1JNHI0}(U&]VHoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,jav

http://hi.baidu.com/zxtandy/blog/item/2df37dd0ce53008da1ec9c43.html[@more@]2007-07-28 16:29先备份datafile 3,再备份控制文件,然后rename file,datafile resize，shutdown.用dbms_restore恢复出controlfile,mount后进行恢复,可以看到恢复后的数据文件名是rename前的名,alert.log里面并没有因为rename产生的cannot identify/lock data file 10错误, 也就是说rename并没有包含在redo中并被应用. ----- 调置归档模式： SQL> alter system set log_archive_dest = 'd:ora92oradataicearchive' scope=spfile;系统已更改。SQL> alter

http://203.208.39.132/search?q=cache:E7_6z2GXCiAJ:www.oracle.com/technology/global/cn/deploy/availability/htdocs/BR_Overview.htm+oracle+NOARCHIVELOG%E8%83%BD%E5%A4%9F%E6%89%A7%E8%A1%8C%E4%BD%95%E7%A7%8D%E5%A4%87%E4%BB%BD&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy28uf0k-KZ3EWRQtHJrtMP82A61Bmw[@more@]备份与恢复是数据库管理中最重要的方面之一。如果数据库崩溃却没有办法恢复它，那么对企业造成的毁灭性结果可能会是数据丢失、收入减少、客户不满等。不管公司是使用单

http://www.adp-gmbh.ch/ora/admin/backup_recovery/index.html[@more@]BackupA database backup is is a copy of the data stored in a database. There are two types of backups: physical backups and logical backups. A physical backup is a copy of the files that belong to a database at a specific point in type. It can either be a cold backup or hot backup. A logical backup is does not copy the files, instead, it extracts the data into a specific file format (for example with exp.) A backup is needed to r

http://hi.baidu.com/zwfha/blog/item/d11b70c2fa2f5d36e5dd3bf8.html这个文章很好[@more@]mount到open状态时：各个数据文件头的stop SCN值应该与控制文件中记录的数据文件最后SCN相同。如果相同，刚数据库上次是正常关闭，不需要instance recovery.直接打开数据库给用户提供服务； 如果数据文件头的stop SCN与控制文件中的SCN不一致（比如，shutdown abort情况下，数据文件头的stop SCN为无穷大），则需要instance recovery,各个数据文件的SCN不一致，需要恢复到一致状态才能打开数据库。 Instance recovery打开数据库时，各个数据文件头

http://203.208.39.132/search?q=cache:_aEOP-dSjlgJ:hi.baidu.com/zwfha/blog/item/1eac09d1047d613b9b5027c6.html/cmtid/af96d811332b1ecda6ef3f7f+instance+recovery&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_XgZf6LN6YcoqbcWllfTOKBnIvfw[@more@]2007-12-04 15:03先要明白一些概念：日志文件中的信息为了当系统出现failure时，保证事务可以恢复。当用户事务完成发出commit时，总是先等待LGWR进程将事务所需的redo信息写到日志文件（之前可能在redo buffer中）后，才会收到commit c

http://blog.cfan.com.cn/html/92/886492-363017.html这个和老师讲解的大致相同：使用旧的控制文件+redo log中记录把后来加入的控制文件中需要的文件，例如数据文件、日志文件等信息using backup controlfile[@more@]假设条件:CNOUG博客首页1e1x(%lB| A,I1、只做了对控制文件的备份CNOUG博客首页2u'mtF-F:j kf*G2、非归档模式(k"XE2?$U [{03、在对控制文件做了备份以后，创建了一个表空间，并包含一个数据文件CNOUG博客首页OS-aAeoAc4、在新建的表空间下建了一张表，并存了一条数据CNOUG博客首页/J^4vx.c
[D"i

http://203.208.39.132/search?q=cache:0W30-f-vGR0J:www.experts-exchange.com/Database/Oracle/Product_Info/Q_20643126.html+Oracle+_allow_resetlogs_corruption&cd=5&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_LW_AVy-icVpOxO7QQE_ItfJrYew[@more@]This is a two-part question.I have a partially restored database where I have some new, and some older datafiles. Together I have them all. No archivelogs, no anything. This is the path I must take!I have to do a force

http://203.208.39.132/search?q=cache:ZrnX9GSMNm8J:read.newbooks.com.cn/info/195974.html+Oracle+CHECKPOINT_CHANGE%23+%3D+0+v%24datafile&cd=5&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_szIuEy5JwMTxqL6yQfC2lascIyw[@more@]scn号与oracle数据库恢复过程有着密切的关系，只有很好地理解了这层关系，才能深刻地理解恢复的原理，从而才能很好地解决这方面的问题。 一。SCN与CHECKPOINT CKPT进程在checkpoint发生时，将当时的SCN号写入数据文件头和控制文件，同时通知DBWR进程将数

http://203.208.39.132/search?q=cache:URJ2wfFaimAJ:space.itpub.net/9421572/viewspace-206239+Oracle+CHECKPOINT_CHANGE%23+%3D+0+v%24datafile&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy29hYvP54goF6NW8lkZ_9GEQzGYX9Q[@more@]实验1：数据库正常运行时的各个SCN值SQL> select dbms_flashback.get_system_change_number from dual;GET_SYSTEM_CHANGE_NUMBER------------------------ 547250SQL> select checkpoint_change# from v$database;CHECKPOINT_CHANGE

http://203.208.39.132/search?q=cache:4BWUg5KYn24J:www.51testing.com/%3Fuid-1854-action-viewspace-itemid-6579+Oracle+ORA-01190&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2-NWlPJt6kWe9WRaPA4rTZ3fuPnlg[@more@]在进行RMAN操作的时候,当出现了控制文件和数据库文件的SCN不一致的情况,系统不能正常的OPEN,此时出现的错误号码为:ORA-01190此时需要修改init<dbname.ora>_allow_resetlogs_corruption=FALSE将其该为TRUE在SQL命令行中使用create spfile from pflie (将修改后的pf

http://203.208.39.132/search?q=cache:TTlxSoeT0twJ:www.cublog.cn/u/20078/showart.php%3Fid%3D462659+Oracle+ORA-01190:+%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E6%88%96%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6+%E6%9D%A5%E8%87%AA%E6%9C%80%E5%90%8E%E4%B8%80%E4%B8%AA+RESETLOGS+%E4%B9%8B%E5%89%8D&cd=8&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy29-J4kzC8miXSm5tt6gFtH_SInI_g[@more@]SQLPLUS>ALTER DATABASE DATAFILE 2 ONLINE;ALTER DATABASE DATAFILE 2 ONLINE*ERROR 位于第 1 行