RMAN> BACKUP AS COPY
DATAFILE "+DATA/rdbms/datafile/tbs_1.252.234234"
FORMAT "+DATA";
RMAN>Backup as copy database format "+DATA";
Rman canbe used to migrate database into ASM
you can access ASM files using XMLDB
Access via PLSQL,FTP and HTTP.
You can access under /sys/asm, the folder hierarchy is defined by the structure of an ASM
You can run $ORACLE_HOME/rdbms/admin/catxdbdbca.sql or use Oracle enterprise manager
Also you can use DBMS_FILE_TRANSFER
SQL> CREATE DIRECTORY deneme AS '+DATA/files';
SQL> CREATE DIRECTORY osden AS '/u01/app/oracle/oradata/orcl';
SQL> BEGIN
DBMS_FILE_TRANSFER.COPY_FILE('osden','user.dbf','deneme','user.dbf');
END;
/
DBMS_FILE_TRANSFER supports all combination. ASM to O/S files or O/S files to ASM
You can use ASMCMD like
grid@zek ~]$ asmcmd
ASMCMD> cd +DATA/orcl/DATAFILE
ASMCMD> ls -l
ASMCMD> cd ..
ASMCMD> pwd
+DATA/orcl/DATAFILE
Hiç yorum yok:
Yorum Gönder