OraFAQ Forum: Backup & Recovery » alter tablespace begin bakup;

Home » RDBMS Server » Backup & Recovery » alter tablespace begin bakup; (9 AIX)

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

alter tablespace begin bakup; [message #333613]

Sun, 13 July 2008 11:31

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

hello

what is more safe to do in oracle?
alter tablespace begin backup
or
alter database begin backup in 10g?

why was this diffrent between versions?

Report message to a moderator

Re: alter tablespace begin bakup; [message #333615 is a reply to message #333613]

Sun, 13 July 2008 11:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above

>what is more safe to do in oracle?
Both are safe when used appropriately.

>why was this diffrent between versions?
Features & functions change between version; otherwise no need for newer version(s).

[Updated on: Sun, 13 July 2008 11:47] by Moderator

Report message to a moderator

Re: alter tablespace begin bakup; [message #333622 is a reply to message #333613]

Sun, 13 July 2008 12:08

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

Senior Member
Account Moderator

Quote:

why was this diffrent between versions?

Who say they are different?
Or rather, who say the first one no more exists in 10g?

Regards
Michel

Report message to a moderator

Re: alter tablespace begin bakup; [message #334558 is a reply to message #333613]

Thu, 17 July 2008 02:19

aaryaan
Messages: 9
Registered: July 2008
Location: Bangalore

Junior Member

Hi,
Alter database has been introduced in recent version to simplify the backup steps. Which one is safe is depend on your database. Incase you have lot of transaction happening during backup, it is advisable to go for alter tablespace begin backup. If the DB is relatively idle then go for alter database.

Regards,
Satheesh Babu S

[Updated on: Thu, 17 July 2008 02:22] by Moderator

Report message to a moderator

Re: alter tablespace begin bakup; [message #335918 is a reply to message #334558]

Thu, 24 July 2008 02:56

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Oracle 10g allows all of the data files in the database to be placed in online backup mode using a single command

SQL> ALTER DATABASE BEGIN BACKUP;

You no longer need to place each tablespace in online backup mode individually:

SQL> ALTER TABLESPACE user BEGIN BACKUP;
SQL> ALTER TABLESPACE example BEGIN BACKUP;

But still we can use this tablespace begin backup.

The ALTER DATABASE BEGIN BACKUP command places all data files in the database in online backup mode. The database must be in mounted or open mode when you issue this command.
If our ablespace is in read only mode then alter tablespace tablespace_name begin backup; will give error even if we make any tablespace offline and try to keep that tablespace in begin backup mode will give error.

In short DB should be up and running, DB must be mounted or in open mode.

All dirty blocks must be flushed from the buffer when you "alter tablespace begin backup". Check x$bh.

The tablespace must also be quesced, meaning that transactions must complete. Check for current transactions holding a transaction lock (TX).

Report message to a moderator

Re: alter tablespace begin bakup; [message #335926 is a reply to message #335918]

Thu, 24 July 2008 03:10

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

Senior Member
Account Moderator

With all these mixed and partial information I don't know if anyone can understand something, I don't.

Regards
Michel

Report message to a moderator

Re: alter tablespace begin bakup; [message #336010 is a reply to message #335918]

Thu, 24 July 2008 07:04

ebrian
Messages: 2794
Registered: April 2006

Senior Member

sunil_v_mishra wrote on Thu, 24 July 2008 03:56

The tablespace must also be quesced, meaning that transactions must complete. Check for current transactions holding a transaction lock (TX).

I'm not really sure what this is supposed to mean. There are transactions going on all the time that's the purpose of a ONLINE backup.

Report message to a moderator

Re: alter tablespace begin bakup; [message #337023 is a reply to message #336010]

Tue, 29 July 2008 12:36

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Michel i think lioracle is able to understand what i have written, just seeing the question of lioracle i can say someone has asked him/her this question in interview ... Very Happy

[Updated on: Tue, 29 July 2008 12:37]

Report message to a moderator

Previous Topic:	Is redo log contain commited or uncommited or both
Next Topic:	auto down database when perform oracle suggest backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 18:00:46 CDT 2024