如何取出asm中的数据文件。

lfree

问一下，10g下，在不启动数据库的情况下，如何取出asm里面的数据文件。

10g下，asmcmd没有cp命令，有什么方法可以实现取出asm里面的数据文件？

yanggq

rman, you can startup mount;

lfree

我是指不启动数据库的情况下，还有别的方法吗？

lfree

顶上来

1x1xqq_cu

取数据可以用rman,ftp,dbms_ 这个过程


有一点, asm设计的初衷包含了这点:  以前我们用文件系统或者裸设备,可能会存在误删除数据文件的情况，那asm为了避免这一点，就根本不让OS访问asm文件，除了asm实例，
只有asm实例加载了asm diskgroup后，才能对其访问，

如果不通过asm实例就能访问asm文件，那asm设计的出发点都要变了

XQKA

rman copy

XQKA

[oracle@RAC2 ~]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Jun 21 10:54:59 2011

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

connected to target database: PROD (DBID=363213644)

RMAN> copy datafile '+DG1/PROD/users01.dbf' to '/home/oracle/user01.dbf';

Starting backup at 21-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=+DG1/PROD/users01.dbf
output filename=/home/oracle/user01.dbf tag=TAG20110621T105646 recid=5 stamp=754397811
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 21-JUN-11

Starting Control File and SPFILE Autobackup at 21-JUN-11
piece handle=+DG2/PROD/autobackup/2011_06_21/s_754397813.1256.754397815 comment=NONE
Finished Control File and SPFILE Autobackup at 21-JUN-11

RMAN> host
2> ;

[oracle@RAC2 ~]$ ls -lh user01.dbf
-rw-r-----  1 oracle oinstall 229M Jun 21 10:56 user01.dbf

开开向上

数据库在未打开的状态下这个动作能作吗

原帖由 XQKA 于 2011-6-21 11:00 发表
[oracle@RAC2 ~]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Jun 21 10:54:59 2011

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

connected to target database: PROD (DBID=363213644)

RMAN> copy datafile '+DG1/PROD/users01.dbf' to '/home/oracle/user01.dbf';

Starting backup at 21-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=+DG1/PROD/users01.dbf
output filename=/home/oracle/user01.dbf tag=TAG20110621T105646 recid=5 stamp=754397811
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 21-JUN-11

Starting Control File and SPFILE Autobackup at 21-JUN-11
piece handle=+DG2/PROD/autobackup/2011_06_21/s_754397813.1256.754397815 comment=NONE
Finished Control File and SPFILE Autobackup at 21-JUN-11

RMAN> host
2> ;

[oracle@RAC2 ~]$ ls -lh user01.dbf
-rw-r-----  1 oracle oinstall 229M Jun 21 10:56 user01.dbf

bluemoon0083

用ASM instance连接上去做不可以吗？

XQKA

原帖由 开开向上 于 2011-6-21 11:33 发表
数据库在未打开的状态下这个动作能作吗

mount status也OK啦