OraFAQ Forum: Backup & Recovery » User-managed backups of a 10g DB using ASM

Home » RDBMS Server » Backup & Recovery » User-managed backups of a 10g DB using ASM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User-managed backups of a 10g DB using ASM [message #242266]

Fri, 01 June 2007 07:39

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?

Report message to a moderator

Re: User-managed backups of a 10g DB using ASM [message #242273 is a reply to message #242266]

Fri, 01 June 2007 08:03

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you use ASM, you have to use RMAN to backup.
No other way.

Regards
Michel

Report message to a moderator

Re: User-managed backups of a 10g DB using ASM [message #242275 is a reply to message #242266]

Fri, 01 June 2007 08:06

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?

Report message to a moderator

Re: User-managed backups of a 10g DB using ASM [message #242278 is a reply to message #242275]

Fri, 01 June 2007 08:12

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Previous Topic:	DATABASE
Next Topic:	begin backup mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 10:28:00 CDT 2024