oracle rman恢复表空间,rman恢复部分表空间

最新推荐文章于 2022-04-19 10:28:49 发布
最新推荐文章于 2022-04-19 10:28:49 发布
阅读量397 收藏
点赞数
文章标签： oracle rman恢复表空间

SQL> conn / as sysdba

Connected.

SQL> select name from v$datafile;

NAME

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

/u01/oracle/oradata/orcl/system01.dbf

/u01/oracle/oradata/orcl/sysaux01.dbf

/u01/oracle/oradata/orcl/undotbs01.dbf

/u01/oracle/oradata/orcl/users01.dbf

#创建测试表空间

SQL> create tablespace test1 datafile '/u01/oracle/oradata/orcl/test1_01.dbf' size 20M autoextend on next 1M maxsize unlimited;

Tablespace created.

SQL> create tablespace test2 datafile '/u01/oracle/oradata/orcl/test2_01.dbf' size 20M autoextend on next 1M maxsize unlimited;

Tablespace created.

#创建测试表并插入测试数据

SQL> conn scott/tiger

Connected.

SQL>

SQL> create table t1(id number) tablespace test1;

Table created.

SQL> create table t2(id number) tablespace test2;

Table created.

SQL> insert into t1 values(1);

1 row created.

SQL> insert into t1 values(2);

1 row created.

SQL> insert into t2  values(3);

1 row created.

SQL> insert into t2 values(4);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t1;

ID

----------

1

2

SQL> select * from t2;

ID

----------

3

4

SQL> conn scott/tiger

Connected.

SQL> select table_name from user_tables;

TABLE_NAME

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

T2

T1

SALGRADE

BONUS

EMP

DEPT

SQL> conn / as sysdba

Connected.

SQL>

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  430112768 bytes

Fixed Size                  2253864 bytes

Variable Size             373296088 bytes

Database Buffers           50331648 bytes

Redo Buffers                4231168 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

#备份数据库

run{

allocate channel a1 type disk;

crosscheck backup;

delete noprompt expired backup;

crosscheck archivelog all;

delete noprompt expired archivelog all;

backup as compressed backupset database format '/u01/rman/incr_%T_%d_%s_%p.bak';

sql 'alter system switch logfile';

backup as compressed backupset archivelog all format  '/u01/rman/arc_%T_%d_%s_%p.bak' delete all input;

backup current controlfile format '/u01/rman/ctl_%T_%d_db_%s_%p.bak';

release channel a1;

}

[oracle@oratest dbs]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Jul 19 17:15:12 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1445409661)

RMAN> run{

2>         allocate channel a1 type disk;

3>         crosscheck backup;

4>         delete noprompt expired backup;

5>         crosscheck archivelog all;

6>         delete noprompt expired archivelog all;

7>         backup as compressed backupset database format '/u01/rman/incr_%T_%d_%s_%p.bak';

8>         sql 'alter system switch logfile';

9>         backup as compressed backupset archivelog all format  '/u01/rman/arc_%T_%d_%s_%p.bak' delete all input;

10>         backup current controlfile format '/u01/rman/ctl_%T_%d_db_%s_%p.bak';

11>         release channel a1;

12> }

released channel: ORA_DISK_1

allocated channel: a1

channel a1: SID=29 device type=DISK

specification does not match any backup in the repository

specification does not match any backup in the repository

specification does not match any archived log in the repository

specification does not match any archived log in the repository

Starting backup at 19-JUL-16

channel a1: starting compressed full datafile backup set

channel a1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/oracle/oradata/orcl/system01.dbf

input datafile file number=00002 name=/u01/oracle/oradata/orcl/sysaux01.dbf

input datafile file number=00003 name=/u01/oracle/oradata/orcl/undotbs01.dbf

input datafile file number=00005 name=/u01/oracle/oradata/orcl/test1_01.dbf

input datafile file number=00006 name=/u01/oracle/oradata/orcl/test2_01.dbf

input datafile file number=00004 name=/u01/oracle/oradata/orcl/users01.dbf

channel a1: starting piece 1 at 19-JUL-16

channel a1: finished piece 1 at 19-JUL-16

piece handle=/u01/rman/incr_20160719_ORCL_28_1.bak tag=TAG20160719T180457 comment=NONE

channel a1: backup set complete, elapsed time: 00:01:06

channel a1: starting compressed full datafile backup set

channel a1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel a1: starting piece 1 at 19-JUL-16

channel a1: finished piece 1 at 19-JUL-16

piece handle=/u01/rman/incr_20160719_ORCL_29_1.bak tag=TAG20160719T180457 comment=NONE

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

Finished backup at 19-JUL-16

sql statement: alter system switch logfile

Starting backup at 19-JUL-16

current log archived

channel a1: starting compressed archived log backup set

channel a1: specifying archived log(s) in backup set

input archived log thread=1 sequence=16 RECID=12 STAMP=917633167

input archived log thread=1 sequence=17 RECID=13 STAMP=917633167

channel a1: starting piece 1 at 19-JUL-16

channel a1: finished piece 1 at 19-JUL-16

piece handle=/u01/rman/arc_20160719_ORCL_30_1.bak tag=TAG20160719T180607 comment=NONE

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

channel a1: deleting archived log(s)

archived log file name=/u01/oracle/fast_recovery_area/ORCL/archivelog/2016_07_19/o1_mf_1_16_crvywgmc_.arc RECID=12 STAMP=917633167

archived log file name=/u01/oracle/fast_recovery_area/ORCL/archivelog/2016_07_19/o1_mf_1_17_crvywhn4_.arc RECID=13 STAMP=917633167

Finished backup at 19-JUL-16

Starting backup at 19-JUL-16

channel a1: starting full datafile backup set

channel a1: specifying datafile(s) in backup set

including current control file in backup set

channel a1: starting piece 1 at 19-JUL-16

channel a1: finished piece 1 at 19-JUL-16

piece handle=/u01/rman/ctl_20160719_ORCL_db_31_1.bak tag=TAG20160719T180609 comment=NONE

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

Finished backup at 19-JUL-16

released channel: a1

#恢复数据库

#异机通过pfile文件启动数据库并恢复控制文件，使数据库进入mount状态

SQL> startup mount

ORACLE instance started.

Total System Global Area  430112768 bytes

Fixed Size                  2253864 bytes

Variable Size             373296088 bytes

Database Buffers           50331648 bytes

Redo Buffers                4231168 bytes

Database mounted.

SQL>

[oracle@oratest ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Jul 19 18:08:42 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (not mounted)

RMAN> restore controlfile from '/u01/rman/ctl_20160719_ORCL_db_31_1.bak';

Starting restore at 19-JUL-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

output file name=/u01/oracle/oradata/orcl/control01.ctl

output file name=/u01/oracle/fast_recovery_area/orcl/control02.ctl

Finished restore at 19-JUL-16

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> catalog start with '/u01/rman';

Starting implicit crosscheck backup at 20-JUL-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

Crosschecked 3 objects

Finished implicit crosscheck backup at 20-JUL-16

Starting implicit crosscheck copy at 20-JUL-16

using channel ORA_DISK_1

Finished implicit crosscheck copy at 20-JUL-16

searching for all files in the recovery area

cataloging files...

no files cataloged

searching for all files that match the pattern /u01/rman

List of Files Unknown to the Database

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

File Name: /u01/rman/ctl_20160719_ORCL_db_31_1.bak

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /u01/rman/ctl_20160719_ORCL_db_31_1.bak

#通过restore database skip tablespace命令还原数据文件，忽略掉不需要的表空间

RMAN> restore database skip tablespace TEST2;

Starting restore at 20-JUL-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/oracle/oradata/orcl/system01.dbf

channel ORA_DISK_1: restoring datafile 00002 to /u01/oracle/oradata/orcl/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00003 to /u01/oracle/oradata/orcl/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00004 to /u01/oracle/oradata/orcl/users01.dbf

channel ORA_DISK_1: restoring datafile 00005 to /u01/oracle/oradata/orcl/test1_01.dbf

channel ORA_DISK_1: reading from backup piece /u01/rman/incr_20160719_ORCL_28_1.bak

channel ORA_DISK_1: piece handle=/u01/rman/incr_20160719_ORCL_28_1.bak tag=TAG20160719T180457

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:25

Finished restore at 20-JUL-16

#通过recover database skip tablespace命令恢复数据，忽略掉不需要的表空间

RMAN> recover database skip tablespace TEST2;

Starting recover at 20-JUL-16

using channel ORA_DISK_1

Executing: alter database datafile 6 offline

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=16

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=17

channel ORA_DISK_1: reading from backup piece /u01/rman/arc_20160719_ORCL_30_1.bak

channel ORA_DISK_1: piece handle=/u01/rman/arc_20160719_ORCL_30_1.bak tag=TAG20160719T180607

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

archived log file name=/u01/oracle/fast_recovery_area/ORCL/archivelog/2016_07_20/o1_mf_1_16_crxqy7b3_.arc thread=1 sequence=16

channel default: deleting archived log(s)

archived log file name=/u01/oracle/fast_recovery_area/ORCL/archivelog/2016_07_20/o1_mf_1_16_crxqy7b3_.arc RECID=15 STAMP=917691592

archived log file name=/u01/oracle/fast_recovery_area/ORCL/archivelog/2016_07_20/o1_mf_1_17_crxqy7g2_.arc thread=1 sequence=17

channel default: deleting archived log(s)

archived log file name=/u01/oracle/fast_recovery_area/ORCL/archivelog/2016_07_20/o1_mf_1_17_crxqy7g2_.arc RECID=14 STAMP=917691591

unable to find archived log

archived log thread=1 sequence=18

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 07/20/2016 10:19:55

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 18 and starting SCN of 991122

#通过open resetlogs打开数据库

SQL> conn / as sysdba

Connected.

SQL>

SQL>

SQL> alter database open resetlogs;

Database altered.

#检查结果

SQL> select name from v$tablespace;

NAME

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

SYSTEM

SYSAUX

UNDOTBS1

USERS

TEMP

TEST1

TEST2

7 rows selected.

SQL> select name from v$datafile;

NAME

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

/u01/oracle/oradata/orcl/system01.dbf

/u01/oracle/oradata/orcl/sysaux01.dbf

/u01/oracle/oradata/orcl/undotbs01.dbf

/u01/oracle/oradata/orcl/users01.dbf

/u01/oracle/oradata/orcl/test1_01.dbf

/u01/oracle/oradata/orcl/test2_01.dbf

6 rows selected.

SQL> conn scott/tiger

Connected.

SQL>

SQL> select * from t1;

ID

----------

1

2

SQL> select * from t2;

select * from t2

*

ERROR at line 1:

ORA-00376: file 6 cannot be read at this time

ORA-01110: data file 6: '/u01/oracle/oradata/orcl/test2_01.dbf'

[root@oratest ~]# ls /u01/oracle/oradata/orcl/

control01.ctl  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  test1_01.dbf  undotbs01.dbf  users01.dbf

track Yang
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
RMAN-03002 RMAN-20242: specification does not match any archived log in the repository
EVISWANG的博客
03-21 6884
RMAN> run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_SERV=nbusrv, NB_ORA_CLIENT=Pbdopdb'; restore archivelog from sequence 34722 until sequence 34723 INCARNATION ALL; RELEAS...
mysql 归档日志恢复_RMAN 还原归档日志(restore archivelog)
weixin_33574009的博客
02-07 1728
听说过还原(restore)数据库，表空间及数据库文件，使用归档日志恢复(recover)数据库，表空间，数据库文件。咦，还有还原归档日志这一说法呢？没错，可能我们忽略了还原归档日志这一个过程，原因是还原归档日志通常情况下是Oracle在recover时自动完成的。大多数情况下我们是先还原数据库，恢复数据库，打开数据库。实际上在恢复数据库之前有一个动作，那就是还原归档日志，也就是将日志文件还原到缺...
specification does not match any archive log in the recovery catalog;
congnie1720的博客
05-20 1691
问 题：为什么会出现specification does not match any archive log in the recovery catalog； 备份脚本： run{ .....
How to delete expired archive log files using rman?
weixin_33775572的博客
06-25 113
he following commands will helpful to delete the expired archive log files using Oracle Recovery Manager(RMAN).Connect to the Rman prompt and try the bellow commands.     RMAN>list expired archive...
RMAN备份数据
weixin_33720078的博客
04-13 114
RMAN使用 1、 数据库状态 打开数据库，检查数据库是否处于归档模式 conn /as sysdba SQL> startup mount ORACLE instance started. Total System Global Area443592704 bytes Fixed Size...
顶级DBA漫谈Oracle Rman备份与恢复
09-01
Oracle RMAN 备份与恢复概述 Oracle RMAN（Recovery Manager）是一种强大的备份和恢复工具，旨在帮助DBA管理员更好地管理和保护Oracle数据库。以下是Oracle RMAN备份与恢复的相关知识点： 备份恢复概述 备份恢复...
实战Oracle rman还原和恢复
04-22
3. 执行恢复：通过RMAN恢复表空间，包括离线数据文件、设置新名称、恢复、切换数据文件和重新上线。 三、特殊情况处理 1. 系统表空间丢失：如果系统表空间（如SYSTEM或SYSAUX）的数据文件丢失，RMAN同样可以处理。...
Oracle 12c备份恢复-RMAN工具技术手册
12-27
Oracle 12c 备份恢复-RMAN 工具技术手册 本文档旨在提供 Oracle 12c 备份恢复的技术手册，主要介绍 RMAN 工具的概念、架构、备份类型和使用方法。 一、RMAN 概念 RMAN（Recovery Manager）是 Oracle 推荐的备份和...
Oracle 表空间时点恢复(TSPITR)
12-15
表空间时点恢复，是Oracle在基于冷备，热备恢复以外的一种以表空间为粒度的，不完全恢复的形式来将表空间恢复到过去某个特定的时间点的一种恢复方式。它整合了RMAN以及DataPump这2个备份恢复工具来实现时点恢复。那...
Oracle RMAN异机不完全恢复
08-11
此文档详细描述如果利用rman 完成不完全恢复。试验背景，步骤，命令，所有内容都做说明。
RMAN ---delete obsolete 不能删除 控制文件copy
xxjj2003的专栏
10-08 856
RMAN ---delete obsolete 不能删除 控制文件copy lixora   RMAN ---delete obsolete  不能删除 控制文件copy 说明 /tmp/contrlfile   /tmp/controlfile.bkp    /home/oracle/control01.ctl  已经通过os命令删除了 现在的疑问是如何删除这些...
DG环境RMAN删除归档报错RMAN-08137: archived log not deleted
yangjunfeng0604的博客
06-26 869
Oracle 12C DG环境，备库归档目录告警，查看crontab脚本，发现有删除操作，保持两天的，后手动执行，查看具体报错原因； RMAN> delete noprompt expired archivelog all; released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=540...
RMAN备份恢复系列之系统表空间恢复
kevin-ke的专栏
05-07 1063
RMAN 备份恢复系列之系统表空间恢复
使用RMAN恢复表空间
七海琉璃的博客
04-19 1170
RMAN表空间恢复1.前期准备1.1 添加一个新的表空间进行试验1.2 验证创建1.3 使用rman进行备份2.删除表空间3.恢复表空间3.1查看日志，找到删除的时间点3.2 使用rman进行恢复3.3 验证恢复4.也可以查询scn来进行恢复操作4.1 登录数据库查询4.2 登录RMAN恢复 1.前期准备 1.1 添加一个新的表空间进行试验 SYS@hfdr>create tablespace zhangyun datafile '/u01/app/oracle/oradata/recover
Oracle误删除dbf文件和表空间恢复
Dreams_KS的博客
04-08 4830
Oracle物理删除dbf文件和表空间恢复 参考： https://www.iteye.com/blog/java-mans-1642954 https://blog.csdn.net/qq_42774325/article/details/82353266 https://www.cnblogs.com/l10n/p/9406052.html 今天在dmp数据时入错了；想着把表空间文件直接删了，重新入；这想当然的操作，导致后面浪费了时间； 题目说恢复并非指“恢复数据”，确切来说指的是“修复”或“复原”
oracle 恢复用户表空间,异机恢复某用户表空间到单机
weixin_42349295的博客
04-04 261
1 背景描述：将RAC 某个表空间异机恢复至单实例，以检验数据的可用性。1.1 RACDB数据库基本配置信息主机 节点1: rac1 操作系统：LIUNX 6.5节点2: rac2 操作系统：LIUNX 6.5数据库版本 Oracle11.2.0.4 RACOS用户名/组 uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),...
ORACLE RMAN备份恢复单个表空间
pool_Sneaker的博客
05-14 2532
原因 单个库可能有很多的冗余数据，比如查询库，通过ogg等方式同的数据，当这台库上做其他的分析或者是另一个有业务的主库的时。就有需求做备份恢复。 但是本身是一个查询库，整库rman备份非常的慢。 通过nbu或者rman可以备份单个schema（一个schema对应一个表空间），这样速度快，恢复快。 步骤 1.准备好参数文件（略） 2.获取控制文件，启动到mount startup nomount;...
oracle的rman如何恢复只读表空间
最新发布
09-23
Oracle的RMAN（Recovery Manager）可以用于恢复只读表空间。以下是恢复只读表空间的步骤： 1. 首先，确定需要恢复的只读表空间的名称。可以通过查询数据库的v$tablespace视图来获取表空间的信息。 2. 在RMAN命令行...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值