Bo's Oracle Station

查看: 1993|回复: 0

课程第28次(2016-05-30星期一):闪回数据库和不完全恢复的对比续

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-5-31 09:24:25 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2016-5-31 09:27 编辑

做8a和14实验

select  * from v$flashback_database_log;

--1092922

--5/28/2016 9:47:31 AM
  1. [oracle@station90 ~]$ rman target /   catalog u90/oracle_4U@rcat  

  2. Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 31 09:22:44 2016

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

  4. connected to target database: ORCL (DBID=1343950367)
  5. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 6 days

  6. connected to recovery catalog database

  7. RMAN> backup tag '4TAPE-WHOLE-FULL'  database plus archivelog  delete all input;
复制代码


  1. Recovery Manager complete.
  2. [oracle@station90 ~]$ rman target /   catalog u90/oracle_4U@rcat  

  3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 31 09:22:44 2016

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

  5. connected to target database: ORCL (DBID=1343950367)
  6. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 6 days

  7. connected to recovery catalog database

  8. RMAN> restore controlfile from tag 'LABS-14-CONTR-BEFORE-DROP';
复制代码
  1. Recovery Manager complete.
  2. [oracle@station90 ~]$ rman target /   catalog u90/oracle_4U@rcat  

  3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 31 09:22:44 2016

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

  5. connected to target database: ORCL (DBID=1343950367)
  6. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 6 days

  7. connected to recovery catalog database

  8. RMAN> run {
  9. 2> sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
  10. 3> set until time '2016-05-30:21:49:01';
  11. 4> restore database;
  12. 5> recover database;
  13. 6> recover database;}
复制代码

Screenshot.png



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 13:52 , Processed in 0.039793 second(s), 27 queries .

快速回复 返回顶部 返回列表