Chinaunix首页 | 论坛 | 博客

庸玉汝于成

首页　| 　博文目录　| 　关于我

liupzmin

  • 博客访问： 3116
  • 博文数量： 1
  • 博客积分： 0
  • 博客等级： 民兵
  • 技术积分： 21
  • 用 户 组： 普通用户
  • 注册时间： 2015-09-21 09:35
文章分类

全部博文（1）

文章存档

2015年（1）

我的朋友
最近访客
推荐博文
相关博文
【RMAN】异机异目录完全恢复

分类： Oracle

2015-09-21 13:05:03

rman异机异目录完全恢复
环境：
    源库：
        os：redhat 6.3 x64
        db: 11gr2 11.2.0.4
        存储方式：ASM
    目标库：
        os：redhat 6.5 x64 
        db: 11gr2 11.2.0.4
        存储方式：文件系统


  1. 首先，源库进行rman备份
        


点击(此处)折叠或打开

  1. --手动0级全库备份
  2. run {
  3.     CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
  4.     CONFIGURE BACKUP OPTIMIZATION ON;
  5.     CONFIGURE CONTROLFILE AUTOBACKUP ON;
  6.     CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
  7.     CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+DATA/backup/ctl_atuo_%F';
  8.     ALLOCATE CHANNEL c1 TYPE DISK;
  9.     ALLOCATE CHANNEL c2 TYPE DISK;
  10.     CROSSCHECK ARCHIVELOG ALL;
  11.     BACKUP INCREMENTAL LEVEL 0
  12.     DATABASE FORMAT '+DATA/backup/db_%U' TAG 'db_rman';
  13.     SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
  14.     BACKUP ARCHIVELOG ALL FORMAT '+DATA/backup/arc_%U' TAG 'ARC_rman'
  15.     DELETE INPUT;
  16.     DELETE NOPROMPT OBSOLETE;
  17.     RELEASE CHANNEL c1;
  18.     RELEASE CHANNEL c2;
  19. }

观察备份的文件，此处是ASM分别用asmcmd和rman查看，

点击(此处)折叠或打开

  1. ASMCMD> ls
  2. arc_0cqhdnqq_1_1
  3. arc_0dqhdnqq_1_1
  4. ctl_atuo_c-2496627597-20150917-00
  5. ctl_atuo_c-2496627597-20150917-01
  6. db_09qhdno6_1_1
  7. db_0aqhdno6_1_1
  8. ASMCMD> pwd
  9. +Data/backup
  10. ASMCMD>
  12. RMAN> list backup summary;
  15. List of Backups
  16. ===============
  17. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
  18. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
  19. 9 B 0 A DISK 17-SEP-15 1 1 NO DB_RMAN
  20. 10 B 0 A DISK 17-SEP-15 1 1 NO DB_RMAN
  21. 11 B F A DISK 17-SEP-15 1 1 NO TAG20150917T221650
  22. 12 B A A DISK 17-SEP-15 1 1 NO ARC_RMAN
  23. 13 B A A DISK 17-SEP-15 1 1 NO ARC_RMAN
  24. 14 B F A DISK 17-SEP-15 1 1 NO TAG20150917T221703

为了试验restore之后recover应用归档日志的情况，我在0级备份之后再生成一些归档日志，脚本如下：

点击(此处)折叠或打开

  1. declare
  2.   i integer;
  3. begin
  4.   for i in 1..3000000 loop
  5.     insert into t values(i,'aaaaaaaaaaaaaaaaaaaaa');
  6.     end loop;
  7. end;

向测试表T中插入200万行数据，看归档的日志：

点击(此处)折叠或打开

  1. ASMCMD> ls
  2. 1_22_854775184.dbf
  3. 1_23_854775184.dbf
  4. 1_24_854775184.dbf
  5. 1_25_854775184.dbf
  6. 1_26_854775184.dbf
  7. 1_27_854775184.dbf
  8. 1_28_854775184.dbf
  9. 1_29_854775184.dbf
  10. 1_30_854775184.dbf
  11. 1_31_854775184.dbf
  12. 1_32_854775184.dbf
  13. 1_33_854775184.dbf
  14. 1_34_854775184.dbf
  15. 1_35_854775184.dbf
  16. 1_36_854775184.dbf
  17. 1_37_854775184.dbf
  18. 1_38_854775184.dbf
  19. 1_39_854775184.dbf

查看T表的行数

点击(此处)折叠或打开

  1. SQL> select count(1) from t;

  3.   COUNT(1)
  4. ----------
  5.    3000000


2. 现在要把rman备份，备份之后的归档，源库关闭之后的在线redo文件拷贝到备库，这里稍微麻烦一点，涉及到从asm中拷贝文件，我这里使用2中方法，rman的backup as cpoy以及asmcmd的cp命令，如下所示：

点击(此处)折叠或打开

  1. --这里是copy 0级备份
  2. backup as copy backupset 9 format '/u01/backupset/db2.rman';
  3. backup as copy backupset 10 format '/u01/backupset/db2.rman';
  4. backup as copy backupset 11 format '/u01/backupset/ctl1.rman';
  5. backup as copy backupset 12 format '/u01/backupset/arc1.rman';
  6. backup as copy backupset 13 format '/u01/backupset/arc2.rman';
  7. backup as copy backupset 14 format '/u01/backupset/ctl2.rman';
  10. --生成的归档日志
  11. ASMCMD> ls
  12. 1_22_854775184.dbf
  13. 1_23_854775184.dbf
  14. 1_24_854775184.dbf
  15. 1_25_854775184.dbf
  16. 1_26_854775184.dbf
  17. 1_27_854775184.dbf
  18. 1_28_854775184.dbf
  19. 1_29_854775184.dbf
  20. 1_30_854775184.dbf
  21. 1_31_854775184.dbf
  22. 1_32_854775184.dbf
  23. 1_33_854775184.dbf
  24. 1_34_854775184.dbf
  25. 1_35_854775184.dbf
  26. 1_36_854775184.dbf
  27. 1_37_854775184.dbf
  28. 1_38_854775184.dbf
  29. 1_39_854775184.dbf
--copy走，无法使用通配符是一件很痛苦的事情
  1. ASMCMD> cp 1_23_854775184.dbf /u02/backupset
  2. copying +Data/archive_log/1_23_854775184.dbf -> /u02/backupset/1_23_854775184.dbf
  3. ASMCMD> cp 1_24_854775184.dbf /u02/backupset
  4. copying +Data/archive_log/1_24_854775184.dbf -> /u02/backupset/1_24_854775184.dbf
  5. ASMCMD> cp 1_25_854775184.dbf /u02/backupset
  6. copying +Data/archive_log/1_25_854775184.dbf -> /u02/backupset/1_25_854775184.dbf
  7. ASMCMD> cp 1_26_854775184.dbf /u02/backupset
  8. copying +Data/archive_log/1_26_854775184.dbf -> /u02/backupset/1_26_854775184.dbf
  9. ASMCMD> cp 1_27_854775184.dbf /u02/backupset
  10. copying +Data/archive_log/1_27_854775184.dbf -> /u02/backupset/1_27_854775184.dbf
  11. ASMCMD> cp 1_28_854775184.dbf /u02/backupset
  12. copying +Data/archive_log/1_28_854775184.dbf -> /u02/backupset/1_28_854775184.dbf
  13. ASMCMD> cp 1_29_854775184.dbf /u02/backupset
  14. copying +Data/archive_log/1_29_854775184.dbf -> /u02/backupset/1_29_854775184.dbf
  15. ASMCMD> cp 1_3* /u02/backupset
  16. copying +Data/archive_log/1_30_854775184.dbf -> /u02/backupset/1_30_854775184.dbf
  17. ASMCMD> cp 1_31_854775184.dbf /u02/backupset
  18. copying +Data/archive_log/1_31_854775184.dbf -> /u02/backupset/1_31_854775184.dbf
  19. ASMCMD> cp 1_32_854775184.dbf /u02/backupset
  20. copying +Data/archive_log/1_32_854775184.dbf -> /u02/backupset/1_32_854775184.dbf
  21. ASMCMD> cp 1_33_854775184.dbf /u02/backupset
  22. copying +Data/archive_log/1_33_854775184.dbf -> /u02/backupset/1_33_854775184.dbf
  23. ASMCMD> cp 1_34_854775184.dbf /u02/backupset
  24. copying +Data/archive_log/1_34_854775184.dbf -> /u02/backupset/1_34_854775184.dbf
  25. ASMCMD> cp 1_35_854775184.dbf /u02/backupset
  26. copying +Data/archive_log/1_35_854775184.dbf -> /u02/backupset/1_35_854775184.dbf
  27. ASMCMD> cp 1_36_854775184.dbf /u02/backupset
  28. copying +Data/archive_log/1_36_854775184.dbf -> /u02/backupset/1_36_854775184.dbf
  29. ASMCMD> cp 1_37_854775184.dbf /u02/backupset
  30. copying +Data/archive_log/1_37_854775184.dbf -> /u02/backupset/1_37_854775184.dbf
  31. ASMCMD> cp 1_38_854775184.dbf /u02/backupset
  32. copying +Data/archive_log/1_38_854775184.dbf -> /u02/backupset/1_38_854775184.dbf
  33. ASMCMD> cp 1_39_854775184.dbf /u02/backupset
  34. copying +Data/archive_log/1_39_854775184.dbf -> /u02/backupset/1_39_854775184.dbf
  38. --查看当前的redo状态
  39. SQL> select group#,SEQUENCE# ,MEMBERS,ARCHIVED,STATUS from v$log;
  41. GROUP# SEQUENCE# MEMBERS ARC STATUS
  42. ---------- ---------- ---------- --- ----------------
  43. 1 40 2 NO CURRENT
  44. 2 38 2 YES INACTIVE
  45. 3 39 2 YES INACTIVE

--查看redo文件
  2. SQL> select GROUP#,STATUS,MEMBER from v$logfile;
  4. GROUP# STATUS MEMBER
  5. ---------- ------- --------------------------------------------------------------------------------
  6. 3 +DATA/min/onlinelog/group_3.266.854775193
  7. 3 +DATA/min/onlinelog/group_3.267.854775195
  8. 2 +DATA/min/onlinelog/group_2.264.854775189
  9. 2 +DATA/min/onlinelog/group_2.265.854775191
  10. 1 +DATA/min/onlinelog/group_1.262.854775185
  11. 1 +DATA/min/onlinelog/group_1.263.854775187
  13. --使用asmcmd拷贝并改名
  14. ASMCMD> cd onlinelog
  15. ASMCMD>
  16. ASMCMD> ls
  17. group_1.262.854775185
  18. group_1.263.854775187
  19. group_2.264.854775189
  20. group_2.265.854775191
  21. group_3.266.854775193
  22. group_3.267.854775195

  24. ASMCMD> cp group_1.262.854775185 /u02/backupset/redo1a.log
  25. copying +Data/min/onlinelog/group_1.262.854775185 -> /u02/backupset/redo1a.log
  26. ASMCMD> cp group_1.263.854775187 /u02/backupset/redo1b.log
  27. copying +Data/min/onlinelog/group_1.263.854775187 -> /u02/backupset/redo1b.log
  28. ASMCMD> cp group_2.264.854775189 /u02/backupset/redo2a.log
  29. copying +Data/min/onlinelog/group_2.264.854775189 -> /u02/backupset/redo2a.log
  30. ASMCMD> cp group_2.265.854775191 /u02/backupset/redo2b.log
  31. copying +Data/min/onlinelog/group_2.265.854775191 -> /u02/backupset/redo2b.log
  32. ASMCMD> cp group_3.266.854775193 /u02/backupset/redo3a.log
  33. copying +Data/min/onlinelog/group_3.266.854775193 -> /u02/backupset/redo3a.log
  34. ASMCMD> cp group_3.267.854775195 /u02/backupset/redo3b.log
  35. copying +Data/min/onlinelog/group_3.267.854775195 -> /u02/backupset/redo3b.log

3.  目标机器恢复
    这一步之前已经在目标主机安装好oracle软件，安装过程不再赘述，直接记录恢复过程
    这里直接从备份中恢复pfile（比较懒，不想手动准备），无参数文件，rman会启动一个傻瓜实例，供我们恢复参数文件

点击(此处)折叠或打开

  1. RMAN> startup nomount
  3. startup failed: ORA-01078: failure in processing system parameters
  4. LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initmin.ora'
  6. starting Oracle instance without parameter file for retrieval of spfile
  7. Oracle instance started
  9. Total System Global Area 1068937216 bytes
  11. Fixed Size 2260088 bytes
  12. Variable Size 281019272 bytes
  13. Database Buffers 780140544 bytes
  14. Redo Buffers 5517312 bytes
  17. RMAN> restore spfile to pfile '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initmin.ora' from '/u01/rmanbackup/ctl2.rman';
  19. Starting restore at 18-SEP-15
  20. using target database control file instead of recovery catalog
  21. allocated channel: ORA_DISK_1
  22. channel ORA_DISK_1: SID=171 device type=DISK
  24. channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u01/rmanbackup/ctl2.rman
  25. channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
  26. Finished restore at 18-SEP-15
  28. RMAN> shutdown abort
  30. Oracle instance shut down
  32. RMAN>

创建目录，修改参数文件

点击(此处)折叠或打开

  1. [oracle@rman_newhost u01]$ mkdir -p /u01/app/oracle/admin/min/adump
  2. [oracle@rman_newhost u01]$ mkdir -p /u01/app/oracle/fast_recovery_area
  3. [oracle@rman_newhost u01]$ mkdir -p /u01/app/oracle/archived_log
  4. [oracle@rman_newhost u01]$ mkdir -p /u01/app/oracle/oradata/min
  6. *.audit_file_dest='/u01/app/oracle/admin/min/adump'
  7. *.audit_trail='db'
  8. *.compatible='11.2.0.4.0'
  9. *.control_files='/u01/app/oracle/fast_recovery_area/control01.ctl','/u01/app/oracle/oradata/min/control02.ctl'
  10. *.db_block_size=8192
  11. *.db_domain=''
  12. *.db_name='min'
  13. *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
  14. *.db_recovery_file_dest_size=4385144832
  15. *.diagnostic_dest='/u01/app/oracle'
  16. *.dispatchers='(PROTOCOL=TCP) (SERVICE=minXDB)'
  17. *.log_archive_dest_1='location=/u01/app/oracle/archived_log'
  18. *.log_checkpoints_to_alert=TRUE
  19. *.memory_target=1394606080
  20. *.open_cursors=300
  21. *.processes=1500
  22. *.remote_login_passwordfile='EXCLUSIVE'
  23. *.sessions=1655
  24. *.undo_tablespace='UNDOTBS1'

启动到nomount状态，恢复控制文件

点击(此处)折叠或打开

  1. RMAN> startup nomount
  3. connected to target database (not started)
  4. Oracle instance started
  6. Total System Global Area 1402982400 bytes
  8. Fixed Size 2253184 bytes
  9. Variable Size 1275072128 bytes
  10. Database Buffers 117440512 bytes
  11. Redo Buffers 8216576 bytes
  13. RMAN> restore controlfile from '/u01/rmanbackup/ctl2.rman';
  15. Starting restore at 18-SEP-15
  16. allocated channel: ORA_DISK_1
  17. channel ORA_DISK_1: SID=1146 device type=DISK
  19. channel ORA_DISK_1: restoring control file
  20. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
  21. output file name=/u01/app/oracle/fast_recovery_area/control01.ctl
  22. output file name=/u01/app/oracle/oradata/min/control02.ctl
  23. Finished restore at 18-SEP-15
  25. RMAN> alter database mount;
  27. database mounted
  28. released channel: ORA_DISK_1


     将redo文件和归档日志移动到对应目录下

点击(此处)折叠或打开

  1. [oracle@rman_newhost rmanbackup]$ mv redo* /u01/app/oracle/oradata/min
  2. [oracle@rman_newhost rmanbackup]$ ll /u01/app/oracle/oradata/min
  3. 总用量 316744
  4. -rw-r-----. 1 oracle oinstall 9748480 9月 18 00:34 control02.ctl
  5. -rw-r--r--. 1 oracle oinstall 52429312 9月 17 23:00 redo1a.log
  6. -rw-r--r--. 1 oracle oinstall 52429312 9月 17 23:01 redo1b.log
  7. -rw-r--r--. 1 oracle oinstall 52429312 9月 17 23:01 redo2a.log
  8. -rw-r--r--. 1 oracle oinstall 52429312 9月 17 23:01 redo2b.log
  9. -rw-r--r--. 1 oracle oinstall 52429312 9月 17 23:02 redo3a.log
  10. -rw-r--r--. 1 oracle oinstall 52429312 9月 17 23:02 redo3b.log
  11. [oracle@rman_newhost rmanbackup]$ mv 1_* /u01/app/oracle/archived_log
  12. [oracle@rman_newhost rmanbackup]$ ll /u01/app/oracle/archived_log
  13. 总用量 809056
  14. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:48 1_22_854775184.dbf
  15. -rw-r--r--. 1 oracle oinstall 39179776 9月 17 22:49 1_23_854775184.dbf
  16. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:49 1_24_854775184.dbf
  17. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:50 1_25_854775184.dbf
  18. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:50 1_26_854775184.dbf
  19. -rw-r--r--. 1 oracle oinstall 48581120 9月 17 22:50 1_27_854775184.dbf
  20. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:51 1_28_854775184.dbf
  21. -rw-r--r--. 1 oracle oinstall 42950144 9月 17 22:51 1_29_854775184.dbf
  22. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:51 1_30_854775184.dbf
  23. -rw-r--r--. 1 oracle oinstall 50134016 9月 17 22:53 1_31_854775184.dbf
  24. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:53 1_32_854775184.dbf
  25. -rw-r--r--. 1 oracle oinstall 46714368 9月 17 22:53 1_33_854775184.dbf
  26. -rw-r--r--. 1 oracle oinstall 44308480 9月 17 22:54 1_34_854775184.dbf
  27. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:54 1_35_854775184.dbf
  28. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:54 1_36_854775184.dbf
  29. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:54 1_37_854775184.dbf
  30. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:55 1_38_854775184.dbf
  31. -rw-r--r--. 1 oracle oinstall 46381568 9月 17 22:55 1_39_854775184.dbf

下面一步的操作是删掉控制文件中对备份的记录信息，因为这是源库备份恢复过来的，我们要删掉老的备份信息，将备份重新注册，不删也没关系，crosscheck以后你会发现，原来的备份状态都是expired的

点击(此处)折叠或打开

  1. RMAN> list backup summary;


  4. List of Backups
  5. ===============
  6. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
  7. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
  8. 9 B 0 A DISK 17-SEP-15 1 1 NO DB_RMAN
  9. 10 B 0 A DISK 17-SEP-15 1 1 NO DB_RMAN
  10. 11 B F A DISK 17-SEP-15 1 1 NO TAG20150917T221650
  11. 12 B A A DISK 17-SEP-15 1 1 NO ARC_RMAN
  12. 13 B A A DISK 17-SEP-15 1 1 NO ARC_RMAN

  14. RMAN> crosscheck backup;

  16. Starting implicit crosscheck backup at 18-SEP-15
  17. allocated channel: ORA_DISK_1
  18. channel ORA_DISK_1: SID=1146 device type=DISK
  19. allocated channel: ORA_DISK_2
  20. channel ORA_DISK_2: SID=10 device type=DISK
  21. allocated channel: ORA_DISK_3
  22. channel ORA_DISK_3: SID=1147 device type=DISK
  23. allocated channel: ORA_DISK_4
  24. channel ORA_DISK_4: SID=11 device type=DISK
  25. Crosschecked 5 objects
  26. Finished implicit crosscheck backup at 18-SEP-15

  28. Starting implicit crosscheck copy at 18-SEP-15
  29. using channel ORA_DISK_1
  30. using channel ORA_DISK_2
  31. using channel ORA_DISK_3
  32. using channel ORA_DISK_4
  33. Finished implicit crosscheck copy at 18-SEP-15

  35. searching for all files in the recovery area
  36. cataloging files...
  37. no files cataloged

  39. using channel ORA_DISK_1
  40. using channel ORA_DISK_2
  41. using channel ORA_DISK_3
  42. using channel ORA_DISK_4
  43. crosschecked backup piece: found to be 'EXPIRED'
  44. backup piece handle=+DATA/backup/db_0aqhdno6_1_1 RECID=9 STAMP=890691334
  45. crosschecked backup piece: found to be 'EXPIRED'
  46. backup piece handle=+DATA/backup/db_09qhdno6_1_1 RECID=10 STAMP=890691334
  47. crosschecked backup piece: found to be 'EXPIRED'
  48. backup piece handle=+DATA/backup/ctl_atuo_c-2496627597-20150917-00 RECID=11 STAMP=890691411
  49. crosschecked backup piece: found to be 'EXPIRED'
  50. backup piece handle=+DATA/backup/arc_0dqhdnqq_1_1 RECID=12 STAMP=890691418
  51. crosschecked backup piece: found to be 'EXPIRED'
  52. backup piece handle=+DATA/backup/arc_0cqhdnqq_1_1 RECID=13 STAMP=890691418
  53. Crosschecked 5 objects


  56. RMAN> list backup;


  59. List of Backup Sets
  60. ===================


  63. BS Key Type LV Size Device Type Elapsed Time Completion Time
  64. ------- ---- -- ---------- ----------- ------------ ---------------
  65. 9 Incr 0 433.65M DISK 00:01:10 17-SEP-15
  66.         BP Key: 9 Status: EXPIRED Compressed: NO Tag: DB_RMAN
  67.         Piece Name: +DATA/backup/db_0aqhdno6_1_1
  68.   List of Datafiles in backup set 9
  69.   File LV Type Ckp SCN Ckp Time Name
  70.   ---- -- ---- ---------- --------- ----
  71.   2 0 Incr 1138043 17-SEP-15 +DATA/min/datafile/sysaux.257.854775097
  72.   3 0 Incr 1138043 17-SEP-15 +DATA/min/datafile/undotbs1.258.854775097

  74. BS Key Type LV Size Device Type Elapsed Time Completion Time
  75. ------- ---- -- ---------- ----------- ------------ ---------------
  76. 10 Incr 0 638.84M DISK 00:01:10 17-SEP-15
  77.         BP Key: 10 Status: EXPIRED Compressed: NO Tag: DB_RMAN
  78.         Piece Name: +DATA/backup/db_09qhdno6_1_1
  79.   List of Datafiles in backup set 10
  80.   File LV Type Ckp SCN Ckp Time Name
  81.   ---- -- ---- ---------- --------- ----
  82.   1 0 Incr 1138042 17-SEP-15 +DATA/min/datafile/system.256.854775095
  83.   4 0 Incr 1138042 17-SEP-15 +DATA/min/datafile/users.259.854775097

  85. BS Key Type LV Size Device Type Elapsed Time Completion Time
  86. ------- ---- -- ---------- ----------- ------------ ---------------
  87. 11 Full 9.36M DISK 00:00:01 17-SEP-15
  88.         BP Key: 11 Status: EXPIRED Compressed: NO Tag: TAG20150917T221650
  89.         Piece Name: +DATA/backup/ctl_atuo_c-2496627597-20150917-00
  90.   SPFILE Included: Modification time: 17-SEP-15
  91.   SPFILE db_unique_name: MIN
  92.   Control File Included: Ckp SCN: 1138347 Ckp time: 17-SEP-15

  94. BS Key Size Device Type Elapsed Time Completion Time
  95. ------- ---------- ----------- ------------ ---------------
  96. 12 2.00K DISK 00:00:00 17-SEP-15
  97.         BP Key: 12 Status: EXPIRED Compressed: NO Tag: ARC_RMAN
  98.         Piece Name: +DATA/backup/arc_0dqhdnqq_1_1

  100.   List of Archived Logs in backup set 12
  101.   Thrd Seq Low SCN Low Time Next SCN Next Time
  102.   ---- ------- ---------- --------- ---------- ---------
  103.   1 21 1138364 17-SEP-15 1138372 17-SEP-15

  105. BS Key Size Device Type Elapsed Time Completion Time
  106. ------- ---------- ----------- ------------ ---------------
  107. 13 30.99M DISK 00:00:02 17-SEP-15
  108.         BP Key: 13 Status: EXPIRED Compressed: NO Tag: ARC_RMAN
  109.         Piece Name: +DATA/backup/arc_0cqhdnqq_1_1

  111.   List of Archived Logs in backup set 13
  112.   Thrd Seq Low SCN Low Time Next SCN Next Time
  113.   ---- ------- ---------- --------- ---------- ---------
  114.   1 20 1127220 17-SEP-15 1138364 17-SEP-15

  116. RMAN> list archivelog all;

  118. specification does not match any archived log in the repository


  121. RMAN> report obsolete;

  123. RMAN retention policy will be applied to the command
  124. RMAN retention policy is set to recovery window of 7 days
  125. no obsolete backups found

  127. RMAN> list expired backup;


  130. List of Backup Sets
  131. ===================


  134. BS Key Type LV Size Device Type Elapsed Time Completion Time
  135. ------- ---- -- ---------- ----------- ------------ ---------------
  136. 9 Incr 0 433.65M DISK 00:01:10 17-SEP-15
  137.         BP Key: 9 Status: EXPIRED Compressed: NO Tag: DB_RMAN
  138.         Piece Name: +DATA/backup/db_0aqhdno6_1_1
  139.   List of Datafiles in backup set 9
  140.   File LV Type Ckp SCN Ckp Time Name
  141.   ---- -- ---- ---------- --------- ----
  142.   2 0 Incr 1138043 17-SEP-15 +DATA/min/datafile/sysaux.257.854775097
  143.   3 0 Incr 1138043 17-SEP-15 +DATA/min/datafile/undotbs1.258.854775097

  145. BS Key Type LV Size Device Type Elapsed Time Completion Time
  146. ------- ---- -- ---------- ----------- ------------ ---------------
  147. 10 Incr 0 638.84M DISK 00:01:10 17-SEP-15
  148.         BP Key: 10 Status: EXPIRED Compressed: NO Tag: DB_RMAN
  149.         Piece Name: +DATA/backup/db_09qhdno6_1_1
  150.   List of Datafiles in backup set 10
  151.   File LV Type Ckp SCN Ckp Time Name
  152.   ---- -- ---- ---------- --------- ----
  153.   1 0 Incr 1138042 17-SEP-15 +DATA/min/datafile/system.256.854775095
  154.   4 0 Incr 1138042 17-SEP-15 +DATA/min/datafile/users.259.854775097

  156. BS Key Type LV Size Device Type Elapsed Time Completion Time
  157. ------- ---- -- ---------- ----------- ------------ ---------------
  158. 11 Full 9.36M DISK 00:00:01 17-SEP-15
  159.         BP Key: 11 Status: EXPIRED Compressed: NO Tag: TAG20150917T221650
  160.         Piece Name: +DATA/backup/ctl_atuo_c-2496627597-20150917-00
  161.   SPFILE Included: Modification time: 17-SEP-15
  162.   SPFILE db_unique_name: MIN
  163.   Control File Included: Ckp SCN: 1138347 Ckp time: 17-SEP-15

  165. BS Key Size Device Type Elapsed Time Completion Time
  166. ------- ---------- ----------- ------------ ---------------
  167. 12 2.00K DISK 00:00:00 17-SEP-15
  168.         BP Key: 12 Status: EXPIRED Compressed: NO Tag: ARC_RMAN
  169.         Piece Name: +DATA/backup/arc_0dqhdnqq_1_1

  171.   List of Archived Logs in backup set 12
  172.   Thrd Seq Low SCN Low Time Next SCN Next Time
  173.   ---- ------- ---------- --------- ---------- ---------
  174.   1 21 1138364 17-SEP-15 1138372 17-SEP-15

  176. BS Key Size Device Type Elapsed Time Completion Time
  177. ------- ---------- ----------- ------------ ---------------
  178. 13 30.99M DISK 00:00:02 17-SEP-15
  179.         BP Key: 13 Status: EXPIRED Compressed: NO Tag: ARC_RMAN
  180.         Piece Name: +DATA/backup/arc_0cqhdnqq_1_1

  182.   List of Archived Logs in backup set 13
  183.   Thrd Seq Low SCN Low Time Next SCN Next Time
  184.   ---- ------- ---------- --------- ---------- ---------
  185.   1 20 1127220 17-SEP-15 1138364 17-SEP-15

  187. RMAN> delete noprompt expired backup;

  189. using channel ORA_DISK_1
  190. using channel ORA_DISK_2
  191. using channel ORA_DISK_3
  192. using channel ORA_DISK_4

  194. List of Backup Pieces
  195. BP Key BS Key Pc# Cp# Status Device Type Piece Name
  196. ------- ------- --- --- ----------- ----------- ----------
  197. 9 9 1 1 EXPIRED DISK +DATA/backup/db_0aqhdno6_1_1
  198. 10 10 1 1 EXPIRED DISK +DATA/backup/db_09qhdno6_1_1
  199. 11 11 1 1 EXPIRED DISK +DATA/backup/ctl_atuo_c-2496627597-20150917-00
  200. 12 12 1 1 EXPIRED DISK +DATA/backup/arc_0dqhdnqq_1_1
  201. 13 13 1 1 EXPIRED DISK +DATA/backup/arc_0cqhdnqq_1_1
  202. deleted backup piece
  203. backup piece handle=+DATA/backup/db_0aqhdno6_1_1 RECID=9 STAMP=890691334
  204. deleted backup piece
  205. backup piece handle=+DATA/backup/db_09qhdno6_1_1 RECID=10 STAMP=890691334
  206. deleted backup piece
  207. backup piece handle=+DATA/backup/ctl_atuo_c-2496627597-20150917-00 RECID=11 STAMP=890691411
  208. deleted backup piece
  209. backup piece handle=+DATA/backup/arc_0dqhdnqq_1_1 RECID=12 STAMP=890691418
  210. deleted backup piece
  211. backup piece handle=+DATA/backup/arc_0cqhdnqq_1_1 RECID=13 STAMP=890691418
  212. Deleted 5 EXPIRED objects


  215. RMAN> list backup;

  217. specification does not match any backup in the repository


重新注册备份，并观察控制文件中的备份信息，和数据库结构的信息

点击(此处)折叠或打开

  1. RMAN> catalog start with '/u01/rmanbackup';

  3. searching for all files that match the pattern /u01/rmanbackup

  5. List of Files Unknown to the Database
  6. =====================================
  7. File Name: /u01/rmanbackup/arc1.rman
  8. File Name: /u01/rmanbackup/db1.rman
  9. File Name: /u01/rmanbackup/ctl2.rman
  10. File Name: /u01/rmanbackup/ctl1.rman
  11. File Name: /u01/rmanbackup/db2.rman
  12. File Name: /u01/rmanbackup/arc2.rman

  14. Do you really want to catalog the above files (enter YES or NO)? yes
  15. cataloging files...
  16. cataloging done

  18. List of Cataloged Files
  19. =======================
  20. File Name: /u01/rmanbackup/arc1.rman
  21. File Name: /u01/rmanbackup/db1.rman
  22. File Name: /u01/rmanbackup/ctl2.rman
  23. File Name: /u01/rmanbackup/ctl1.rman
  24. File Name: /u01/rmanbackup/db2.rman
  25. File Name: /u01/rmanbackup/arc2.rman

  27. RMAN> list backup summary;


  30. List of Backups
  31. ===============
  32. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
  33. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
  34. 14 B A A DISK 17-SEP-15 1 1 NO ARC_RMAN
  35. 15 B 0 A DISK 17-SEP-15 1 1 NO DB_RMAN
  36. 16 B 0 A DISK 17-SEP-15 1 1 NO DB_RMAN
  37. 17 B A A DISK 17-SEP-15 1 1 NO ARC_RMAN

--数据文件、临时文件的记录还是源库的信息，一会儿恢复的时候要setnewname

  2. RMAN> report schema;

  4. RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
  5. Report of database schema for database with db_unique_name MIN

  7. List of Permanent Datafiles
  8. ===========================
  9. File Size(MB) Tablespace RB segs Datafile Name
  10. ---- -------- -------------------- ------- ------------------------
  11. 1 0 SYSTEM *** +DATA/min/datafile/system.256.854775095
  12. 2 0 SYSAUX *** +DATA/min/datafile/sysaux.257.854775097
  13. 3 0 UNDOTBS1 *** +DATA/min/datafile/undotbs1.258.854775097
  14. 4 0 USERS *** +DATA/min/datafile/users.259.854775097

  16. List of Temporary Files
  17. =======================
  18. File Size(MB) Tablespace Maxsize(MB) Tempfile Name
  19. ---- -------- -------------------- ----------- --------------------
  20. 1 20 TEMP 32767 +DATA/min/tempfile/temp.268.854775211



--你会发现这是老的控制文件，是我们0级备份里的，其中关于redo的状态记录，当前redo还停留在序列号22


  3. SQL> select GROUP#,SEQUENCE# ,STATUS,ARCHIVED from v$log;

  5.     GROUP# SEQUENCE# STATUS ARC
  6. ---------- ---------- ---------------- ---
  7.          1 22 CURRENT NO
  8.          3 21 ACTIVE YES
  9.          2 20 ACTIVE YES

  11. SQL> desc v$logfile;
  12.  Name Null? Type
  13.  ----------------------------------------- -------- ----------------------------
  14.  GROUP# NUMBER
  15.  STATUS VARCHAR2(7)
  16.  TYPE VARCHAR2(7)
  17.  MEMBER VARCHAR2(513)
  18.  IS_RECOVERY_DEST_FILE VARCHAR2(3)

--redo的记录还是源库的信息，一会儿恢复的时候要setnewname

  2. SQL> col member for a80
  3. SQL> set line 200
  4. SQL> select GROUP#,STATUS,MEMBER from v$logfile;

  6.     GROUP# STATUS MEMBER
  7. ---------- ------- --------------------------------------------------------------------------------
  8.          3 +DATA/min/onlinelog/group_3.266.854775193
  9.          3 +DATA/min/onlinelog/group_3.267.854775195
  10.          2 +DATA/min/onlinelog/group_2.264.854775189
  11.          2 +DATA/min/onlinelog/group_2.265.854775191
  12.          1 +DATA/min/onlinelog/group_1.262.854775185
  13.          1 +DATA/min/onlinelog/group_1.263.854775187

  15. 6 rows selected.


     还原数据库

点击(此处)折叠或打开

  1. RMAN> RUN
  2. 2> {
  3. 3> ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
  4. 4> ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
  5. 5> set archivelog destination to "/u01/app/oracle/archived_log";
  6. 6> set newname for datafile 1 to "/u01/app/oracle/oradata/min/system01.dbf";
  7. 7> set newname for datafile 2 to "/u01/app/oracle/oradata/min/sysaux01.dbf";
  8. 8> set newname for datafile 3 to "/u01/app/oracle/oradata/min/undotbs01.dbf";
  9. 9> set newname for datafile 4 to "/u01/app/oracle/oradata/min/users01.dbf";
  10. 10> set newname for tempfile 1 to "/u01/app/oracle/oradata/min/temp01.dbf";
  11. 11> SQL "ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_1.262.854775185'' to ''/u01/app/oracle/oradata/min/redo1a.log'' ";
  12. 12> SQL "ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_1.263.854775187'' to ''/u01/app/oracle/oradata/min/redo1b.log'' ";
  13. 13> SQL "ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_2.264.854775189'' to ''/u01/app/oracle/oradata/min/redo2a.log'' ";
  14. 14> SQL "ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_2.265.854775191'' to ''/u01/app/oracle/oradata/min/redo2b.log'' ";
  15. 15> SQL "ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_3.266.854775193'' to ''/u01/app/oracle/oradata/min/redo3a.log'' ";
  16. 16> SQL "ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_3.267.854775195'' to ''/u01/app/oracle/oradata/min/redo3b.log'' ";
  17. 17> RESTORE DATABASE;
  18. 18> SWITCH DATAFILE ALL;
  19. 19> switch tempfile all;
  20. 20> }
  22. released channel: ORA_DISK_1
  23. released channel: ORA_DISK_2
  24. released channel: ORA_DISK_3
  25. released channel: ORA_DISK_4
  26. allocated channel: c1
  27. channel c1: SID=1146 device type=DISK
  29. allocated channel: c2
  30. channel c2: SID=11 device type=DISK
  32. executing command: SET ARCHIVELOG DESTINATION
  34. executing command: SET NEWNAME
  36. executing command: SET NEWNAME
  38. executing command: SET NEWNAME
  40. executing command: SET NEWNAME
  42. executing command: SET NEWNAME
  44. sql statement: ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_1.262.854775185'' to ''/u01/app/oracle/oradata/min/redo1a.log''
  46. sql statement: ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_1.263.854775187'' to ''/u01/app/oracle/oradata/min/redo1b.log''
  48. sql statement: ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_2.264.854775189'' to ''/u01/app/oracle/oradata/min/redo2a.log''
  50. sql statement: ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_2.265.854775191'' to ''/u01/app/oracle/oradata/min/redo2b.log''
  52. sql statement: ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_3.266.854775193'' to ''/u01/app/oracle/oradata/min/redo3a.log''
  54. sql statement: ALTER DATABASE RENAME FILE ''+DATA/min/onlinelog/group_3.267.854775195'' to ''/u01/app/oracle/oradata/min/redo3b.log''
  56. Starting restore at 18-SEP-15
  58. skipping datafile 2; already restored to file /u01/app/oracle/oradata/min/sysaux01.dbf
  59. channel c1: starting datafile backup set restore
  60. channel c1: specifying datafile(s) to restore from backup set
  61. channel c1: restoring datafile 00001 to /u01/app/oracle/oradata/min/system01.dbf
  62. channel c1: restoring datafile 00004 to /u01/app/oracle/oradata/min/users01.dbf
  63. channel c1: reading from backup piece /u01/rmanbackup/db2.rman
  64. channel c2: starting datafile backup set restore
  65. channel c2: specifying datafile(s) to restore from backup set
  66. channel c2: restoring datafile 00003 to /u01/app/oracle/oradata/min/undotbs01.dbf
  67. channel c2: reading from backup piece /u01/rmanbackup/db1.rman
  68. channel c2: piece handle=/u01/rmanbackup/db1.rman tag=DB_RMAN
  69. channel c2: restored backup piece 1
  70. channel c2: restore complete, elapsed time: 00:00:08
  71. channel c1: piece handle=/u01/rmanbackup/db2.rman tag=DB_RMAN
  72. channel c1: restored backup piece 1
  73. channel c1: restore complete, elapsed time: 00:00:36
  74. Finished restore at 18-SEP-15
  76. datafile 1 switched to datafile copy
  77. input datafile copy RECID=5 STAMP=890701322 file name=/u01/app/oracle/oradata/min/system01.dbf
  78. datafile 2 switched to datafile copy
  79. input datafile copy RECID=6 STAMP=890701322 file name=/u01/app/oracle/oradata/min/sysaux01.dbf
  80. datafile 3 switched to datafile copy
  81. input datafile copy RECID=7 STAMP=890701322 file name=/u01/app/oracle/oradata/min/undotbs01.dbf
  82. datafile 4 switched to datafile copy
  83. input datafile copy RECID=8 STAMP=890701322 file name=/u01/app/oracle/oradata/min/users01.dbf
  85. renamed tempfile 1 to /u01/app/oracle/oradata/min/temp01.dbf in control file
  86. released channel: c1
  87. released channel: c2


    restore完毕，我们再来看一下控制文件中的信息

点击(此处)折叠或打开

  1. RMAN> report schema;
  3. RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
  4. Report of database schema for database with db_unique_name MIN
  6. List of Permanent Datafiles
  7. ===========================
  8. File Size(MB) Tablespace RB segs Datafile Name
  9. ---- -------- -------------------- ------- ------------------------
  10. 1 750 SYSTEM *** /u01/app/oracle/oradata/min/system01.dbf
  11. 2 560 SYSAUX *** /u01/app/oracle/oradata/min/sysaux01.dbf
  12. 3 100 UNDOTBS1 *** /u01/app/oracle/oradata/min/undotbs01.dbf
  13. 4 5 USERS *** /u01/app/oracle/oradata/min/users01.dbf
  15. List of Temporary Files
  16. =======================
  17. File Size(MB) Tablespace Maxsize(MB) Tempfile Name
  18. ---- -------- -------------------- ----------- --------------------
  19. 1 20 TEMP 32767 /u01/app/oracle/oradata/min/temp01.dbf


    完全恢复数据库

点击(此处)折叠或打开

  1. RMAN> recover database;
  3. Starting recover at 18-SEP-15
  4. allocated channel: ORA_DISK_1
  5. channel ORA_DISK_1: SID=1146 device type=DISK
  6. allocated channel: ORA_DISK_2
  7. channel ORA_DISK_2: SID=11 device type=DISK
  8. allocated channel: ORA_DISK_3
  9. channel ORA_DISK_3: SID=1137 device type=DISK
  10. allocated channel: ORA_DISK_4
  11. channel ORA_DISK_4: SID=10 device type=DISK
  13. starting media recovery
  15. archived log for thread 1 with sequence 38 is already on disk as file /u01/app/oracle/oradata/min/redo2a.log
  16. archived log for thread 1 with sequence 39 is already on disk as file /u01/app/oracle/oradata/min/redo3a.log
  17. archived log for thread 1 with sequence 40 is already on disk as file /u01/app/oracle/oradata/min/redo1a.log
  18. channel ORA_DISK_1: starting archived log restore to default destination
  19. channel ORA_DISK_1: restoring archived log
  20. archived log thread=1 sequence=20
  21. channel ORA_DISK_1: reading from backup piece /u01/rmanbackup/arc2.rman
  22. channel ORA_DISK_2: starting archived log restore to default destination
  23. channel ORA_DISK_2: restoring archived log
  24. archived log thread=1 sequence=21
  25. channel ORA_DISK_2: reading from backup piece /u01/rmanbackup/arc1.rman
  26. channel ORA_DISK_2: piece handle=/u01/rmanbackup/arc1.rman tag=ARC_RMAN
  27. channel ORA_DISK_2: restored backup piece 1
  28. channel ORA_DISK_2: restore complete, elapsed time: 00:00:01
  29. channel ORA_DISK_1: piece handle=/u01/rmanbackup/arc2.rman tag=ARC_RMAN
  30. channel ORA_DISK_1: restored backup piece 1
  31. channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
  32. archived log file name=/u01/app/oracle/archived_log/1_20_854775184.dbf thread=1 sequence=20
  33. archived log file name=/u01/app/oracle/archived_log/1_21_854775184.dbf thread=1 sequence=21
  34. archived log file name=/u01/app/oracle/archived_log/1_22_854775184.dbf thread=1 sequence=22
  35. archived log file name=/u01/app/oracle/archived_log/1_23_854775184.dbf thread=1 sequence=23
  36. archived log file name=/u01/app/oracle/archived_log/1_24_854775184.dbf thread=1 sequence=24
  37. archived log file name=/u01/app/oracle/archived_log/1_25_854775184.dbf thread=1 sequence=25
  38. archived log file name=/u01/app/oracle/archived_log/1_26_854775184.dbf thread=1 sequence=26
  39. archived log file name=/u01/app/oracle/archived_log/1_27_854775184.dbf thread=1 sequence=27
  40. archived log file name=/u01/app/oracle/archived_log/1_28_854775184.dbf thread=1 sequence=28
  41. archived log file name=/u01/app/oracle/archived_log/1_29_854775184.dbf thread=1 sequence=29
  42. archived log file name=/u01/app/oracle/archived_log/1_30_854775184.dbf thread=1 sequence=30
  43. archived log file name=/u01/app/oracle/archived_log/1_31_854775184.dbf thread=1 sequence=31
  44. archived log file name=/u01/app/oracle/archived_log/1_32_854775184.dbf thread=1 sequence=32
  45. archived log file name=/u01/app/oracle/archived_log/1_33_854775184.dbf thread=1 sequence=33
  46. archived log file name=/u01/app/oracle/archived_log/1_34_854775184.dbf thread=1 sequence=34
  47. archived log file name=/u01/app/oracle/archived_log/1_35_854775184.dbf thread=1 sequence=35
  48. archived log file name=/u01/app/oracle/archived_log/1_36_854775184.dbf thread=1 sequence=36
  49. archived log file name=/u01/app/oracle/archived_log/1_37_854775184.dbf thread=1 sequence=37
  50. archived log file name=/u01/app/oracle/oradata/min/redo2a.log thread=1 sequence=38
  51. archived log file name=/u01/app/oracle/oradata/min/redo3a.log thread=1 sequence=39
  52. archived log file name=/u01/app/oracle/oradata/min/redo1a.log thread=1 sequence=40
  53. media recovery complete, elapsed time: 00:00:43
  54. Finished recover at 18-SEP-15

    从恢复的日志可以看出，oracle会绕过38、39号的归档直接利用在线日志做恢复，oracle的聪明之处可见一斑！
    试着正常方式打开数据库，会发现报错：

点击(此处)折叠或打开

  1. RMAN> alter database open;
  3. RMAN-00571: ===========================================================
  4. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  5. RMAN-00571: ===========================================================
  6. RMAN-03002: failure of alter db command at 09/18/2015 01:04:41
  7. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

      --看一下此时控制文件中的日志序列号，会发现没有前推，必须用resetlogs打开数据库

      SQL>  select group#,status,sequence# from v$log;


      GROUP# STATUS            SEQUENCE#
    ---------- ---------------- ----------
         1 CURRENT                  22
         3 ACTIVE                   21
         2 ACTIVE                   20
  2. RMAN> alter database open resetlogs;
  4. database opened


    使用resetlog的原因是recover命令只能修复控制文件中数据物理结构信息，而无法修改控制文件中的当前重做日志的序列号的信息，recover命令结束后，控制文件中的当前日志序列号还是陈旧的，若按常规方式打开数据库，将报错，为了抹去控制文件这个固执的念头，oracle采用重设日志的功能，日志序列号从1开始。此处虽然使用了resetlogs，但是因为“recover database”命令执行成功，所有提交的事务不会丢失，resetlogs仅仅是为了照顾还原的控制文件，与不完全恢复的resetlogs是不同的，至此恢复结束。

点击(此处)折叠或打开

  1. SQL> conn test/test
  3. Connected.
  4. SQL> select count(1) from t;
  6. COUNT(1)
  7. ----------
  8. 3000000



阅读(343) | 评论(0) | 转发(0) |
1

上一篇：没有了

下一篇：没有了

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6