创建辅助oracle数据库,dg实验之duplicate创建辅助数据库

最新推荐文章于 2022-01-26 15:33:00 发布
最新推荐文章于 2022-01-26 15:33:00 发布
阅读量661 收藏
点赞数
文章标签： 创建辅助oracle数据库

实验环境：

系统环境：redhat-as4.7

oracle:   oracle10.2.0.4

主数据库：

ip地址：192.168.1.220

主机名称：db-primary

实例名称：lizidb

数据库名称：lizidb

oracle软件目录：/opt/oracle/product/10.2.0

数据库数据文件目录：/u00/oracle/lizidb

rman备份目录：/u00/dbbackup

辅助数据库：

ip地址：192.168.1.221

主机名称：db-standby

实例名称：standbydb

数据库名称：sbydb

oracle软件目录：/opt/oracle/product/10.2.0

数据库数据文件目录：/u00/oracle/standbydb

rman备份目录：/u00/dbbackup

本实验采取rman备份目录采取nfs共享目录模式，共享主机为192.168.1.241，目录为/u03/share，在主辅库服务器中分别挂载这个共享目录到/u00/dbbackup，命令为：mount -t nfs 192.168.1.241:/u03/share /u00/dbbackup

实验步骤：

第一步、创建辅助实例

1、创建密码文件

[oracle@db-standby dbs]$ pwd

/opt/oracle/product/10.2.0/dbs

[oracle@db-standby dbs]$ orapwd file=/opt/oracle/product/10.2.0/dbs/orapwstandbydb password=aaa entries=30[oracle@db-standby dbs]$ ls

alert_standbydb.log  hc_standbydb.dat  initdw.ora      spfilelizidb.ora.bak

hc_lizidb.dat        init.ora          orapwstandbydb  spfilestandbydb.ora

这一步中第一次由于创建密码文件的格式及位置错误：

orapwd file=/u00/oracle/standbydb/pwdstandby.ora password=aaa entries=30

导致了用rman连接辅助实例时出现ORA-01031: insufficient privileges错误，之后按照创建密码文件的要求重新创建，没有出现问题。详见：http://blog.chinaunix.net/u2/65284/showart.php?id=2216378

2、手动创建初始化参数文件及各个相应的目录

创建参数目录：

[oracle@db-standby oracle]$ cd admin/

[oracle@db-standby admin]$ ls

[oracle@db-standby admin]$ mkdir standbydb

[oracle@db-standby admin]$ ls

standbydb

[oracle@db-standby admin]$ cd standbydb/

[oracle@db-standby standbydb]$ ls

[oracle@db-standby standbydb]$ mkdir adump

[oracle@db-standby standbydb]$ mkdir bdump

[oracle@db-standby standbydb]$ mkdir cdump

[oracle@db-standby standbydb]$ mkdir dpdump

[oracle@db-standby standbydb]$ mkdir udump

[oracle@db-standby standbydb]$ mkdir pfile

[oracle@db-standby standbydb]$

创建数据文件目录：

[oracle@db-standby oracle]$ mkdir standbydb

[oracle@db-standby oracle]$ cd standbydb

[oracle@db-standby standbydb]$ pwd

/u00/oracle/standbydb

将主数据库初始化参数文件远程拷贝到辅助数据库目录的pfile目录中进行修改，如下:

主数据库初始化参数文件：

[root@db-primary pfile]# cat init.ora.1222010164651

##############################################################################

# Copyright (c) 1991, 2001, 2002 by Oracle Corporation

##############################################################################

###########################################

# Archive

###########################################

log_archive_dest_1='LOCATION=/u00/arch'

log_archive_format=%t_%s_%r.dbf

###########################################

# Cache and I/O

###########################################

db_block_size=8192

db_file_multiblock_read_count=16

###########################################

# Cursors and Library Cache

###########################################

open_cursors=300

###########################################

# Database Identification

###########################################

db_domain=""

db_name=lizidb

###########################################

# Diagnostics and Statistics

###########################################

background_dump_dest=/opt/oracle/admin/lizidb/bdump

core_dump_dest=/opt/oracle/admin/lizidb/cdump

user_dump_dest=/opt/oracle/admin/lizidb/udump

###########################################

# File Configuration

###########################################

control_files=("/u00/oracle/lizidb/control01.ctl", "/u00/oracle/lizidb/control02.ctl", "/u00/oracle/lizidb/control03.ctl")

db_recovery_file_dest=/u00/flash

db_recovery_file_dest_size=2147483648

###########################################

# Job Queues

###########################################

job_queue_processes=10

###########################################

# Miscellaneous

###########################################

compatible=10.2.0.3.0

###########################################

# NLS

###########################################

nls_language="SIMPLIFIED CHINESE"

nls_territory="CHINA"

###########################################

# Processes and Sessions

###########################################

processes=150

sessions=170

###########################################

# SGA Memory

###########################################

sga_target=1073741824

###########################################

# Security and Auditing

###########################################

audit_file_dest=/opt/oracle/admin/lizidb/adump

remote_login_passwordfile=EXCLUSIVE

###########################################

# Shared Server

###########################################

dispatchers="(PROTOCOL=TCP) (SERVICE=lizidbXDB)"

###########################################

# Sort, Hash Joins, Bitmap Indexes

###########################################

pga_aggregate_target=357564416

###########################################

# System Managed Undo and Rollback Segments

###########################################

undo_management=AUTO

undo_tablespace=UNDOTBS1

辅助数据库初始化参数文件：

[root@db-standby pfile]# cat init.ora.standbydb

##############################################################################

# Copyright (c) 1991, 2001, 2002 by Oracle Corporation

##############################################################################

###########################################

# Archive

###########################################

log_archive_dest_1='LOCATION=/u00/arch'

log_archive_format=%t_%s_%r.dbf

###########################################

# Cache and I/O

###########################################

db_block_size=8192

db_file_multiblock_read_count=16

###########################################

# Cursors and Library Cache

###########################################

open_cursors=300

###########################################

# Database Identification

###########################################

db_domain=""

db_name=sbydb

###########################################

# Diagnostics and Statistics

###########################################

background_dump_dest=/opt/oracle/admin/standbydb/bdump

core_dump_dest=/opt/oracle/admin/standbydb/cdump

user_dump_dest=/opt/oracle/admin/standbydb/udump

###########################################

# File Configuration

###########################################

control_files=("/u00/oracle/standbydb/control01.ctl", "/u00/oracle/standbydb/control02.ctl", "/u00/oracle/standbydb/control03.ctl")

db_recovery_file_dest=/u00/flash

db_recovery_file_dest_size=2147483648

db_file_name_convert=('/u00/oracle/lizidb','/u00/oracle/standbydb')

log_file_name_convert=('/u00/oracle/lizidb','/u00/oracle/standbydb')

###########################################

# Job Queues

###########################################

job_queue_processes=10

###########################################

# Miscellaneous

###########################################

compatible=10.2.0.3.0

###########################################

# NLS

###########################################

nls_language="SIMPLIFIED CHINESE"

nls_territory="CHINA"

###########################################

# Processes and Sessions

###########################################

processes=150

sessions=170

###########################################

# SGA Memory

###########################################

sga_target=1073741824

###########################################

# Security and Auditing

###########################################

audit_file_dest=/opt/oracle/admin/standbydb/adumpremote_login_passwordfile=EXCLUSIVE

###########################################

# Shared Server

###########################################

dispatchers="(PROTOCOL=TCP) (SERVICE=standbydbXDB)"

###########################################

# Sort, Hash Joins, Bitmap Indexes

###########################################

pga_aggregate_target=357564416

###########################################

# System Managed Undo and Rollback Segments

###########################################

undo_management=AUTO

undo_tablespace=UNDOTBS1

蓝色标记的为需要修改的地方。

3、在辅助数据库中启动空实例以pfile创建spfile，然后启动到nomount状态：

[oracle@db-standby pfile]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 16 15:51:30 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> create spfile from pfile='/opt/oracle/admin/standbydb/pfile/init.ora.standbydb';

File created.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size                  2089400 bytes

Variable Size             264244808 bytes

Database Buffers          801112064 bytes

Redo Buffers                6295552 bytes

SQL>

这一步中遇到了两个问题：

(1)、第一次修改初始化参数文件时候，将db_name设置为db_name=standbydb,启动辅助实例时候报错：

SQL> startup nomount

ORA-01127: database name 'standbydb' exceeds size limit of 8 characters

这是因为oracle自9i以来db_name不允许超过8个字符，将其改为db_name=sbydb,问题解决。

(2)、开始时候设置db_file_name_convert、log_file_name_convert为：

db_file_name_convert=('/u00/oracle/lizidb')

log_file_name_convert=('/u00/oracle/lizidb')

或者：

db_file_name_convert=('/u00/dbbackup','/u00/dbbackup')

log_file_name_convert=('/u00/dbbackup','/u00/dbbackup')

这样，在用rman进行duplicate时候均报错：

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

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

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

RMAN-03002: failure of Duplicate Db command at 04/19/2010 16:40:08

RMAN-05501: aborting duplication of target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/lizi.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/zlktest.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/wkyj.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/web.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/toto.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/rman.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/newdb.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/example01.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/users01.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/sysaux01.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/undotbs01.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/system01.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/redo03.log conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/redo02.log conflicts with a file used by the target database

RMAN-05001: auxiliary filename /u00/oracle/lizidb/redo01.log conflicts with a file used by the target database

这两个参数含义大概为复制前后的数据文件路径，因次必须严格设置为主数据库和辅助数据库的数据文件路径目录：

db_file_name_convert=('/u00/oracle/lizidb','/u00/oracle/standbydb')

log_file_name_convert=('/u00/oracle/lizidb','/u00/oracle/standbydb')

问题解决。

第二步、rman备份主数据库

[oracle@db-standby ~]$ rman target

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Apr 19 12:00:17 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: LIZIDB (DBID=3331456942)

RMAN> run  {

2>  CONFIGURE CONTROLFILE AUTOBACKUP ON;

3>  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u00/dbbackup/%F';

4>  ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/u00/dbbackup/%U';

5>  BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10 PLUS ARCHIVELOG FILESPERSET 20

6>  DELETE ALL INPUT;

7>  RELEASE CHANNEL CH1;

8>  }

using target database control file instead of recovery catalog

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u00/dbbackup/%F';

new RMAN configuration parameters are successfully stored

allocated channel: CH1

channel CH1: sid=135 devtype=DISK

Starting backup at 2010-04-19 12:00:54

current log archived

released channel: CH1

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

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

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

RMAN-03002: failure of backup plus archivelog command at 04/19/2010 12:00:57

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

ORA-19625: error identifying file /u00/arch/1_1_711650606.dbf

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

RMAN>

RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=135 devtype=DISK

validation failed for archived log

archive log filename=/u00/arch/1_1_711650606.dbf recid=1 stamp=712638065

validation failed for archived log

archive log filename=/u00/arch/1_2_711650606.dbf recid=3 stamp=713187749

validation succeeded for archived log

archive log filename=/u00/arch/1_3_711650606.dbf recid=2 stamp=713187746

validation succeeded for archived log

archive log filename=/u00/arch/1_4_711650606.dbf recid=4 stamp=713187750

validation succeeded for archived log

archive log filename=/u00/arch/1_5_711650606.dbf recid=5 stamp=713188490

validation succeeded for archived log

archive log filename=/u00/arch/1_8_711650606.dbf recid=6 stamp=713197579

validation succeeded for archived log

archive log filename=/u00/arch/1_9_711650606.dbf recid=7 stamp=713264687

validation failed for archived log

archive log filename=/u00/arch/1_10_711650606.dbf recid=8 stamp=713269590

validation failed for archived log

archive log filename=/u00/arch/1_11_711650606.dbf recid=9 stamp=713270562

validation failed for archived log

archive log filename=/u00/arch/1_12_711650606.dbf recid=10 stamp=713271533

validation failed for archived log

archive log filename=/u00/arch/1_13_711650606.dbf recid=11 stamp=713876115

validation failed for archived log

archive log filename=/u00/arch/1_14_711650606.dbf recid=12 stamp=713981122

validation failed for archived log

archive log filename=/u00/arch/1_15_711650606.dbf recid=13 stamp=715012089

validation failed for archived log

archive log filename=/u00/arch/1_16_711650606.dbf recid=14 stamp=715076804

validation failed for archived log

archive log filename=/u00/arch/1_17_711650606.dbf recid=15 stamp=715088213

validation failed for archived log

archive log filename=/u00/arch/1_18_711650606.dbf recid=16 stamp=715088365

validation failed for archived log

archive log filename=/u00/arch/1_19_711650606.dbf recid=17 stamp=715088549

validation failed for archived log

archive log filename=/u00/arch/1_20_711650606.dbf recid=18 stamp=715088708

validation failed for archived log

archive log filename=/u00/arch/1_21_711650606.dbf recid=19 stamp=715604776

validation failed for archived log

archive log filename=/u00/arch/1_22_711650606.dbf recid=20 stamp=715604784

validation failed for archived log

archive log filename=/u00/arch/1_23_711650606.dbf recid=21 stamp=715692901

validation failed for archived log

archive log filename=/u00/arch/1_24_711650606.dbf recid=22 stamp=715796231

validation failed for archived log

archive log filename=/u00/arch/1_25_711650606.dbf recid=23 stamp=716315449

validation failed for archived log

archive log filename=/u00/arch/1_26_711650606.dbf recid=24 stamp=716407012

validation failed for archived log

archive log filename=/u00/arch/1_27_711650606.dbf recid=25 stamp=716488162

validation failed for archived log

archive log filename=/u00/arch/1_28_711650606.dbf recid=26 stamp=716587412

validation succeeded for archived log

archive log filename=/u00/arch/1_29_711650606.dbf recid=27 stamp=716731536

Crosschecked 27 objects

RMAN> run

2>  {

3>  CONFIGURE CONTROLFILE AUTOBACKUP ON;

4>  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u00/dbbackup/%F';

5>  ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/u00/dbbackup/%U';

6>  BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10 PLUS ARCHIVELOG FILESPERSET 20

7>  DELETE ALL INPUT;

8>  RELEASE CHANNEL CH1;

9>  }

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u00/dbbackup/%F';

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u00/dbbackup/%F';

new RMAN configuration parameters are successfully stored

released channel: ORA_DISK_1

allocated channel: CH1

channel CH1: sid=135 devtype=DISK

Starting backup at 2010-04-19 12:56:42

current log archived

channel CH1: starting archive log backupset

channel CH1: specifying archive log(s) in backup set

input archive log thread=1 sequence=3 recid=2 stamp=713187746

input archive log thread=1 sequence=4 recid=4 stamp=713187750

input archive log thread=1 sequence=5 recid=5 stamp=713188490

input archive log thread=1 sequence=8 recid=6 stamp=713197579

input archive log thread=1 sequence=9 recid=7 stamp=713264687

input archive log thread=1 sequence=29 recid=27 stamp=716731536

input archive log thread=1 sequence=30 recid=28 stamp=716734888

channel CH1: starting piece 1 at 2010-04-19 13:01:30

channel CH1: finished piece 1 at 2010-04-19 13:03:04

piece handle=/u00/dbbackup/01lbh0d9_1_1 tag=TAG20100419T130129 comment=NONE

channel CH1: backup set complete, elapsed time: 00:01:35

channel CH1: deleting archive log(s)

archive log filename=/u00/arch/1_3_711650606.dbf recid=2 stamp=713187746

archive log filename=/u00/arch/1_4_711650606.dbf recid=4 stamp=713187750

archive log filename=/u00/arch/1_5_711650606.dbf recid=5 stamp=713188490

archive log filename=/u00/arch/1_8_711650606.dbf recid=6 stamp=713197579

archive log filename=/u00/arch/1_9_711650606.dbf recid=7 stamp=713264687

archive log filename=/u00/arch/1_29_711650606.dbf recid=27 stamp=716731536

archive log filename=/u00/arch/1_30_711650606.dbf recid=28 stamp=716734888

Finished backup at 2010-04-19 12:58:19

Starting backup at 2010-04-19 12:58:19

channel CH1: starting full datafile backupset

channel CH1: specifying datafile(s) in backupset

input datafile fno=00004 name=/u00/oracle/lizidb/users01.dbf

input datafile fno=00010 name=/u00/oracle/lizidb/wkyj.dbf

input datafile fno=00012 name=/u00/oracle/lizidb/lizi.dbf

input datafile fno=00001 name=/u00/oracle/lizidb/system01.dbf

input datafile fno=00003 name=/u00/oracle/lizidb/sysaux01.dbf

channel CH1: starting piece 1 at 2010-04-19 13:03:05

channel CH1: finished piece 1 at 2010-04-19 13:09:19

piece handle=/u00/dbbackup/02lbh0g9_1_1 tag=TAG20100419T130305 comment=NONE

channel CH1: backup set complete, elapsed time: 00:06:14

channel CH1: starting full datafile backupset

channel CH1: specifying datafile(s) in backupset

input datafile fno=00006 name=/u00/oracle/lizidb/newdb.dbf

input datafile fno=00008 name=/u00/oracle/lizidb/toto.dbf

input datafile fno=00009 name=/u00/oracle/lizidb/web.dbf

input datafile fno=00011 name=/u00/oracle/lizidb/zlktest.dbf

input datafile fno=00002 name=/u00/oracle/lizidb/undotbs01.dbf

input datafile fno=00005 name=/u00/oracle/lizidb/example01.dbf

input datafile fno=00007 name=/u00/oracle/lizidb/rman.dbf

channel CH1: starting piece 1 at 2010-04-19 13:09:19

channel CH1: finished piece 1 at 2010-04-19 13:09:34

piece handle=/u00/dbbackup/03lbh0rv_1_1 tag=TAG20100419T130305 comment=NONE

channel CH1: backup set complete, elapsed time: 00:00:15

Finished backup at 2010-04-19 13:04:50

Starting backup at 2010-04-19 13:04:50

current log archived

channel CH1: starting archive log backupset

channel CH1: specifying archive log(s) in backup set

input archive log thread=1 sequence=31 recid=29 stamp=716735374

channel CH1: starting piece 1 at 2010-04-19 13:09:35

channel CH1: finished piece 1 at 2010-04-19 13:09:36

piece handle=/u00/dbbackup/04lbh0se_1_1 tag=TAG20100419T130934 comment=NONE

channel CH1: backup set complete, elapsed time: 00:00:02

channel CH1: deleting archive log(s)

archive log filename=/u00/arch/1_31_711650606.dbf recid=29 stamp=716735374

Finished backup at 2010-04-19 13:04:52

Starting Control File and SPFILE Autobackup at 2010-04-19 13:04:52

piece handle=/u00/dbbackup/c-3331456942-20100419-00 comment=NONE

Finished Control File and SPFILE Autobackup at 2010-04-19 13:04:55

released channel: CH1

RMAN> list backup2> ;

List of Backup Sets

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

BS Key  Size       Device Type Elapsed Time Completion Time

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

1       542.66M    DISK        00:01:33     2010-04-19 13:03:02

BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20100419T130129

Piece Name: /u00/dbbackup/01lbh0d9_1_1

List of Archived Logs in backup set 1

Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

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

1    3       1143464    2010-03-09 11:32:12 1163468    2010-03-09 11:33:14

1    4       1163468    2010-03-09 11:33:14 1183472    2010-03-09 11:42:29

1    5       1183472    2010-03-09 11:42:29 1184287    2010-03-09 11:54:50

1    8       1511959    2010-03-09 12:13:31 1609405    2010-03-09 14:25:13

1    9       1609405    2010-03-09 14:25:13 1635624    2010-03-10 09:04:43

1    29      65100733   2010-04-17 20:03:13 65178537   2010-04-19 12:05:34

1    30      65178537   2010-04-19 12:05:34 65180410   2010-04-19 13:01:28

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

2       Full    2.68G      DISK        00:06:06     2010-04-19 13:09:11

BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20100419T130305

Piece Name: /u00/dbbackup/02lbh0g9_1_1

List of Datafiles in backup set 2

File LV Type Ckp SCN    Ckp Time            Name

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

1       Full 65180488   2010-04-19 13:03:05 /u00/oracle/lizidb/system01.dbf

3       Full 65180488   2010-04-19 13:03:05 /u00/oracle/lizidb/sysaux01.dbf

4       Full 65180488   2010-04-19 13:03:05 /u00/oracle/lizidb/users01.dbf

10      Full 65180488   2010-04-19 13:03:05 /u00/oracle/lizidb/wkyj.dbf

12      Full 65180488   2010-04-19 13:03:05 /u00/oracle/lizidb/lizi.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

3       Full    73.27M     DISK        00:00:09     2010-04-19 13:09:28

BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20100419T130305

Piece Name: /u00/dbbackup/03lbh0rv_1_1

List of Datafiles in backup set 3

File LV Type Ckp SCN    Ckp Time            Name

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

2       Full 65180642   2010-04-19 13:09:19 /u00/oracle/lizidb/undotbs01.dbf

5       Full 65180642   2010-04-19 13:09:19 /u00/oracle/lizidb/example01.dbf

6       Full 65180642   2010-04-19 13:09:19 /u00/oracle/lizidb/newdb.dbf

7       Full 65180642   2010-04-19 13:09:19 /u00/oracle/lizidb/rman.dbf

8       Full 65180642   2010-04-19 13:09:19 /u00/oracle/lizidb/toto.dbf

9       Full 65180642   2010-04-19 13:09:19 /u00/oracle/lizidb/web.dbf

11      Full 65180642   2010-04-19 13:09:19 /u00/oracle/lizidb/zlktest.dbf

BS Key  Size       Device Type Elapsed Time Completion Time

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

4       107.00K    DISK        00:00:02     2010-04-19 13:09:36

BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20100419T130934

Piece Name: /u00/dbbackup/04lbh0se_1_1

List of Archived Logs in backup set 4

Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

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

1    31      65180410   2010-04-19 13:01:28 65180650   2010-04-19 13:09:34

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

5       Full    6.80M      DISK        00:00:01     2010-04-19 13:09:38

BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20100419T130937

Piece Name: /u00/dbbackup/c-3331456942-20100419-00

Control File Included: Ckp SCN: 65180656     Ckp time: 2010-04-19 13:09:37

SPFILE Included: Modification time: 2010-04-19 09:31:36

RMAN>

RMAN> exit

如以上红色标记所示，在这过程中出现了一些列的错误：

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

ORA-19625: error identifying file /u00/arch/1_1_711650606.dbf

ORA-27037: unable to obtain file status

这是因为我把archive日至文件删除了一部分，导致archive日至文件与当前的数据库系统中对应的记录号不一致，解决方法只需要同步一下即可，执行命令：RMAN> crosscheck archivelog all;

第三步、进行数据库平移

进行数据库平移只需要执行一条duplicate命令，但是，准备条件一定要检查再检查，参照三思的笔记，否则有一处准备工作做不好的话就会出错。

[oracle@db-standby ~]$ rman target auxiliary

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Apr 19 15:56:36 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: LIZIDB (DBID=3331456942)

connected to auxiliary database: SBYDB (not mounted)

RMAN>

RMAN>run

2>  {

3>  ALLOCATE CHANNEL CH1 DEVICE TYPE DISK;

4>  ALLOCATE CHANNEL CH2 DEVICE TYPE DISK;

5>  ALLOCATE CHANNEL CH3 DEVICE TYPE DISK;

6>  duplicate target database to sbydb;

7>  }

using target database control file instead of recovery catalog

allocated channel: CH1

channel CH1: sid=138 devtype=DISK

allocated channel: CH2

channel CH2: sid=131 devtype=DISK

allocated channel: CH3

channel CH3: sid=140 devtype=DISK

Starting Duplicate Db at 2010-04-19 16:28:12

released channel: CH1

released channel: CH2

released channel: CH3

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

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

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

RMAN-03002: failure of Duplicate Db command at 04/19/2010 16:28:12

RMAN-05503: at least one auxiliary channel must be allocated to execute this command

RMAN> run

2>  {

3>  ALLOCATE AUXILIARY CHANNEL CH1 DEVICE TYPE DISK;

4>  ALLOCATE AUXILIARY CHANNEL CH2 DEVICE TYPE DISK;

5>  ALLOCATE AUXILIARY CHANNEL CH3 DEVICE TYPE DISK;

6>  duplicate target database to sbydb nofilenamecheck;

7>  }

using target database control file instead of recovery catalog

allocated channel: CH1

channel CH1: sid=155 devtype=DISK

allocated channel: CH2

channel CH2: sid=154 devtype=DISK

allocated channel: CH3

channel CH3: sid=153 devtype=DISK

Starting Duplicate Db at 2010-04-19 16:57:40

contents of Memory Script:

{

set until scn  65180650;

set newname for datafile  1 to

"/u00/oracle/standbydb/system01.dbf";

set newname for datafile  2 to

"/u00/oracle/standbydb/undotbs01.dbf";

set newname for datafile  3 to

"/u00/oracle/standbydb/sysaux01.dbf";

set newname for datafile  4 to

"/u00/oracle/standbydb/users01.dbf";

set newname for datafile  5 to

"/u00/oracle/standbydb/example01.dbf";

set newname for datafile  6 to

"/u00/oracle/standbydb/newdb.dbf";

set newname for datafile  7 to

"/u00/oracle/standbydb/rman.dbf";

set newname for datafile  8 to

"/u00/oracle/standbydb/toto.dbf";

set newname for datafile  9 to

"/u00/oracle/standbydb/web.dbf";

set newname for datafile  10 to

"/u00/oracle/standbydb/wkyj.dbf";

set newname for datafile  11 to

"/u00/oracle/standbydb/zlktest.dbf";

set newname for datafile  12 to

"/u00/oracle/standbydb/lizi.dbf";

restore

check readonly

clone database

;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 2010-04-19 16:57:40

channel CH1: starting datafile backupset restore

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

restoring datafile 00001 to /u00/oracle/standbydb/system01.dbf

restoring datafile 00003 to /u00/oracle/standbydb/sysaux01.dbf

restoring datafile 00004 to /u00/oracle/standbydb/users01.dbf

restoring datafile 00010 to /u00/oracle/standbydb/wkyj.dbf

restoring datafile 00012 to /u00/oracle/standbydb/lizi.dbf

channel CH1: reading from backup piece /u00/dbbackup/02lbh0g9_1_1

channel CH2: starting datafile backupset restore

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

restoring datafile 00002 to /u00/oracle/standbydb/undotbs01.dbf

restoring datafile 00005 to /u00/oracle/standbydb/example01.dbf

restoring datafile 00006 to /u00/oracle/standbydb/newdb.dbf

restoring datafile 00007 to /u00/oracle/standbydb/rman.dbf

restoring datafile 00008 to /u00/oracle/standbydb/toto.dbf

restoring datafile 00009 to /u00/oracle/standbydb/web.dbf

restoring datafile 00011 to /u00/oracle/standbydb/zlktest.dbf

channel CH2: reading from backup piece /u00/dbbackup/03lbh0rv_1_1

channel CH2: restored backup piece 1

piece handle=/u00/dbbackup/03lbh0rv_1_1 tag=TAG20100419T130305

channel CH2: restore complete, elapsed time: 00:06:24

channel CH1: restored backup piece 1

piece handle=/u00/dbbackup/02lbh0g9_1_1 tag=TAG20100419T130305

channel CH1: restore complete, elapsed time: 00:10:59

Finished restore at 2010-04-19 17:08:41

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "SBYDB" RESETLOGS ARCHIVELOG

MAXLOGFILES     16

MAXLOGMEMBERS      3

MAXDATAFILES      100

MAXINSTANCES     8

MAXLOGHISTORY      292

LOGFILE

GROUP  1 ( '/u00/oracle/standbydb/redo01.log' ) SIZE 512 M  REUSE,

GROUP  2 ( '/u00/oracle/standbydb/redo02.log' ) SIZE 512 M  REUSE,

GROUP  3 ( '/u00/oracle/standbydb/redo03.log' ) SIZE 512 M  REUSE

DATAFILE

'/u00/oracle/standbydb/system01.dbf'

CHARACTER SET ZHS16GBK

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 2 switched to datafile copy

input datafile copy recid=1 stamp=716749724 filename=/u00/oracle/standbydb/undotbs01.dbf

datafile 3 switched to datafile copy

input datafile copy recid=2 stamp=716749724 filename=/u00/oracle/standbydb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy recid=3 stamp=716749724 filename=/u00/oracle/standbydb/users01.dbf

datafile 5 switched to datafile copy

input datafile copy recid=4 stamp=716749724 filename=/u00/oracle/standbydb/example01.dbf

datafile 6 switched to datafile copy

input datafile copy recid=5 stamp=716749724 filename=/u00/oracle/standbydb/newdb.dbf

datafile 7 switched to datafile copy

input datafile copy recid=6 stamp=716749724 filename=/u00/oracle/standbydb/rman.dbf

datafile 8 switched to datafile copy

input datafile copy recid=7 stamp=716749724 filename=/u00/oracle/standbydb/toto.dbf

datafile 9 switched to datafile copy

input datafile copy recid=8 stamp=716749724 filename=/u00/oracle/standbydb/web.dbf

datafile 10 switched to datafile copy

input datafile copy recid=9 stamp=716749724 filename=/u00/oracle/standbydb/wkyj.dbf

datafile 11 switched to datafile copy

input datafile copy recid=10 stamp=716749724 filename=/u00/oracle/standbydb/zlktest.dbf

datafile 12 switched to datafile copy

input datafile copy recid=11 stamp=716749725 filename=/u00/oracle/standbydb/lizi.dbf

contents of Memory Script:

{

set until scn  65180650;

recover

clone database

delete archivelog

;

}

executing Memory Script

executing command: SET until clause

Starting recover at 2010-04-19 17:08:46

starting media recovery

channel CH1: starting archive log restore to default destination

channel CH1: restoring archive log

archive log thread=1 sequence=31

channel CH1: reading from backup piece /u00/dbbackup/04lbh0se_1_1

channel CH1: restored backup piece 1

piece handle=/u00/dbbackup/04lbh0se_1_1 tag=TAG20100419T130934

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

archive log filename=/u00/arch/1_31_711650606.dbf thread=1 sequence=31

channel clone_default: deleting archive log(s)

archive log filename=/u00/arch/1_31_711650606.dbf recid=1 stamp=716749734

media recovery complete, elapsed time: 00:00:01

Finished recover at 2010-04-19 17:08:56

contents of Memory Script:

{

shutdown clone;

startup clone nomount ;

}

executing Memory Script

database dismounted

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     2089400 bytes

Variable Size                264244808 bytes

Database Buffers             801112064 bytes

Redo Buffers                   6295552 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "SBYDB" RESETLOGS ARCHIVELOG

MAXLOGFILES     16

MAXLOGMEMBERS      3

MAXDATAFILES      100

MAXINSTANCES     8

MAXLOGHISTORY      292

LOGFILE

GROUP  1 ( '/u00/oracle/standbydb/redo01.log' ) SIZE 512 M  REUSE,

GROUP  2 ( '/u00/oracle/standbydb/redo02.log' ) SIZE 512 M  REUSE,

GROUP  3 ( '/u00/oracle/standbydb/redo03.log' ) SIZE 512 M  REUSE

DATAFILE

'/u00/oracle/standbydb/system01.dbf'

CHARACTER SET ZHS16GBK

contents of Memory Script:

{

set newname for tempfile  1 to

"/u00/oracle/standbydb/temp01.dbf";

switch clone tempfile all;

catalog clone datafilecopy  "/u00/oracle/standbydb/undotbs01.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/sysaux01.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/users01.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/example01.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/newdb.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/rman.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/toto.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/web.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/wkyj.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/zlktest.dbf";

catalog clone datafilecopy  "/u00/oracle/standbydb/lizi.dbf";

switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /u00/oracle/standbydb/temp01.dbf in control file

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/undotbs01.dbf recid=1 stamp=716749754

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/sysaux01.dbf recid=2 stamp=716749754

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/users01.dbf recid=3 stamp=716749754

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/example01.dbf recid=4 stamp=716749755

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/newdb.dbf recid=5 stamp=716749755

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/rman.dbf recid=6 stamp=716749755

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/toto.dbf recid=7 stamp=716749755

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/web.dbf recid=8 stamp=716749755

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/wkyj.dbf recid=9 stamp=716749755

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/zlktest.dbf recid=10 stamp=716749755

cataloged datafile copy

datafile copy filename=/u00/oracle/standbydb/lizi.dbf recid=11 stamp=716749755

datafile 2 switched to datafile copy

input datafile copy recid=1 stamp=716749754 filename=/u00/oracle/standbydb/undotbs01.dbf

datafile 3 switched to datafile copy

input datafile copy recid=2 stamp=716749754 filename=/u00/oracle/standbydb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy recid=3 stamp=716749754 filename=/u00/oracle/standbydb/users01.dbf

datafile 5 switched to datafile copy

input datafile copy recid=4 stamp=716749755 filename=/u00/oracle/standbydb/example01.dbf

datafile 6 switched to datafile copy

input datafile copy recid=5 stamp=716749755 filename=/u00/oracle/standbydb/newdb.dbf

datafile 7 switched to datafile copy

input datafile copy recid=6 stamp=716749755 filename=/u00/oracle/standbydb/rman.dbf

datafile 8 switched to datafile copy

input datafile copy recid=7 stamp=716749755 filename=/u00/oracle/standbydb/toto.dbf

datafile 9 switched to datafile copy

input datafile copy recid=8 stamp=716749755 filename=/u00/oracle/standbydb/web.dbf

datafile 10 switched to datafile copy

input datafile copy recid=9 stamp=716749755 filename=/u00/oracle/standbydb/wkyj.dbf

datafile 11 switched to datafile copy

input datafile copy recid=10 stamp=716749755 filename=/u00/oracle/standbydb/zlktest.dbf

datafile 12 switched to datafile copy

input datafile copy recid=11 stamp=716749755 filename=/u00/oracle/standbydb/lizi.dbf

contents of Memory Script:

{

Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 2010-04-19 17:10:06

RMAN>

RMAN>

RMAN> exit

Recovery Manager complete.

[oracle@db-standby ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Apr 19 17:12:33 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown abort

ORACLE instance shut down.

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size                  2089400 bytes

Variable Size             264244808 bytes

Database Buffers          801112064 bytes

Redo Buffers                6295552 bytes

Database mounted.

Database opened.

SQL>

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@db-standby ~]$

[oracle@db-standby ~]$

[oracle@db-standby ~]$ exit

logout

[root@db-standby ~]# exit

logout

Mustafa Xia
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
RMAN duplicate搭建辅助数据库
mengxiangfeiyang的专栏
03-18 800
使用RMAN DUPLICATE命令可以在保留目标数据库的基础上依靠目标数据库(TargetDatabase)的备份创建一个副本数据库(DuplicateDatabase)，目标数据库和辅助数据库可以在同一台机器上，辅助数据库是目标数据库的一个拷贝。
ORACLE数据库PDB管理-备份与恢复
oradbm的博客
07-30 2027
1 文件结构图如下： Oracle 12c中当对指定的PDB进行不完全恢复的时候,其它的PDBS是完全不受影响的,多租户特性的好处就在于此,并且在恢复完成后老的PDB备份仍然有效,我们也不用为这个PDB创建新的备份。在实验的时候我遇到了一个小问题,就是在进行recover操作时会启动辅助实例,辅助实例则会使用到fast recovery area,如果fast recovery area的空间不够了,recover时会报错。后来手动使用AUXILIARY DESTINATION子句来为辅助实例指定一个临时
Oracle11g新特性：Active Database Duplicate
weixin_34353714的博客
01-15 161
利用Rman的duplicate命令，可以很方便的将原库复制出一个新库，这在诸如data guard等应用中非常有用。但是在Oracle11g之前，执行duplicate要求首先对原库用rman进行备份，然后将备份复制到复制库，同时连接原库(做为target)和复制库(做为auxiliary)，执行duplicate命令进行复制。在Oracle11g中推出的active da...
利用RMAN建立10GRAC数据库的DATA GUARD
ckawt40802的专栏
11-07 172
本文介绍如何使用RMAN建立10G的RAC环境的DATA GUARD。由于环境所限，DATA GUARD的STANDBY数据库是一个单实例数据库。首先进行准备工作，在STANDBY数据库服务器上安装Oracle10201软件，然...
Oracle DG搭建1(duplicate方式)
ckth47350的博客
10-29 530
Oracle DG搭建1(duplicate方式) (1) 主库：开启归档模式 (2) 主库：开启强制写日志功能 (3) 主库：关闭闪回 (4) 主库：配置静态监听,配置tnsnames 文件 (5) ...
RMAN高级应用之Duplicate复制数据库.docx
最新发布
10-25
RMAN高级应用之Duplicate复制数据库
利用RMAN创建“军卫一号”Oracle Dataguard数据库.pdf
10-10
在创建Oracle Dataguard时，RMAN提供了一种更简单、自动化的方法来配置和管理备用数据库，简化了数据库的复制和维护过程。 【创建Dataguard的步骤】利用RMAN创建Oracle Dataguard通常包括以下步骤： 1. **配置网络*...
ORACLE Duplicate复制数据库
12-20
duplicate绝对干货。利用duplicate复制数据库，文档中包换每一步的试验步骤，详细说明了每一步的作用及用途，和注意事项，一步一步至试验成功，绝对一次成功。
Oracle RMAN 异机 复制数据库
04-22
例如，在`/u01/app/oracle/oradata`下创建数据库实例`orcl`的目录，以及在`/u01/app/oracle/admin`下创建对应的辅助数据库管理目录。 2. **创建pfile并复制到辅助数据库**： 在源数据库上，通过`CREATE PFILE FROM...
通过duplicate创建cdb、EMDE等
01-11
ORACLE 19c 创建容器CDB 创建EMDE
oracle 数据库 卸载 辅助
03-07
oracle数据库卸载辅助程序，用于卸载oracle数据库后的注册表清理，以达到完全卸载oracle数据库的目的。众所周知oracle数据库一经安装很难卸载，有此程序你将不再困扰oracle数据库的卸载工作了。
DG-duplicate操作注意事项(各种报错应对方法)
clp1532的博客
03-30 1712
DG-duplicate 操作注意事项 1、duplicate时用户必须使用sys用户 2、to standby的脚本 #!/bin/bash LOG=duplicate...
【RMAN】RMAN-05001: auxiliary filename conflicts with the target database
dba_monkey的博客
03-13 1772
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ==========================================
使用RMAN传输数据_复制数据库
jetliu05的博客
01-26 3263
使用RMAN的DUPLICATE命令可以从源数据库复制全部或部分数据到复制数据库。
oracle 创建辅助库
weixin_34277853的博客
12-28 295
辅助数据库是为了某种测试目的，来创建的和某一个时刻的目标数据库完全一样的数据库；1.目标数据库和辅助数据库的环境描述一般来说，目标数据库和辅助数据库应该分别存放在不同的服务器上；要求，存放辅助数据库的服务器上，安装有和目标库完全一样版本的数据库软件即可；目标库和辅助数据库要有网络连接目标数据库：ORACLE_SID=orcl11gIP_ADDRESS:192....
auxiliary恢复备库详细记录
weixin_34162629的博客
02-09 587
   -bash-3.2$ rman target / auxiliary sys/password@standby     Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 8 22:01:47 2012     Copyright (c) 1982, 200...
oracle数据库创建脚本
热门推荐
.... 永远年轻，永远热泪盈眶
04-28 1万+
oracle数据库创建脚本所需文件及文件内容，将各个文件放于同一文件夹，运行bat文件即可。文件一：  01_创建表空间和用户.sqlCREATE TABLESPACE TS_APP LOGGING DATAFILE '&1\TS_APP.ora' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED...
创建DG《大话 Oracle Grid》（duplicate）
Baldwin的博客
05-26 184
本文整理自张晓明的《大话Oracle Grid》 环境准备： 主库：10.107.173.11 备库：10.107.173.12 系统初始化略，主库安装Oracle软件和实例，备库只安装Oracle软件略，可以参考我的文章Centos7.x静默安装11gR2 备库配置好静态监听，主库备库写好tns文件，主库密码文件scp到备库 主备库tns文件如下： tnspri= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.35.35)(

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值