您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息
三六零分类信息网 > 文山分类信息网,免费分类信息发布

rman 恢复--current redo 损坏的情况

2025/5/31 19:18:16发布8次查看
用rman恢复,current redo 日志损坏的情况1、做全库备份rmangt; run{ allocate channel c1 type disk maxpiecesize=500m; backu
用rman恢复,current redo 日志损坏的情况
1、做全库备份
rman> run{
 allocate channel c1 type disk maxpiecesize=500m;
 backup current controlfile format '+dgasm/backup/haozg/ctl_%d_%s';
 backup full database format '+dgasm/backup/haozg/db_%d_%s_%p_%t';
 release channel c1;
 }2> 3> 4> 5> 6>
released channel: ora_disk_1
allocated channel: c1
channel c1: sid=19 device type=disk
starting backup at 02-jul-12
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 02-jul-12
channel c1: finished piece 1 at 02-jul-12
piece handle=+dgasm/backup/haozg/ctl_ora11_57 tag=tag20120702t110101 comment=none
channel c1: backup set complete, elapsed time: 00:00:03
finished backup at 02-jul-12
starting backup at 02-jul-12
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+dgasm/ora11/datafile/system.257.785186755
input datafile file number=00002 name=+dgasm/ora11/datafile/sysaux.258.785186845
input datafile file number=00003 name=+dgasm/ora11/datafile/undotbs1.259.785186901
input datafile file number=00004 name=+dgasm/ora11/datafile/users.272.787487359
channel c1: starting piece 1 at 02-jul-12
channel c1: finished piece 1 at 02-jul-12
piece handle=+dgasm/backup/haozg/db_ora11_58_1_787575668 tag=tag20120702t110107 comment=none
channel c1: starting piece 2 at 02-jul-12
channel c1: finished piece 2 at 02-jul-12
piece handle=+dgasm/backup/haozg/db_ora11_58_2_787575668 tag=tag20120702t110107 comment=none
channel c1: backup set complete, elapsed time: 00:01:10
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current spfile in backup set
channel c1: starting piece 1 at 02-jul-12
channel c1: finished piece 1 at 02-jul-12
piece handle=+dgasm/backup/haozg/db_ora11_59_1_787575738 tag=tag20120702t110107 comment=none
channel c1: backup set complete, elapsed time: 00:00:02
finished backup at 02-jul-12
released channel: c1
rman>
2、做操作,,让不同的操作分布在不同的归档日志文件中,并且检查日志情况和检查点情况
sql> select first_change#,next_change#,group#,sequence#,status from v$log;
first_change# next_change#     group#  sequence# status
------------- ------------ ---------- ---------- ----------------
       999200       999353          1          7 inactive
       999353       999426          2          8 inactive
       999426   2.8147e+14          3          9 current
sql> create table test22(aab001 varchar(15),aab003 varchar(20));
table created.
sql>  insert into test22 values ('soft','0001');
1 row created.
sql> /
1 row created.
sql> /
1 row created.
sql> commit;
commit complete.
sql> select * from test22;
aab001          aab003
--------------- --------------------
soft            0001
soft            0001
soft            0001
sql> alter system switch logfile;
system altered.
sql> select first_change#,next_change#,group#,sequence#,status from v$log;
first_change# next_change#     group#  sequence# status
------------- ------------ ---------- ---------- ----------------
      1000076   2.8147e+14          1         10 current
       999353       999426          2          8 inactive
       999426      1000076          3          9 active
sql>  create table test33(aab001 number,aab004 varchar2(19));
table created.
sql> insert into test33 values(1,'zhang');
1 row created.
sql> /.
1 row created.
sql> /
1 row created.
sql> commit;
commit complete.
sql> select * from test33;
    aab001 aab004
---------- -------------------
         1 zhang
         1 zhang
         1 zhang
sql> alter system switch logfile;
system altered.
sql>  select first_change#,next_change#,group#,sequence#,status from v$log;
first_change# next_change#     group#  sequence# status
------------- ------------ ---------- ---------- ----------------
      1000076      1000117          1         10 active
      1000117   2.8147e+14          2         11 current
       999426      1000076          3          9 active
sql> create table c_test(aac001 varchar2(10),name varchar2(13));
table created.
sql> insert into c_test values('1392027','haozg');
1 row created.
sql> /
1 row created.
sql> /.
1 row created.
sql> /
1 row created.
sql> commit;
commit complete.
sql> select * from c_test;
aac001     name
---------- -------------
1392027    haozg
1392027    haozg
1392027    haozg
1392027    haozg
sql> select first_change#,next_change#,group#,sequence#,status from v$log;
first_change# next_change#     group#  sequence# status
------------- ------------ ---------- ---------- ----------------
      1000076      1000117          1         10 active
      1000117   2.8147e+14          2         11 current
       999426      1000076          3          9 active
3、shutdown abort
sql> shutdown abort;
oracle instance shut down.
文山分类信息网,免费分类信息发布

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product