| 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?
|
|
|
|
|
|
|
|
| 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).
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
