名曰华平-CSDN博客

原创 Redo logfile recover

ORACLE_FileManage_Redo logfile recover1). No-current and active status about the redo was destroyedThe issue:The redo log was dropped, now mounted, but can’topen and show warning: ORA-00

2013-09-18 10:56:32 885

原创 Just a sample case about rebuilding the redo group

ORACLE_FileManage_Rebuild the redo groupJust a sample Case:SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME----------

2013-09-18 10:53:58 716

原创 Rebuild the controlfile

ORACLE_FileManage_Rebuild the controlfile1. Backup the controlfile in the MOUNT or OPEN:#dd if=/dev/vx/dsk/dgtest/rlv_controlfile of=/dev/vx/dsk/dgtest/rlv_bakcontrolfile#su - oracle$sqlplus

2013-09-18 10:52:25 729

转载 Recovering the Standby's Datafile

ORACLE_DATAGUARD_Recovering the Standby's DatafileRecovering the Standby's DatafileIf recovering the standby, reverse the steps. Tha tis:1) copy the primary database's datafile 2) ftp the file

2013-09-18 10:49:56 609

原创 Recovering the Primary's Datafile

ORACLE_DATAGUARD_Recovering the Primary's DatafileOn the standby database:1、Backup the standby’s datafile$ rman target /RMAN> backupas copy datafile 5 format '/dg10g/backup/df05.cpy';2、Copy

2013-09-18 10:48:05 607

转载 UNNAMEDnnnnnfile in standby site

ORACLE_DATAGUARD_UNNAMEDnnnnnfile in standby siteUNNAMEDnnnnn file in standby siteafter new file added to primary database [ID 1329399.1]Applies to: OracleServer - Enterprise Edition - Version:

2013-09-18 10:45:28 909

原创 Recover standby database manually

ORACLE_DATAGUARD_Recover standby database manuallyCheck the standby status:SQL>select open_mode from v$database;SQL>select sequence#,applied from v$archived_log order by sequence#;SQL>SELECT T

2013-09-18 10:43:25 1011

转载 Step byStep Guide on Creating Physical Standby Using RMAN DUPLICATE

ORACLE_DATAGUARD_Step byStep Guide on Creating Physical Standby Using RMAN DUPLICATE(Just rebuild the standby database.)--- Filename: Rebuild the standby database using rman duplicateRebui

2013-09-18 10:42:09 783

原创 Just a sample case about rebuilding standby database using dd command

ORACLE_DATAGUARD_Rebuild standby database using dd commandRebuildstandby database using ddcommand:-- Create the standby database:-- 1. rcp the orapw to the standby$ rcp $ORACLE_HOME/db

2013-09-18 10:38:51 735

原创 Just a simple case about the oracle 11gR1 dataguard configuration

01、 ORACLE_DATAGUARD_Case_11gconfigurationJust acase:First of all, please finish the full backup of the primary database.-- 1. Filename: Config the oracle11g primary database1). On

2013-09-18 10:34:02 970

转载 Data Guard Protection Modes

ORACLE_DATAGUARD_Data Guard Protection ModesTRANSPORT: Data Guard Protection ModesMAXIMUM PROTECTION Thisprotection mode guarantees that no data loss will occur if theprimary database fails. To

2013-09-18 10:30:49 705

原创 How to clear the archive log

Some time, the archive is full, we have to clear the archive log and then make the database normal.The following way, maybe is useful to you.1. For NO-DATAGUARD:--- 1. Check the archiv

2013-09-18 10:29:35 1272

转载 Try to finish hcheck after restore database

ORACLE_RMAN_Try to finish hcheck after restore databaseIf restore the database, need to check the databasedictionary by hcheck. Generally speaking, don’t to do this, it will takea lot of resources

2013-09-18 10:26:50 607

原创 Delete archivelog in the primary database

ORACLE_RMAN_delete archivelog in the primary databaseAbout RMAN-08137, please refer to :1. Case 1Check that the standby database is uptodate - if not, restartmanaged recovery and resolve the ga

2013-09-18 10:25:33 1811

原创 The backup progress monitor

ORACLE_RMAN_The backup progress monitor--- 1. RMAN $ sqlplus/ as sysdbaSELECT sid,spid, client_info FROM v$processp, v$session s WHERE p.addr =s.paddr AND client_infoLIKE '%rman%'/

2013-09-18 10:21:16 750

原创 Print the rman output

ORACLE_RMAN_Print the rman output$ rman target /RMAN> spool log to ‘/tmp/rman_output.out’;

2013-09-18 10:19:40 636

原创 Enable block change tracking

RACLE_RMAN_Enable block change tracking--- Enable block change trace (Don’t reboot thedatabase.)alter databaseenable block change tracking using file'/oracle/changetrace/rman_change_track.f';---

2013-09-18 10:18:02 767

原创 Backup incremental level and scripts

1. Full backuprun {allocate channel 'dev1' type disk ;allocate channel 'dev2' type disk ;allocate channel 'dev3' type disk ;backup full tag 'dbfull' format '/o9i/testrman/full%u_%p_%c' da

2013-09-18 10:00:35 1222

原创 Recover database until time format

ORACLE_RMAN_until time formatProble Desc:RMAN> recover database until time '02/28/2011 16:06:23';Starting recover at 28-FEB-11using channel ORA_DISK_1RMAN-00571: ============================

2013-09-18 09:51:20 6481

原创 Check the recover datafile header

ORACLE_RMAN_Check the recover datafile headerset pagesize 20000set linesize 180set pause offset serveroutput onset feedback onset echo onset numformat 999999999999999Spool recovery

2013-09-18 09:49:25 894

原创 Delete archive log

ORACLE_RMAN_Delete archive log1. Remove thearchive log directly1). Remove thearchive log;2). Delete therecord of the database# su - oracle$ rman target /RMAN> listarchivelog all;RMAN>cro

2013-09-17 06:45:47 909

原创 Change archive mode

Change archive mode1. The HAorSINGLEmode,Changetothearchivemode (Please freeze the cluster)$ sqlplus '/ as sysdba'SQL> show parameter spfile;NAME TYPE

2013-09-17 06:43:50 660

原创 The oracle reference scripts of the backup and the recover

ORACLE_BACKUP_The oracle reference scripts of the backup and the recoverThere are two familiar ways for thedatabase backup: exp/imp and rman. Expdp/impdp only Applies to above the oracle10g. Now the

2013-09-17 06:40:17 1467

转载 11g Member Kill Escalation

ORACLE_CLUSTER_11g Member Kill Escalationhttps://blogs.oracle.com/Database4CN/entry/11g_%E6%96%B0%E7%89%B9%E6%80%A7_member_kill_escalation首先我们介绍一下历史。在oracle 9i/10g 中，如果一个数据库实例需要驱逐(evict, alert文件

2013-09-17 06:38:19 893

转载 Script to Collect RAC Diagnostic Information

ORACLE_CLUSTER_Script to Collect RAC Diagnostic InformationThis script is intended to provide a user friendlyguide to troubleshoot RAC hung sessions or slow performance scenerios. Thescript includes

2013-09-17 06:36:12 826

转载 The Diagwait Function

ORACLE_CLUSTER_DiagwaitUsing Diagwait as a diagnostic toget more information for diagnosing Oracle Clusterware Node evictions [ID559365.1]Applies to: OracleServer - Standard Edition - Version: 1

2013-09-17 06:33:51 753

转载 How to uninstall CRS

How to uninstall CRSHow to Clean Up After a Failed 10g or 11.1 OracleClusterware Installation10g and 11.1 RAC: Howto Clean Up After a Failed CRS Install------------------------------------------

2013-09-17 06:32:04 817

转载 OCR/ Vote disk Maintenance Operations

OCR/ Vote disk Maintenance OperationsOCR/ Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) [ID 428681.1]1. ADD/REMOVE/REPLACE/MOVE OCR Device1). OCR backupMake sure there isa rece

2013-09-17 06:30:23 800

转载 Get the RACCheck for the diagnosing

ORACLE_CLUSTER_RACCheckRACcheck -RAC Configuration Audit Tool [ID 1268927.1]1. The collect steps:# su - oracle$ cd /opt/raccheck$ gunzip raccheck_m.tar.gz $ tar -xvf r

2013-09-17 06:28:50 767

原创 Rebuild the application tablespace

ORACLE_Guide_Rebuild the applicationtablespace1. Please exp the tablespace, like this:$ exp"'sys/sys as sysdba'" file=/opt/oracle/oradata/tablespace_test.dmp log=/opt/oracle/oradata/tablespace_tes

2013-09-17 06:25:15 623

原创 Start the ASM manually

ORACLE_Guide_Start the ASM manuallyJust a case:p630up[root]#su - oraclep630up[oracle]$export ORACLE_SID=+ASM2p630up[oracle]$sqlplus / as sysdbaConnected to an idle instance.SQL> s

2013-09-17 06:20:51 731

原创 Clear the database log

ORACLE_Guide_Clear the database log1. Clean the ASM logoracle11g:oracle@host1:~> cd $ORACLE_BASE/diag/asm/+asm//alertoracle@host1:~> find ./ -name "log_*.xml"|xargs rm -rforacle@hos

2013-09-17 06:18:14 1635

转载 ASM issue diagnosing

Oracle_Collect_ASM issue diagnosing(Fromthe oracle official support)Please provide the following information to troubleshoot the issue (fromeach node, if this is RAC):1. Upload ASM alert.logs and

2013-09-17 06:17:06 721

原创 Collect On-site info for the diagnosing

ORACLE_Collect_Collect On-site info for thediagnosing1. The database1).Describe the issue2).Collect the database alert_.logoracle9i, 10g:# su - oracle$ORACLE_BASE/admin//bdump/

2013-09-17 06:14:46 931

转载 ORACLE_BASIC_11gR2资源类型及相关日志

ORACLE_BASIC_11gR2资源类型及相关日志ora.net1.network : 网络资源ora..vip：scan对应的vip资源ora..vip: 节点对应的vip 资源ora..lsnr:监听程序资源。ora.LISTENER_SCAN.lsnr:scan 监听程序。ora..dg: ASM 磁盘组资源。ora..db: 数据库资源。ora..svc

2013-09-17 06:11:02 911

转载 11gR2 GI 启动顺序

01、 ORACLE_BASIC_11gR2 GI 启动顺序1). ohasd 启动阶段1.通过/etc/inittab文件中的脚本h1:35:respawn:/etc/init.d/init.ohasdrun >/dev/null 2>&1 被调用，产生下面的进程root 4865 1 0 Dec02 ?00:01:01 /bin/sh /etc/init.d/init.oh

2013-09-17 06:09:41 1519

原创 Some useful info for rebuilding database

01、 ORACLE_Collect_Some useful info for rebuilding database--- 1.Backup the pfile;#su - oracle$sqlplus / assysdbaSQL>show parameterspfile;SQL>CREATEPFILE='$ORACLE_HOME/dbs/inittmp.ora'FROM

2013-09-17 06:08:37 596

转载 How To Determine Granule Size

01、 ORACLE_BASIC_How To Determine Granule SizeHow To DetermineGranule Size (Doc ID 947152.1)1. How is the granulesize determinedThe granule size isdetermined based on the amount of memory reques

2013-09-17 06:06:38 816

空空如也

空空如也