Home » Server Options » RAC & Failsafe » ASM cold backup
ASM cold backup [message #344949] Mon, 01 September 2008 23:52 Go to next message
gajini
Messages: 259
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 #344950 is a reply to message #344949] Mon, 01 September 2008 23:56 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Perhaps you should consider RMAN.
Re: ASM cold backup [message #344977 is a reply to message #344949] Tue, 02 September 2008 01:21 Go to previous messageGo to next message
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 #345004 is a reply to message #344977] Tue, 02 September 2008 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the connection between your question and original one?

Regards
Michel
Re: ASM cold backup [message #345350 is a reply to message #344949] Wed, 03 September 2008 03:21 Go to previous message
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
Previous Topic: ASM DiskGroup Fails to Mount
Next Topic: Error in CRS Install..Failed to upgrade Oracle Cluster Registry configuration
Goto Forum:
  


Current Time: Thu Dec 08 12:28:43 CST 2016

Total time taken to generate the page: 0.08674 seconds