Topic: Backup & Recovery >> rman backup does not work properly
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: rman backup does not work properly |
| sivakumar |
Posted: Jun 26, 2009 11:50:05 PM |
Total Post: 18
Joined: Jan, 2009
|
in our production database, we have 5 tablespace, in that 2 tablespace are stored in SAN disk, rest of the three T.S are stored in local server, the problem is when i take backup of entire DB using RMAN the T.S stored in SAN disk RMAN takes used and unused blocks from the T.S in SAN disk.
but the rest of 3 T.S (which stored in local server) RMAN performs backups of used blocks only.
i would appreciate, if somebody could help me in this regard.
|
|
|
 Gitesh |
| Posted: Jul 11, 2009 02:58:08 PM |  |
|
Total Post: 515
Joined: May, 2005
|
Hi,
What is the Oracle version and paste output of RMAN backup.
Thanks and regards,
Gitesh Trivedi
www.dbametrix.com
|
|
|
|
|
| sivakumar |
| Posted: Jul 12, 2009 11:23:55 PM | |
|
Total Post: 18
Joined: Jan, 2009
|
hi
we are using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
RMAN> backup tablespace niil_ndx
Starting backup at 13-JUL-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00007 name=/oraclendx/niil_ndx.dbf
channel ORA_DISK_1: starting piece 1 at 13-JUL-09
channel ORA_DISK_1: finished piece 1 at 13-JUL-09
piece handle=/oracle/data/flash_recovery_area/NIIL/backupset/2009_07_13/o1_mf_nnndf_TAG20090713T083739_55o97wyr_.bkp tag=TAG20090713T083739 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:07:05
Finished backup at 13-JUL-09
****
thats the o/p.
niil_ndx tablespace is stored in SAN disk, and it has size of 10G, actually it contains 2.5 GB of data only, but while i am taking backup of this tablespace it takes entire 10G, i don't know why.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| menon srivalsala kumar | 639 |
| positive fanatic | 615 |
| Gitesh Trivedi | 515 |
| Jayanta Sur | 480 |
| Vinoth Kumar | 436 |
| Vigyan Kaushik | 398 |
| Gopu Gopi | 364 |
| Vishant Sanghavi | 346 |
|
|
