| alter tablespace begin bakup; [message #333613] |
Sun, 13 July 2008 11:31  |
lioracle
Messages: 54
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  |
anacedent
Messages: 7064
Registered: July 2005
Location: surf meets turf in 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]
|
|
|
| Re: alter tablespace begin bakup; [message #333622 is a reply to message #333613 ] |
Sun, 13 July 2008 12:08 |
Michel Cadot
Messages: 21459
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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 |
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
|
|
|
| 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).
|
|
|
| Re: alter tablespace begin bakup; [message #335926 is a reply to message #335918 ] |
Thu, 24 July 2008 03:10 |
Michel Cadot
Messages: 21459
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 #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 ... 
[Updated on: Tue, 29 July 2008 12:37]
|
|
|
]
Members
Search
Help
Register
Login
Home
