第21次-第24次：2015-07-11--2015-0712星期六和星期日

botang

第21次-第24次：2015-07-11--2015-0712星期六和星期日

上完1Z0-053第7章        （52-15）


2015-07-12.sql

1. select  * from v$logfile;
   
2. 
   
3. select  * from v$log;
   
4. 
   
5. alter database drop logfile group 1;
   
6. 
   
7. alter database add logfile group 1  size 50M;
   
8. 
   
9. alter database drop logfile group 2;
   
10. 
    
11. alter database add logfile group 2  size 50M;
    
12. 
    
13. alter system switch logfile;
    
14. 
    
15. alter database drop logfile group 3;
    
16. 
    
17. alter system checkpoint;
    
18. 
    
19. alter database drop logfile group 3;
    
20. 
    
21. alter database add logfile group 3  size 50M;
    
22. 
    
23. select  * from v$logfile;
    
24. 
    
25. select  * from v$datafile;

复制代码

2015-07-12-rman.txt：

1. SQL> conn / as sysdba
   
2. Connected.
   
3. SQL> show parameter db_recovery
   
4. 
   
5. NAME                                     TYPE         VALUE
   
6. ------------------------------------ ----------- ------------------------------
   
7. db_recovery_file_dest                     string         /u01/app/oracle/flash_recovery
   
8.                                                  _area
   
9. db_recovery_file_dest_size             big integer 3882M
   
10. SQL> alter system set db_recovery_file_dest='/u01/app/oracle/oradata';
    
11. 
    
12. System altered.
    
13. 
    
14. SQL> exit
    
15. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    
16. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
17. and Real Application Testing options
    
18. [oracle@station90 ~]$ rman target  /
    
19. 
    
20. Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jul 12 17:30:36 2015
    
21. 
    
22. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
23. 
    
24. connected to target database: ORCL (DBID=1343950367, not open)
    
25. 
    
26. RMAN> backup as copy database ;
    
27. 
    

复制代码

lx978

老师麻烦看看哈
迁移到ASM
        1、日志文件迁移
        sqlplus /nolog
        conn  / as sysdba
        show parameter db_recovery
        alter system set db_recovery_file_dest=+FRA;
        alter system set db_create_file_dest=+DATA;       
        select * from v$log;        日志组查看 --inactive的删除  如果没有inactive 就做全局检查点弄出inactive
        alter system switch logfile;
        alter database checkpoint;
       
        alter database drop logfile group 1
        alter database add logfile member '+DATA' to group 1;
        alter database drop logfile group 2
        alter database add logfile member '+DATA' to group 3;
        alter database drop logfile group 3
        alter database add logfile member '+DATA' to group 2;
       

        2、数据文件迁移
        shutdown immediate
        startup mount
        exit
        rman target /
        backup as copy database format '+DATA';
        switch database to copy;       
        exit
        sqlplus /nolog
        conn  / as sysdba
        select * from v$datafile;        --查看下是否在ASM里了               

        3、控制文件迁移
        alter database backup controlfile to trace as '/home/oracle/control8c.sql'
        shutdown immediate
        startup nomount
        exit
        vim 8c.sql        set1

        sqlplus /nolog
        conn  / as sysdba
        @8c.sql
        alter database open;
        show parameter spfile;
        create pfile from spfile;  
        create spfile from pfile;  
        shutdown immediate
        startup
        show parameter spfile
        alter tablespace temp add tempfile '+DATA' size 20M antoextend on;

admin

lx978 发表于 2015-7-13 20:29
老师麻烦看看哈
迁移到ASM
        1、日志文件迁移

对的，是这样的

admin

lx978 发表于 2015-7-13 20:29
老师麻烦看看哈
迁移到ASM
        1、日志文件迁移

对的，是这样的

admin

lx978 发表于 2015-7-13 20:29
老师麻烦看看哈
迁移到ASM
        1、日志文件迁移

对的，是这样的

admin

lx978 发表于 2015-7-13 20:29
老师麻烦看看哈
迁移到ASM
        1、日志文件迁移

对的，是这样的