Home » RDBMS Server » Backup & Recovery » How to recover package procedure from previous backup (Sun Solaris 9)
How to recover package procedure from previous backup [message #340433] Tue, 12 August 2008 18:19 Go to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
How to recover package source code from previous backup which is hot backup, using OS cp command.

The source is stored at system tablespace or the user default tablespace?
Can we just restore those required tablespace in this case?

Pls advise. Thank you.


Sorry, this should be under Backup & Recovery Forum. Pls help to change. Thanks.

[Updated on: Tue, 12 August 2008 18:39]

Report message to a moderator

Re: How to recover package procedure from previous backup [message #340444 is a reply to message #340433] Tue, 12 August 2008 22:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Theorically, code should be in your versioning repository...

Now, you have to create a new database from your backup and get the procedure source from it, using dbms_metadata for instance.

Regards
Michel
Re: How to recover package procedure from previous backup [message #340578 is a reply to message #340444] Wed, 13 August 2008 06:06 Go to previous messageGo to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
That's the point I would like to confirm..
do we need to restore those tablespace contain user data when recreate new db for restoring? or only the system tablespace?
Re: How to recover package procedure from previous backup [message #340595 is a reply to message #340578] Wed, 13 August 2008 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You only need mandatory tablespaces: SYSTEM and UNDO tablespace if you use automatic undo management or tablespace containing the rollback segments otherwise.

Regards
Michel
Re: How to recover package procedure from previous backup [message #340630 is a reply to message #340595] Wed, 13 August 2008 08:46 Go to previous message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
ok, got yr point. Thanks for the clarification. Smile

[Updated on: Wed, 13 August 2008 08:46]

Report message to a moderator

Previous Topic: BACKUP FAILS
Next Topic: Backup of Oracle Portal
Goto Forum:
  


Current Time: Sun Dec 11 00:36:16 CST 2016

Total time taken to generate the page: 0.10161 seconds