25.10.2010

Oracle Grid Infra / ASM Files and RMAN

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: