溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
本篇文章給大家分享的是有關如何從ASM復制文件到文件系統，小編覺得挺實用的，因此分享給大家學習，希望大家閱讀完這篇文章后可以有所收獲，話不多說，跟著小編一起來看看吧。
版本10.2.0.5
1、使用RMAN：
$ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 16 10:02:41 2012 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 2097696 bytes Variable Size 503320032 bytesDatabase Buffers 1627389952 bytes Redo Buffers 14675968 bytesDatabase mounted. SQL> select file#, name, bytes from v$datafile where file#=5; FILE# NAME BYTES---------- -------------------------------------------------- ---------- 5 +DATA01/dbname/datafile/users.264.730552875 524288000 $ rman target / nocatalog Recovery Manager: Release 10.2.0.5.0 - Production on Fri Mar 16 10:06:08 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: dbname (DBID=2555001420, not open)using target database control file instead of recovery catalog RMAN> copy datafile 5 to '/arch2/users.264.730552875'; Starting backup at 16-MAR-12allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=1624 instance=dbname1 devtype=DISK channel ORA_DISK_1: starting datafile copy input datafile fno=00005 name=+DATA01/dbname/datafile/users.264.730552875 output filename=/arch2/users.264.730552875 tag=TAG20120316T100622 recid=2 stamp=778068391channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15Finished backup at 16-MAR-12 RMAN> exit Recovery Manager complete.$ ls -l /arch2/users.264.730552875-rw-r----- 1 oracle oinstall 524296192 Mar 16 10:06 /arch2/users.264.730552875 |
[@more@]
2、使用dbms_file_transfer包：
SQL> select open_mode from v$database; OPEN_MODE----------READ WRITE SQL> create or replace directory SOURCE_DIR1 as '+DATA01/dbname/onlinelog/'; Directory created. SQL> create or replace directory ORACLE_DEST as '/arch2/'; Directory created. SQL> SQL> BEGIN 2 dbms_file_transfer.copy_file( 3 source_directory_object =>'SOURCE_DIR1', 4 source_file_name => 'group_1.274.730565825', 5 destination_directory_object => 'ORACLE_DEST', 6 destination_file_name => 'group_1.274.730565825' 7 ); 8 END; 9 / PL/SQL procedure successfully completed. SQL> ! ls -l /arch2/group_1.274.730565825-rw-r----- 1 oracle oinstall 524288512 Mar 14 10:49 /arch2/group_1.274.730565825 |
以上就是如何從ASM復制文件到文件系統，小編相信有部分知識點可能是我們日常工作會見到或用到的。希望你能通過這篇文章學到更多知識。更多詳情敬請關注億速云行業資訊頻道。
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
