| ASM cold backup [message #344949] |
Mon, 01 September 2008 23:52  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
How to make cold backup of database managed by ASM and how to do database cloning using that cold backup?
Thanks..
|
|
|
|
|
|
| Re: ASM cold backup [message #344977 is a reply to message #344949] |
Tue, 02 September 2008 01:21  |
saravananin
Messages: 1
Registered: September 2008
|
Junior Member |
|
|
Hi All,
Can anybody tell me what is processing constraints and how it will be effectively used?
Your earliest answer is highly solicited.
Thanks in Advance
Saravanan
|
|
|
|
|
|
| Re: ASM cold backup [message #345350 is a reply to message #344949] |
Wed, 03 September 2008 03:21 |
sonumalhi
Messages: 62
Registered: April 2008
|
Member |
|
|
You can FTP datafiles but it is recommecded to use RMAN
FTP Access
Because ASM is not a regular file system, you can't use the standard FTP and HTTP services to access these files. To access them, you can use the file mapping functionalities provided by the Oracle XML Database (Oracle XML DB) feature.
To set up the FTP access, you must first set up the Oracle XML DB access to the ASM folders. I can do this by executing the catxdbdbca.sql script, found in the $ORACLE_HOME/rdbms/admin directory. The script takes two parameters: the port numbers for the FTP and HTTP services, respectively.
@catxdbdbca 7777 8080
Now you can connect to the created Oracle XML DB FTP service using a database username and password:
ftp myserverhost 7777
ASM disk groups are available outside the database via a virtual file system: /sys/asm. From there, you can navigate ASM storgae. For example:
ftp> cd /sys/asm
ftp> ls
USERDG5
USERDG4
USERDG3
USERDG2
USERDG1
ftp> cd USERDG2
250 CWD Command successful
ftp> ls
emrep
DBA102
ftp> cd DBA102
ftp> ls
DATAFILE
system01.dbf
system01.dbf
sysaux01.dbf
undotbs01.dbf
users01.dbf
CONTROLFILE
control01.ctl
...
You can then switch to binary mode and download any datafile:
ftp> bin
ftp> get users01.db
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
