<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Enhancing Your Oracle Capability]]></title><description><![CDATA[The study is a simple thing, just focus on your want.]]></description><link>https://blog.youkuaiyun.com/u012152339</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; u012152339]]></copyright><item><title><![CDATA[Redo logfile recover]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11800011</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11800011</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:56:32 +0800</pubDate><description><![CDATA[ORACLE_FileManage_Redo logfile recover
1). No-current and active status about the redo was destroyed
The issue:
The redo log was dropped, now mounted, but can’topen and show warning:
       ORA-00]]></description><category></category></item><item><title><![CDATA[Just a sample case about rebuilding the redo group]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799893</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799893</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:53:58 +0800</pubDate><description><![CDATA[ORACLE_FileManage_Rebuild the redo group
Just a sample Case:
SQL>  select * from v$log;
    GROUP#   THREAD#  SEQUENCE#      BYTES   MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME
----------]]></description><category></category></item><item><title><![CDATA[Rebuild the controlfile]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799783</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799783</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:52:25 +0800</pubDate><description><![CDATA[ORACLE_FileManage_Rebuild the controlfile
1.  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 ]]></description><category></category></item><item><title><![CDATA[Recovering the Standby's Datafile]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799661</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799661</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:49:56 +0800</pubDate><description><![CDATA[ORACLE_DATAGUARD_Recovering the Standby's Datafile
Recovering the Standby's Datafile
If recovering the standby, reverse the steps. Tha tis:
1) copy the primary database's datafile 
2) ftp the file]]></description><category></category></item><item><title><![CDATA[Recovering the Primary's Datafile]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799583</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799583</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:48:05 +0800</pubDate><description><![CDATA[ORACLE_DATAGUARD_Recovering the Primary's Datafile
On the standby database:
1、Backup the standby’s datafile
$ rman target /
RMAN> backupas copy datafile 5 format '/dg10g/backup/df05.cpy';
2、Copy ]]></description><category></category></item><item><title><![CDATA[UNNAMEDnnnnnfile in standby site]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799503</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799503</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:45:28 +0800</pubDate><description><![CDATA[ORACLE_DATAGUARD_UNNAMEDnnnnnfile in standby site
UNNAMEDnnnnn file in standby siteafter new file added to primary database [ID 1329399.1]
Applies to: 
OracleServer - Enterprise Edition - Version: ]]></description><category></category></item><item><title><![CDATA[Recover standby database manually]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799449</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799449</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:43:25 +0800</pubDate><description><![CDATA[ORACLE_DATAGUARD_Recover standby database manually
Check the standby status:
SQL>select open_mode from v$database;
SQL>select sequence#,applied from v$archived_log order by sequence#;
SQL>SELECT T]]></description><category></category></item><item><title><![CDATA[Step byStep Guide on Creating Physical Standby Using RMAN DUPLICATE]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799315</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799315</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:42:09 +0800</pubDate><description><![CDATA[ORACLE_DATAGUARD_Step byStep Guide on Creating Physical Standby Using RMAN DUPLICATE(Just rebuild the standby database.)
--- Filename: Rebuild the standby database using rman duplicate




Rebui]]></description><category></category></item><item><title><![CDATA[Just a sample case about rebuilding standby database using dd command]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11799101</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11799101</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:38:51 +0800</pubDate><description><![CDATA[ORACLE_DATAGUARD_Rebuild standby database using dd command
Rebuildstandby database using ddcommand:




-- Create the standby database:
-- 1. rcp the orapw to the standby
$ rcp $ORACLE_HOME/db]]></description><category></category></item><item><title><![CDATA[Just a simple case about the oracle 11gR1 dataguard configuration]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798989</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798989</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:34:02 +0800</pubDate><description><![CDATA[01、 ORACLE_DATAGUARD_Case_11gconfiguration
Just acase:




First of all, please finish the  full backup of the primary database.
-- 1. Filename: Config the  oracle11g primary database

1). On]]></description><category></category></item><item><title><![CDATA[Data Guard Protection Modes]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798875</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798875</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:30:49 +0800</pubDate><description><![CDATA[ORACLE_DATAGUARD_Data Guard Protection Modes
TRANSPORT: Data Guard Protection Modes
MAXIMUM PROTECTION 
Thisprotection mode guarantees that no data loss will occur if theprimary database fails. To ]]></description><category></category></item><item><title><![CDATA[How to clear the archive log]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798749</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798749</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:29:35 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[Try to finish hcheck after restore database]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798713</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798713</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:26:50 +0800</pubDate><description><![CDATA[ORACLE_RMAN_Try to finish hcheck after restore database
If restore the database, need to check the databasedictionary by hcheck. 
Generally speaking, don’t to do this, it will takea lot of resources]]></description><category></category></item><item><title><![CDATA[Delete archivelog in the primary database]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798583</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798583</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:25:33 +0800</pubDate><description><![CDATA[ORACLE_RMAN_delete archivelog in the primary database
About RMAN-08137, please refer to :
1.  Case 1
Check that the standby database is uptodate - if not, restartmanaged recovery and resolve the ga]]></description><category></category></item><item><title><![CDATA[The backup progress monitor]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798489</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798489</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:21:16 +0800</pubDate><description><![CDATA[ORACLE_RMAN_The backup progress monitor
--- 1. RMAN 
$  sqlplus/ as sysdba
SELECT sid,spid, client_info  
FROM v$processp, v$session s  
WHERE p.addr =s.paddr  
AND client_infoLIKE '%rman%'
/
]]></description><category></category></item><item><title><![CDATA[Print the rman output]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798451</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798451</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:19:40 +0800</pubDate><description><![CDATA[ORACLE_RMAN_Print the rman output
$ rman target /
RMAN> spool log to ‘/tmp/rman_output.out’;]]></description><category></category></item><item><title><![CDATA[Enable block change tracking]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11798367</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11798367</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:18:02 +0800</pubDate><description><![CDATA[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';
---]]></description><category></category></item><item><title><![CDATA[Backup incremental level and scripts]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11797473</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11797473</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 10:00:35 +0800</pubDate><description><![CDATA[1. Full backup
run {
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]]></description><category></category></item><item><title><![CDATA[Recover database until time format]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11797255</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11797255</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 09:51:20 +0800</pubDate><description><![CDATA[ORACLE_RMAN_until time format
Proble Desc:
RMAN> recover database until time '02/28/2011 16:06:23';
Starting recover at 28-FEB-11
using channel ORA_DISK_1
RMAN-00571: ============================]]></description><category></category></item><item><title><![CDATA[Check the recover datafile header]]></title><link>https://blog.youkuaiyun.com/u012152339/article/details/11756409</link><guid>https://blog.youkuaiyun.com/u012152339/article/details/11756409</guid><author>u012152339</author><pubDate>Wed, 18 Sep 2013 09:49:25 +0800</pubDate><description><![CDATA[ORACLE_RMAN_Check the recover datafile header
set pagesize 20000
set linesize 180
set pause off
set serveroutput 
on
set feedback on
set echo on
set numformat 
999999999999999
Spool recovery]]></description><category></category></item></channel></rss>