没有备份只有归档日志如何恢复数据…
没有备份只有归档日志如何恢复数据…
发布时间： 9:02:12
编辑：www.fx114.net
本篇文章主要介绍了"没有备份只有归档日志如何恢复数据…"，主要涉及到没有备份只有归档日志如何恢复数据…方面的内容，对于没有备份只有归档日志如何恢复数据…感兴趣的同学可以参考一下。
Last login: Thu Sep 20 11:22:48 2012 from 10.80.11.111
[ ~]# su - oracle
/home/oracle
[ ~]$ stty erase '^H'
[ ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 20 11:23:20
Copyright (c) , Oracle.& All rights
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
Production
With the Partitioning, OLAP, Data Mining and Real Application
Testing options
SQL& select * from v$
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
Production
PL/SQL Release 11.2.0.1.0 - Production
11.2.0.1.0&&&&&
Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL& create tablespace test datafile
& 2& '/u01/test.ora' size
& 3& AUTOEXTEND ON NEXT 1M
MAXSIZE UNLIMITED
& 4& default storage (initial
128K next 1M pctincrease 0)
Tablespace created.
drop user test cascade
ERROR at line 1:
ORA-01918: user 'TEST' does not exist
SQL& create user test identified by test default tablespace
grant connect,
User created.
SQL& grant connect,
grant connect,grant connect,resource to test
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
ERROR at line 1:
ORA-00911: invalid character
SQL& grant connect,
Grant succeeded.
SQL& conn test/test
Connected.
SQL& create table a(a number);
Table created.
SQL& insert into a values(1);
1 row created.
SQL& insert into a select *
1 row created.
2 rows created.
4 rows created.
8 rows created.
16 rows created.
32 rows created.
64 rows created.
128 rows created.
256 rows created.
512 rows created.
1024 rows created.
2048 rows created.
4096 rows created.
8192 rows created.
16384 rows created.
32768 rows created.
65536 rows created.
131072 rows created.
262144 rows created.
524288 rows created.
1048576 rows created.
2097152 rows created.
SQL& select
4194304 rows created.
insert into a select * from a
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
SQL& SP2-0042: unknown command "" - rest of line ignored.
SQL& SQL& SQL&
SQL& select count
SQL& select count(*)
& COUNT(*)
----------
&& 8388608
SQL& commit
Commit complete.
SQL&& connect internal
Enter password:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
Warning: You are no longer connected to ORACLE.
SQL& connect sys
Enter password:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
SQL& connect as sysdba
Enter user-name: system
Enter password:
Connected.
SQL& alter s
System altered.
System altered.
SQL& archive log list
Database log
mode&&&&&&&&&&&&&
Archive Mode
archival&&&&&&&&&&&&
destination&&&&&&&&&&&
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log
sequence&&&&
Next log sequence to archive&&
Current log
sequence&&&&&&&&&&
System altered.
SQL& alter s
System altered.
SQL& shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL& startup
ORACLE instance started.
Total System Global Area&
Size&&&&&&&&&&&&&&&&&
1335528 bytes
Size&&&&&&&&&&&&
Buffers&&&&&&&&&&
Buffers&&&&&&&&&&&&&&&
2375680 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace
ORA-01110: data file 6: '/u01/test.ora'
SQL& startup mount
ORA-01081: cannot start already-running ORACLE - shut it down
SQL&& alter database create datafile
'/u01/test.ora';
Database altered.
SQL& set autorecovery on
SQL& recovery datafile '/u01/test.ora';
SP2-0734: unknown command beginning "recovery d..." - rest of line
SQL& recover datafile& '/u01/test.ora';
ORA-00279: change 1511838 generated at 09/20/:11 needed
for thread 1
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_62_.dbf
ORA-00280: change 1511838 for thread 1 is in sequence #62
ORA-00279: change 1512465 generated at 09/20/:24 needed
for thread 1
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_63_.dbf
ORA-00280: change 1512465 for thread 1 is in sequence #63
ORA-00279: change 1513085 generated at 09/20/:41 needed
for thread 1
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_64_.dbf
ORA-00280: change 1513085 for thread 1 is in sequence #64
ORA-00279: change 1513242 generated at 09/20/:02 needed
for thread 1
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_65_.dbf
ORA-00280: change 1513242 for thread 1 is in sequence #65
ORA-00279: change 1513427 generated at 09/20/:18 needed
for thread 1
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_66_.dbf
ORA-00280: change 1513427 for thread 1 is in sequence #66
ORA-00279: change 1513542 generated at 09/20/:04 needed
for thread 1
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_67_.dbf
ORA-00280: change 1513542 for thread 1 is in sequence #67
Log applied.
Media recovery complete.
SQL& conn test/test
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
SQL& startup
ORA-01031: insufficient privileges
SQL& connect as sysdba
Enter user-name: system
Enter password:
Connected.
Database altered.
SQL& conn test/test
Connected.
SQL&&&&&&&&&&&&
SQL& select conut(*)
select conut(*) from test
&&&&&&&&&&&&
ERROR at line 1:
ORA-00936: missing expression
SQL& select count(*)
select count(*) from test
&&&&&&&&&&&&&&&&&&&&
ERROR at line 1:
ORA-00942: table or view does not exist
SQL& c/test/a
& 1* select count(*) from a
& 1* select count(*) from a
& COUNT(*)
----------
&& 8388608
SQL&&& 1* select count(*) from
& COUNT(*)
----------
&& 8388608
SQL& SQL& SQL& SQL& conn
test/test&
一、不得利用本站危害国家安全、泄露国家秘密，不得侵犯国家社会集体的和公民的合法权益，不得利用本站制作、复制和传播不法有害信息！
二、互相尊重，对自己的言论和行为负责。
本文标题：
本页链接：RMAN 配置归档日志删除策略_数据库技术_Linux公社-Linux系统门户网站
你好，游客
RMAN 配置归档日志删除策略
来源：Linux社区&
作者：Leshami
11g中对于归档日志的删除，除了遵循RMAN保留策略外，也可以通过RMAN来配置归档日志的删除策略，也就是归档日志何时可以被删除。归档日志删除策略适用于所有归档位置(使用快速闪回区FRA/不使用FRA &)。本文主要描述归档日志删除策略并给出了具体的演示。
1、关于归档日志删除策略& & & 也就是哪些归档日志符合删除策略能够被删除，如前所述，归档位置适用于所有归档位置(使用快速闪回区FRA/不使用FRA)& & & 当启用该策略后，如归档日志存在于FRA中，则Oracle会尽可能根据保留他们，一旦FRA空间告急，则Oracle会根据归档日志删除策略自动删除& & & 对于不在FRA中的归档日志，需要手动使用delete obsolete或delete archivelog方式来删除日志& & & 无论归档日志存在于FRA内或外，都可以通过BACKUP ... DELETE INPUT or DELETE ARCHIVELOG方式来删除& & & 该策略不适用于使用LogMiner方式从主数据库传送到逻辑standby生成的外部归档日志文件，因为这些日志文件不能够在逻辑standy上备份或恢复&
2、配置归档日志删除策略& & 使用下面的方式来配置归档日志删除策略& & & & configure archivelog deletion policy to backed up 2& & & & configure archivelog deletion policy to backed up 1 times& & & & configure archivelog deletion policy t& & & & configure archivelog deletion policy t& & & & configure archivelog d& & 对于Oracle 10g没有该特性，但有一个类似的用于配置归档日志被备份次数，如下；& & & & configure archivelog backup copies for device type disk to ${archiveretention};& & 3、禁用归档日志删除策略& & & 缺省情况下，该策略被设置为none。也就是说根据RMAN备份保留策略，对于FRA中的归档日志，被备份过一次(到磁盘或磁带)即符合条件被删除& & 如果Oracle不再需要当前的归档日志用于保证数据库时点恢复或数据库闪回，则RMAN备份保留策略认为当前日志为obsolete& & 在SYSDATE-'DB_FLASHBACK_RETENTION_TARGET'之后创建的归档日志是需要被保留的
4、启用归档日志删除策略& & 一旦启用该策略，则指定的归档日志被备份数量达到设定值后，这些归档日志能够被删除& & BACKUP ARCHIVELOG 会在未超出指定备份数的情况下(比如设置为2)备份归档日志到指定位置，如超出2次，则RMAN会跳过这些备份过2次的归档日志& & 对于上述的情形，可以为BACKUP ARCHIVELOG适用force选项来强制备份归档日志& & 如果启用该策略且配置为APPLIED ON STANDBY子句，则所有强制standby位置被apply后，这些归档日志会被RMAN删除 & & 如果启用该策略且配置为SHIPPED ON STANDBY子句，则所有强制standby位置被成功传送后，这些归档日志会被RMAN删除
更多详情见请继续阅读下一页的精彩内容：
推荐阅读：
Oracle基础教程之通过RMAN复制数据库
RMAN备份策略制定参考内容
RMAN备份学习笔记
Oracle数据库备份加密 RMAN加密
相关资讯 & & &
& (09/24/:08)
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
阅读(32821)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
loftPermalink:'',
id:'fks_084067',
blogTitle:'ORACLE正确删除归档日志的方法',
blogAbstract:'我们都都知道在controlfile中记录着每一个archivelog',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:0,
publishTime:0,
permalink:'blog/static/',
commentCount:1,
mainCommentCount:1,
recommendCount:1,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}博客访问： 1770945
博文数量： 487
注册时间：
ITPUB论坛APP
ITPUB论坛APP
APP发帖 享双倍积分
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
分类： Linux
开始备份：RMAN> RUN {2> ALLOCATE CHANNEL CH1 DEVICE TYPE DISK;3> ALLOCATE CHANNEL CH2 DEVICE TYPE DISK;4> BACKUP DATABASE5>& SKIP INACCESSIBLE6>& FILESPERSET 107> INCLUDE CURRENT CONTROLFILE8>&&& PLUS ARCHIVELOG FILESPERSET 209>&&& DELETE ALL INPUT;10> RELEASE CHANNEL CH1;11> RELEASE CHANNEL CH2;12> CROSSCHECK BACKUPSET;13> DELETE NOPROMPT OBSOLETE;14> }released channel: ORA_DISK_1allocated channel: CH1channel CH1: SID=1154 instance=mdstest1 device type=DISKallocated channel: CH2channel CH2: SID=585 instance=mdstest1 device type=DISKStarting backup at
16:40:50current log archivedreleased channel: CH1released channel: CH2RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup plus archivelog command at 10/11/:01RMAN-06059: expected archived log not found, loss of archived log compromises recoverabilityORA-19625: error identifying file +FRA/mdstest/archivelog//thread_1_seq_6.271.ORA-17503: ksfdopn:2 Failed to open file +FRA/mdstest/archivelog//thread_1_seq_6.271.ORA-15012: ASM file '+FRA/mdstest/archivelog//thread_1_seq_6.271.' does not exist原因是前期手动的删除了asm里的归档日志。处理方案：RMAN> crossallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=1154 instance=mdstest1 device type=DISKvalidation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_6.271. RECID=40 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_7.268. RECID=41 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_8.265. RECID=42 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_9.273. RECID=46 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_10.287. RECID=49 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_11.289. RECID=51 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_12.290. RECID=52 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_13.292. RECID=54 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_14.293. RECID=55 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_15.294. RECID=57 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_16.296. RECID=58 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_17.300. RECID=62 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_18.302. RECID=64 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_19.304. RECID=66 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_20.306. RECID=68 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_21.309. RECID=71 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_22.311. RECID=73 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_23.314. RECID=76 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_24.316. RECID=78 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_25.317. RECID=79 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_26.319. RECID=81 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_27.320. RECID=82 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_28.323. RECID=85 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_29.325. RECID=87 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_30.328. RECID=90 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_31.329. RECID=91 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_1_seq_32.275. RECID=92 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_4.282. RECID=43 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_5.274. RECID=44 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_6.284. RECID=45 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_7.285. RECID=47 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_8.286. RECID=48 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_9.288. RECID=50 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_10.291. RECID=53 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_11.295. RECID=56 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_12.297. RECID=59 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_13.298. RECID=60 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_14.299. RECID=61 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_15.301. RECID=63 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_16.303. RECID=65 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_17.305. RECID=67 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_18.307. RECID=69 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_19.308. RECID=70 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_20.310. RECID=72 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_21.312. RECID=74 STAMP=validation failed for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_22.313. RECID=75 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_23.315. RECID=77 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_24.318. RECID=80 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_25.321. RECID=83 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_26.322. RECID=84 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_27.324. RECID=86 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_28.326. RECID=88 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_29.327. RECID=89 STAMP=validation succeeded for archived logarchived log file name=+FRA/mdstest/archivelog//thread_2_seq_30.267. RECID=93 STAMP=Crosschecked 54 objectsRMAN> RUN {2> ALLOCATE CHANNEL CH1 DEVICE TYPE DISK;3> ALLOCATE CHANNEL CH2 DEVICE TYPE DISK;4> BACKUP DATABASE5>& SKIP INACCESSIBLE6>& FILESPERSET 107> INCLUDE CURRENT CONTROLFILE8>&&& PLUS ARCHIVELOG FILESPERSET 209>&&& DELETE ALL INPUT;10> RELEASE CHANNEL CH1;11> RELEASE CHANNEL CH2;12> CROSSCHECK BACKUPSET;13> DELETE NOPROMPT OBSOLETE;14> }released channel: ORA_DISK_1allocated channel: CH1channel CH1: SID=1154 instance=mdstest1 device type=DISKallocated channel: CH2channel CH2: SID=585 instance=mdstest1 device type=DISKStarting backup at
16:45:48current log archivedchannel CH1: starting archived log backup setchannel CH1: specifying archived log(s) in backup set最后备份成功。
阅读(2499) | 评论(0) | 转发(0) |
相关热门文章
给主人留下些什么吧！~~
请登录后评论。