Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, March 4, 2010

Copy ASM files to File system

Use this with the below for clone :
SQL>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
SQL>create pfile from spfile;


Method-1:
SQL>ALTER DATABASE MOUNT;
RMNA> Connect target /
RMAN> backup as copy tablespace system format '/unix02/u0001/datafilesbackup/%U';
RMAN> backup as copy tablespace sysaux format '/unix02/u0001/datafilesbackup/%U';
exit;

No comments: