Home » RDBMS Server » Backup & Recovery » alter tablespace begin bakup; (9 AIX)
alter tablespace begin bakup; [message #333613] Sun, 13 July 2008 11:31 Go to next message
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?
Re: alter tablespace begin bakup; [message #333615 is a reply to message #333613] Sun, 13 July 2008 11:46 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: alter tablespace begin bakup; [message #334558 is a reply to message #333613] Thu, 17 July 2008 02:19 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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).
Re: alter tablespace begin bakup; [message #335926 is a reply to message #335918] Thu, 24 July 2008 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: alter tablespace begin bakup; [message #336010 is a reply to message #335918] Thu, 24 July 2008 07:04 Go to previous messageGo to next message
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.
Re: alter tablespace begin bakup; [message #337023 is a reply to message #336010] Tue, 29 July 2008 12:36 Go to previous message
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:
  


Current Time: Sat Dec 10 02:59:53 CST 2016

Total time taken to generate the page: 0.27049 seconds