Home » RDBMS Server » Backup & Recovery » User-managed backups of a 10g DB using ASM
User-managed backups of a 10g DB using ASM [message #242266] Fri, 01 June 2007 07:39 Go to next message
t.summerfield
Messages: 39
Registered: March 2007
Location: UK
Member
Is it possible to do user-managed backups of a 10g database which is using ASM?

When I run the following SQL command

SELECT NAME FROM v$datafile;

It returns

+DBDATA/db_test/datafile/system.256.617633575
+DBDATA/db_test/datafile/users.259.617633757


The ASM is setup in 'normal redundency' across 2 partitions, both of which are not formatted.

If there is anyone who has done user-mangaged backups on a 10g DB using ASM who could provide an insight I would be greatful.

Basically what I would like to know is how do I access the datafiles, so I can back them up to a location of my choosing?
Re: User-managed backups of a 10g DB using ASM [message #242273 is a reply to message #242266] Fri, 01 June 2007 08:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you use ASM, you have to use RMAN to backup.
No other way.

Regards
Michel
Re: User-managed backups of a 10g DB using ASM [message #242275 is a reply to message #242266] Fri, 01 June 2007 08:06 Go to previous messageGo to next message
t.summerfield
Messages: 39
Registered: March 2007
Location: UK
Member
Thanks for the reply

Are you absolutely sure? I am not doubting you are telling the truth, I would just like further clarification i.e. where did you read/learn this from?
Re: User-managed backups of a 10g DB using ASM [message #242278 is a reply to message #242275] Fri, 01 June 2007 08:12 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
"Database Administrator's Guide",
Chapter 12 "Using Automatic Storage Management",
section "Using Automatic Storage Management in the Database",
subsection "Recovery Manager (RMAN) and ASM"
Quote:
RMAN is the only method for performing backups of a database containing ASM files.

Regards
Michel
Previous Topic: DATABASE
Next Topic: begin backup mode
Goto Forum:
  


Current Time: Sat Dec 14 16:36:09 CST 2024