ITPub博客

最近在为客户考虑做这样的事情，环境也是linux下的10g，参考一下下面的文章。http://blog.sina.com.cn/s/blog_51722e060101hgvo.htmlhttp://blog.sina.com.cn/s/blog_51722e060101hgvs.htmlhttp://blog.sina.com.cn/s/blog_51722e060101hgvu.htmlhttp://blog.sina.com.cn/s/blog_51722e060101hgvv.htmlhttp://blo...

具体步骤如下（因为先在12.1中测试，然后才在112.测试，因此这里的测试记录了发现的一些问题和处理方法，而11.2中模拟主机损坏，直接使用了这里的经验，因此没有任何报错信息）：1，安装12.1.0.2的GI软件，如果需要也apply最新的PSU，然后查看磁盘和磁盘组：[grid@lunarrac ~]$ kfod disks=all ds=true cluster=true stat...

[root@rac1 ~]# dsmadmcIBM Tivoli Storage ManagerCommand Line Administrative Interface - Version 6, Release 4, Level 0.1(c) Copyright by IBM Corporation and other(s) 1990, 2012. All Rights Reserved.Enter your user id:  adminEnter your password: Session established with serv...

http://blog.sina.com.cn/s/blog_64e1665801015n5o.html防止連接過期拷貝如下。示例SELECT 命令可以定制各种查询。为了说明此命令的作用，本节包含许多示例。当然，还有许多可能性。 注:查询输出仅用于更复杂的命令，以显示其格式。获得一个可用来查询 IBM Tivoli Storage Man...

备查。define library FileLib libtype=file share=yesDEFINE DEVCLASS tsmdev DEVTYPE=FILE MAXCAPACITY=2G DIRECTORY=/tsmpool shared=yes mountlimit=20 library=filelibupdate devclass tsmdev library=filelibDEFINE STGPOOL stg_ora tsmdev ACCESS=READWRITE COLLOCATE=NO MAXSCRATCH=20 REUSEDELAY=0...

RB segs的结果nocatalog方式下一直显示的是***，在catalog方式下可以显示出YES和NO，讲课时发现的随手记录一下。[@more@]C:>rman target / nocatalogRecovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 21 15:34:05 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: TEST (DBID=2118208806)using target database control file instead of recovery catalogRMAN> report schema;Report of database schema for database with db_unique_name TESTList

在恢复的提示中以及alert中都能清楚的发现，如果是不完全恢复那么只会寻找归档而不会去使用redo[@more@]SQL> recover database;ORA-00279: change 715107 generated at 04/26/2013 09:32:44 needed for thread 1ORA-00289: suggestion :E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_43_8QMPCSPY_.ARCORA-00280: change 715107 for thread 1 is in sequence #43Specify log: {<RET>=suggested | filename | AUTO | CANCEL}autoORA-00279: change 715136 generated at 04/26/2013 09:33:45 needed for thread 1ORA

snapshot control file.A copy of a database control file created in an operating system-specific location by Recovery Manager. RMAN creates the snapshot control file so that it has a consistent version of a control file to use when either resynchronizing the recovery catalog or backing up the control file.[@more@]When RMAN must resynchronize the recovery catalog with a read-consistent version of the control file, it creates a temporary snapshot control file. RMAN needs a snapshot control file whe

windows下的变量的使用还真不熟悉，看到一个客户的机器上部署了自动备份脚本，拿过来学习、备查。[@more@]rem 计划任务运行：D:DatabaseBackup数据库备份脚本.BAT mchis fybj runbest fybj istruncaterem 计划任务运行：D:DatabaseBackup数据库备份脚本.BAT mhealth mhealth runbest mhealth mhealthtruncate@echo offrem 脚本路径 备份文件名 数据库用户名 用户密码 服务名 辅助脚本文件名rem 分娩数据备份 D:Backup数据库备份脚本.BAT mchis fybj runbest fybj mchistruncaterem 建册数据备份 D:Backup数据库备份脚本.BAT mhealth mheal

前几天群里的一个哥们说db在处于begin backup模式shutdown之后起不来了，今天讲备份恢复顺道测试了一下，发现还是可以起来的，但是生产环境的话还是要注意，最好不要这么做。[@more@]SQL> alter tablespace users begin backup;Tablespace altered.SQL> shutdown immediateORA-01149: cannot shutdown - file 4 has online backup setORA-01110: data file 4: 'E:ORACLEORADATATESTUSERS01.DBF'SQL> shutdown abortORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1071333376 bytes

给客户在做一个培训，演示恢复时遇到了这个比较棘手的问题，第一次遇到这样的问题，困扰了几天，原因居然和goldengate里为了支持ddl生成的一个trigger有关，disable这个tirgger问题得以解决。[@more@]oracle对ORA-00376的解释如下：关于该错误的一个解释：Possible causes and solutions summary:===================================== A. Tablespace or Datafile offline. B. Datafile does not exist at the OS level. C. Datafile locked by Backup Software. D. Incorrectly set ULIMIT on UNIX. E. Rollback Segment with acti

给客户做培训时录制的与大家分享[@more@]视频地址：http://www.itpub.net/thread-1625774-1-1.html

如题[@more@]http://www.itpub.net/thread-1623011-1-1.html

rman备份db时出现了：waiting for snapshot control file enqueue提示，很少看到这个提示，记录一下。[@more@]RMAN> run{2> backup database;3> delete noprompt obsolete;4> backup archivelog all;5> }Starting backup at 2011-09-30 15:31:00using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=G:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBFinput datafile fno=00003 name=G:ORACLEPRODUCT10.2.0OR

执行analyze table tt1 validate structure;分析表上的block corrupt时出现了错误ORA-01498困扰了一段时间了，今天仔细分析了一下作了一点总结.[@more@]RMAN> BACKUP DATAFILE 4;Starting backup at 2011-07-24 21:36:08using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00004 name=G:ORADATATESTUSERS01.DBFchannel ORA_DISK_1: starting piece 1 at 2011-07-24 21:36:08channel ORA_DISK_1: finished piece 1 at 2011-07-2

没有EXP_FULL_DATABASE角色，会出现下面错误：ORA-31631: privileges are requiredORA-39149: cannot link privileged user to non-privileged user[@more@]SQL> create database link pdbl connect to rman identified by rman using 'catalog';数据库链接已创建。--=============================================C:>expdp test2/test2@abc directory=mydir dumpfile=rman.dmp network_link=pdbl tables=tExport: Release 10.2.0.1.0 - Production on Monday, 27 June, 2011 14:17:37Copyright (c) 2003, 2005, Oracle. All right

COMPRESSDefault: ySpecifies how Export and Import manage the initial extent for table data.The default, COMPRESS=y, causes Export to flag table data for consolidation into one initial extent upon import. If extent sizes are large (for example, because of the PCTINCREASE parameter), the allocated space will be larger than the space required to hold the data.If you specify COMPRESS=n, Export uses the current storage parameters, including the values of initial extent size and next extent size. The

os：redhat as 4oracle：oracle10gR2客户提出了这样一个要求，演示一下rac db到单实例的恢复，他们的目的是检验生产环境的备份有效性[@more@]下面是思路和主要步骤：1、先在rac db下生成一个init参数文件2、修改参数，cluster_database为false以及屏蔽local_listener等和集群相关的参数3、通过rman备份rac db（为了简单我使用了catalog）4、拷贝参数文件和rac db备份到单实例机器上5、在单实例机器上创建bdump以及数据文件等所在的目录6、修改参数文件中control_files的路径和名字7、在单实例机器上尝试启动实例到nomount状态8、通过rman恢

通过alert仔细观查，发现实例恢复的顺序是：1、前滚2、open db3、rollback（注意：SMON: Parallel transaction recovery tried在Completed: ALTER DATABASE OPEN）之后SMON: enabling cache recoveryMon Jun 13 16:50:50 2011Successfully onlined Undo Tablespace 1.Mon Jun 13 16:50:50 2011SMON: enabling tx recoveryMon Jun 13 16:50:50 2011Database Characterset is ZHS16GBKreplication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=30, OS i

随手记录。。。[@more@]21:29:17 SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。21:29:47 SQL> startup mountORACLE 例程已经启动。Total System Global Area 314572800 bytesFixed Size 1248768 bytesVariable Size 109052416 bytesDatabase Buffers 197132288 bytesRedo Buffers 7139328 bytes数据库装载完毕。21:29:53 SQL> alter database noarchivelog ;alter database noarchivelog*第 1 行出现错误:ORA-38774: 无法禁用介质恢复