Home » RDBMS Server » Backup & Recovery » not required backup
not required backup [message #111743] Sat, 19 March 2005 04:08 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

I am sunil mishra & in interview of IBM for DBA they asked me question

Question : There are system tablespace, Temp tabalespaces, Undo tablespace and User tablespaces now for which tablespaces backup is not required? and why?

... i only need answer of my question so that i can know my answer was right or wrong.

thank you

sunil
Re: not required backup [message #111810 is a reply to message #111743] Mon, 21 March 2005 00:23 Go to previous messageGo to next message
sridcpp
Messages: 23
Registered: February 2005
Location: India
Junior Member
backup of tempfiles are not allowed, temprorary tablespaces are used when sorts take place, if sorts are not taking place in memory, then sorts are done at temporary tablespaces. The Sort data is not required for any backup purpose.

Backup file
Data File
Redo files
Archive Files

Control file
Password file

Bye
Sreedhar Reddy
Re: not required backup [message #111958 is a reply to message #111810] Tue, 22 March 2005 01:50 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi ,

thank you very much for your answer actually i had given same answer in my interview...that really increses my confidence level ...

regard
sunil mishra
Re: not required backup [message #114907 is a reply to message #111743] Wed, 06 April 2005 05:45 Go to previous messageGo to next message
neelakantha_subudhi
Messages: 1
Registered: April 2005
Location: Secunderabad
Junior Member
Hi ,

The Temp tablespace is not required to backup as it is not required at the time of recovery

have U answred the same at UR interview ? Ten U R correct

neel
Re: not required backup [message #115191 is a reply to message #114907] Fri, 08 April 2005 01:33 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
thank u neelakantha for your reply ....
Previous Topic: Proxy copies and image copies
Next Topic: Recovering offline dropped datafile - Very Very Urgent
Goto Forum:
  


Current Time: Fri Mar 29 08:45:16 CDT 2024