您的位置:网站首页 > 行业资讯 > 行业动态 > 正文

ca88亚洲城备用网址ca88亚洲城备用网址【授权【官网】

  2016-01-22 11:09  中国润滑油信息网
ca88亚洲城备用网址ca88亚洲城备用网址【授权【官网】

file name: +data/phub/datafile/example.287.

大略备份脚本:

channel ora_disk_1: piece handle=/home/oracle/backup/data_50qiv187_1_1.bak tag=db0

623available/home/oracle/backup/data_50qiv187_3_1.bak

channel ora_disk_1: starting full datafile backup set

channel ora_disk_2: backup set complete, elapsed time: 00:00:01

channel ora_disk_2: backup set complete, elapsed time: 00:00:01

---------- -------------- ----------------

channel ora_disk_2: reading from backup piece /home/oracle/backup/data_51qiv187_1_1.bak

file status marked corrupt empty blocks blocks examined high scn

rman: incremental datafile backup62.28%blocks

10incr -oct-15 +data/phub/datafile/system.271.

a 06-oct-15

a 06-oct-15

input datafile file number=00001 name=+data/phub/datafile/system.271.

using channel ora_disk_2

channel ora_disk_2: piece handle=/home/oracle/backup/data_51qiv187_4_1.bak tag=db0

opname

=====================================================================

}

else

---- ------ -------------- ------------ --------------- ----------

block type blocks failing blocks processed

finished restore at 07-oct-15

channel ora_disk_1: backup set complete, elapsed time: 00:00:59

4ok

input datafile file number=00007 name=+data/phub/datafile/idx01.dbf

file status marked corrupt empty blocks blocks examined high scn

device type elapsed time completion time compressed tag

input datafile file number=00006 name=+data/phub/datafile/llc01.dbf

674available/home/oracle/backup/data_51qiv187_4_1.bak

---------- -------------- ----------------

list of control file and spfile

keythrd seqs low time

channel ora_disk_2: reading from backup piece /home/oracle/backup/data_51qiv187_4_1.bak

bp keypc# statuspiece name

bs keytype lv sizedevice type elapsed time completion time

---- ------ -------------- ------------ --------------- ----------

---------- ---------- ---------- ---------- ---------- ----------

channel ora_disk_1: restored backup piece 3

0

------------------------------------------------------------ ----------------------------------------- --------------------------------

channel ora_disk_1: starting validation of datafile backup set

file lv type ckp scnckp timename

channel ora_disk_1: specifying datafile(s) in backup set

50incr -oct-15 +data/phub/datafile/example.287.

------- --- ----------- ----------

channel ora_disk_1: reading from backup piece /home/oracle/backup/data_50qiv187_1_1.bak

block type blocks failing blocks processed

file status marked corrupt empty blocks blocks examined high scn

index

name: +data/phub/archivelog/2015_10_07/thread_1_seq_283.300.

60incr -oct-15 +data/phub/datafile/llc01.dbf

other04541

index0730

---- ------ -------------- ------------ --------------- ----------

total0%blocks

channel ora_disk_2: specifying datafile(s) in backup set

using channel ora_disk_1

30incr -oct-15 +data/phub/datafile/undotbs1.260.

40incr -oct-15 +data/phub/datafile/users.269.

media recovery start scn is

channel ora_disk_2: reading from backup piece /home/oracle/backup/data_51qiv187_3_1.bak

select case

channel ora_disk_1: specifying datafile(s) in backup set

name: +data/phub/archivelog/2015_10_06/thread_1_seq_279.368.

---- ------ -------------- ------------ --------------- ----------

recovery must be done beyond scn to clear datafile fuzziness

channel ora_disk_1: validation complete, elapsed time: 00:01:03

block type blocks failing blocks processed

starting restore at 07-oct-15

a 06-oct-15

.27

using channel ora_disk_1

channel ora_disk_2: backup set complete, elapsed time: 00:00:55

data00

------------ ------ -------------- ---------------

sql 'alter system switch logfile';

index

end opname,

sidserial# contextsofartotalwork % complete

other07406

list of datafiles

康复完结:

file name: +data/phub/datafile/users.269.

------- --- ----------- ----------

round(sofar / totalwork * 100, 2) "% complete"

finished restore at 07-oct-15

where opname like 'rman:%'

other

641available/home/oracle/backup/data_51qiv187_1_1.bak

and totalwork > sofar;

index

name: +data/phub/archivelog/2015_10_06/thread_1_seq_280.365.

list of datafiles

------------ ------ -------------- ---------------

opn668comameprogressunits

a 05-oct-15

when opname like '%aggregate%' then

backup set copy #1 of backup set 55

57incr 0363.33mdisk00:01:2605-oct-15

file status marked corrupt empty blocks blocks examined high scn

channel ora_disk_2: starting full datafile backup set

from v$session_longops

finished backup at 07-oct-15

file name: +data/phub/datafile/llc01.dbf

data

rman> backup check logical validate datafile 1;

index

601available/home/oracle/backup/data_50qiv187_1_1.bak

where opname like 'rman%'

allocate channel c2 device type disk maxpiecesize=51200m;

sidserial# contextsofartotalwork % complete

{

delete noprompt expired archivelog all;

channel ora_disk_2: specifying datafile(s) in backup set

from v$session_longops

----------- ------------ --------------- ---------- ---

other04541

channel ora_disk_2: starting validation of datafile backup set

3.校验数据文件的是不是存在坏块:

allocated channel: ora_disk_2

totalwork,

starting restore at 07-oct-15

using channel ora_disk_1

disk00:01:0605-oct-15yesdb0

a 06-oct-15

612available/home/oracle/backup/data_50qiv187_2_1.bak

and opname not like 'rman: aggregate%';

=================

channel ora_disk_1: reading from backup piece /home/oracle/backup/data_50qiv187_2_1.bak

----------- ------------ --------------- ---------- ---

using channel ora_disk_2

.66

file status marked corrupt empty blocks blocks examined high scn

name: +data/phub/archivelog/2015_10_07/thread_1_seq_282.290.

block type blocks failing blocks processed

file status marked corrupt empty blocks blocks examined high scn

663available/home/oracle/backup/data_51qiv187_3_1.bak

---- ------ -------------- ------------ --------------- ----------

4.校验单个数据文件:

list of datafiles

allocate channel c1 device type disk maxpiecesize=51200m;

allocated channel: ora_disk_1

delete noprompt archivelog until time 'sysdate-15';

list of archived log copies for database with db_unique_name phub

a 07-oct-15

select sid,

disk00:01:2605-oct-15yesdb0

backup incremental level=0 tag='db0' as compressed backupset database include current

other02569

a 06-oct-15

starting backup at 07-oct-15

file name: +data/phub/datafile/undotbs1.260.

using channel ora_disk_2

------- ---- -- ---------- ----------- ------------ ---------------

channel ora_disk_2: specifying datafile(s) in backup set

channel ora_disk_1: reading from backup piece /home/oracle/backup/data_50qiv187_3_1.bak

other

device type elapsed time completion time compressed tag

block type blocks failing blocks processed

5.备份进展查询:

name: +data/phub/archivelog/2015_10_06/thread_1_seq_281.285.

finished backup at 07-oct-15

---- -- ---- ---------- --------- ----

6ok

using channel ora_disk_1

list of datafiles in backup set 57

channel ora_disk_2: validation complete, elapsed time: 00:01:12

other0910

channel ora_disk_2: sid=138 device type=disk

data

controlfile format '/back/level0/df_%u.bak';

1ok

context,

file typestatus blocks failing blocks examined

652available/home/oracle/backup/data_51qiv187_2_1.bak

rman> backup check logical validate database;

ca88亚洲城备用网址ca88亚洲城备用网址【授权【官网】

channel ora_disk_1: piece handle=/home/oracle/backup/data_50qiv187_3_1.bak tag=db0

name: +data/phub/archivelog/2015_10_06/thread_1_seq_278.370.

---- ------ -------------- ------------ --------------- ----------

release channel c2;

list of backup sets

file name: +data/phub/datafile/system.271.

units

===================

data00

---------- -------------- ----------------

crosscheck archivelog all;

serial#,

totalwork,

list of control file and spfile

input datafile file number=00002 name=+data/phub/datafile/sysaux.272.

bp keypc# statuspiece name

channel ora_disk_2: reading from backup piece /home/oracle/backup/data_51qiv187_2_1.bak

list of backup pieces for backup set 57 copy #1

list of datafiles in backup set 55

6.康复进展查询:

sofar,

70incr -oct-15 +data/phub/datafile/idx01.dbf

channel ora_disk_1: restored backup piece 2

name: +data/phub/archivelog/2015_10_06/thread_1_seq_277.372.

channel ora_disk_2: piece handle=/home/oracle/backup/data_51qiv187_3_1.bak tag=db0

---- ------ -------------- ------------ --------------- ----------

file status marked corrupt empty blocks blocks examined high scn

channel ora_disk_1: backup set complete, elapswww,youjizzcomed time: 00:00:07

run

index01149

channel ora_disk_1: piece handle=/home/oracle/backup/data_50qiv187_2_1.bak tag=db0

file name: +data/phub/datafile/idx01.dbf

=================

delete noprompt obsolete;

from v$session_longops

list of backup pieces for backup set 55 copy #1

channel ora_disk_2: restored backup piece 4

data

using target database control file instead of recovery catalog

2ok

data

file name: +data/phub/datafile/sysaux.272.

channel ora_disk_1: restored backup piece 1

5ok8

---- ------ -------------- ------------ --------------- ----------

a 05-oct-15

'total'

---------- -------------- ----------------

trunc(sofar * 100 / totalwork, 2) || '%' progress,

------- ---- ------- - ---------

including current control file in backup set

index

release channel c1;

---------- ---------- ---------- ---------- ---------- ----------

index00

=================

---------- -------------- ----------------

file name: +data/phub/datafile/system.271.

sofar,

rman: incremental datafile backup75.47%blocks

context,

where opname like 'rman:%'

channel ora_disk_2: piece handle=/home/oracle/backup/data_51qiv187_1_1.bak tag=db0

---------- -------------- ----------------

channel ora_disk_2: restored backup piece 1

starting backup at 07-oct-15

channel ora_disk_2: starting full datafile backup set

---------- -------------- ----------------

rman> restore database preview;

1.验证备份是不是能够被成功回覆再起,彻底回覆再起断定需应用哪些备份集和归档日志

serial#,

---- -- ---- ---------- --------- ----

channel ora_disk_2: restored backup piece 3

backup set copy #1 of backup set 57

channel ora_disk_1: starting full datafile backup set

channel ora_disk_2: piece handle=/home/oracle/backup/data_51qiv187_2_1.bak tag=db0

===============================

rman> restore database validate;

channel ora_disk_2: starting full datafile backup set

including current control file in backup set

1ok

control file ok0646

bs keytype lv sizedevice type elapsed time completion time

3ok0208

20incr -oct-15 +data/phub/datafile/sysaux.272.

file typestatus blocks failing blocks examined

block type blocks failing blocks processed

data

round(sofar / totalwork * 100, 2) "% complete"

file status marked corrupt empty blocks blocks examined high scn

delete noprompt expired backup;

file lv type ckp scnckp timename

block type blocks failing blocks processed

channel ora_disk_1: sid=202 device type=disk

9and opname not like 'rman: aggregate%';

name: +data/phub/archivelog/2015_10_05/thread_1_seq_276.374.

input datafile file number=00004 name=+data/phub/datafile/users.269.

input datafile file number=00005 name=+data/phub/datafile/example.287.

select sid,

other0639

crosscheck backup;

channel ora_disk_2: restored backup piece 2

---------- -------------- ----------------

===============================

using channel ora_disk_2

data04394

control file ok0646

7ok

------- ---- -- ---------- ----------- ------------ ---------------

block type blocks failing blocks processed

55incr 0215.65mdisk00:01:0605-oct-15

input datafile file number=00001 name=+data/phub/datafile/system.271.

input datafile file number=00003 name=+data/phub/datafile/undotbs1.260.

2.查看用于康复数据库的的最新备份集,以承认备份是不是齐全,查看康复所需求的数据文件副本和归档日志备份集

  本文系中国润滑油信息网(www.sinolub.com)原创作品,若需转载务必以超链接的形式注明出处,转载时严禁任何有悖原文的文字修改;本网有权对所有侵权行为进行责任追究。

分享到: QQ空间 新浪微博 人人网 开心网 腾讯微博 更多

相关新闻

友情提醒

本信息真实性未经中国润滑油信息网证实,仅供您参考。未经许可,请勿转载。已经本网授权使用的,应在授权范围内使用,并注明“来源:中国润滑油信息网”。

本网部分文章转载自其它媒体,转载目的在于传递更多行业信息,并不代表本网赞同其观点和对其真实性负责。在本网论坛上发表言论者,文责自负,本网有权在网站内转载或引用,论坛的言论不代表本网观点。本网所提供的信息,如需使用,请与原作者联系,版权归原作者所有。如果涉及版权需要同本网联系的,请在15日内进行。

官方微博

热点招商

奥吉星润滑油全国招商

奥吉星润滑油(天泰集团化工控股有限公司 股票代码:GTS)是由天泰控股的专业润滑油生产企业。 全国招商热线:400-0635-789

Gulf海湾石油面向全国招商

海湾石油(中国)有限公司是Gulf Oil International 在国内的唯一子公司。 现诚招经销商。 招商热线:0535-2161171

埃尼润滑油面向全国招商

埃尼是一家综合性能源企业,业务遍及83个国家,拥有84,000名员工,从事石油和天然气勘探、生产、运输、转化和营销活动,业务涉及化工、油田服务、建筑和工程领域。

关于我们|本网动态|广告服务|联系方式|免责声明|版权信息|法律顾问
CopyRight©2015-2016 Sinolub.Com All Rights Reserved 九鼎公司 版权所有
《中华人民共和国增值电信业务经营许可证》编号:粤B2-20050302
服务热线:0754-88650988 在线服务QQ:619128006 润滑油商机信息群:③:50693127 ④:65958932