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

botang

做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. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 31 09:22:44 2016
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 6 days
   
9. 
   
10. connected to recovery catalog database
    
11. 
    
12. 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. 
   
4. Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 31 09:22:44 2016
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
7. 
   
8. connected to target database: ORCL (DBID=1343950367)
   
9. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 6 days
   
10. 
    
11. connected to recovery catalog database
    
12. 
    
13. 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. 
   
4. Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 31 09:22:44 2016
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
7. 
   
8. connected to target database: ORCL (DBID=1343950367)
   
9. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 6 days
   
10. 
    
11. connected to recovery catalog database
    
12. 
    
13. RMAN> run {
    
14. 2> sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
    
15. 3> set until time '2016-05-30:21:49:01';
    
16. 4> restore database;
    
17. 5> recover database;
    
18. 6> recover database;}
    

复制代码