Home » RDBMS Server » Backup & Recovery » Oracle 10 g Query
Oracle 10 g Query [message #586708] Mon, 10 June 2013 04:38 Go to next message
mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan
Member
Dear All,

I am having a issue, we are trying to restore our db from control files using Symantec Backup exec,
but job fails giving me error go to table spaces select all table spaces and unchecked rollforward.

i am unable to find way to uncheck the table spaces.

Here is the complete description.





Cause

The system catalog tablespace "syscatspace" contains all of the system catalog information for the tables. Syscatspace needs to be rolled forward first, and then the other tablespaces must be rolled forward.


Solution

Workaround:

When the restore operation is run from a tablespace level backup, perform the rollforward for the syscatspace tablespace first and then for other tablespaces.

Execute the rollforward operation as a DBA operation. The sequence of the recovery process should be as follows:

1. Select all tablespaces, uncheck the rollforward option and run the restore job.

2. Run the rollforward operation as a DBA initiated operation:

rollforward syscatspace to point in time / end of logs. e.g. db2 => rollforward database UEXIT to end of logs and complete Tablespace (SYSCATSPACE) online

3. Perform rollforward of all other tablespaces.

e.g. db2 => rollforward database UEXIT to end of logs and complete tablespace (SYSTOO LSPACE,USERSPACE1) online

Refer to IBM DB2 documentation for more information on DBA-initiated operations.

Re: Oracle 10 g Query [message #586711 is a reply to message #586708] Mon, 10 June 2013 04:58 Go to previous messageGo to next message
Littlefoot
Messages: 19294
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
Refer to IBM DB2 documentation

DB2? This is an Oracle forum.
Re: Oracle 10 g Query [message #586712 is a reply to message #586708] Mon, 10 June 2013 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 58482
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where is the question?
How is this related to Oracle?

Regards
Michel
Re: Oracle 10 g Query [message #586713 is a reply to message #586712] Mon, 10 June 2013 05:06 Go to previous messageGo to next message
mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan
Member
Question is this

How to remove or uncheck roll forward in table spaces?
Re: Oracle 10 g Query [message #586714 is a reply to message #586713] Mon, 10 June 2013 05:08 Go to previous messageGo to next message
Littlefoot
Messages: 19294
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which database do you use?
a) Oracle
b) DB2
Re: Oracle 10 g Query [message #586715 is a reply to message #586714] Mon, 10 June 2013 05:10 Go to previous messageGo to next message
mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan
Member
I am using Oracle 10g
Re: Oracle 10 g Query [message #586719 is a reply to message #586715] Mon, 10 June 2013 05:29 Go to previous messageGo to next message
John Watson
Messages: 4368
Registered: January 2010
Location: Global Village
Senior Member
syscatspace is DB2, not Oracle. I think you may be confused about what product you are using.
Re: Oracle 10 g Query [message #586720 is a reply to message #586719] Mon, 10 June 2013 05:32 Go to previous messageGo to next message
mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan
Member
No i am sure i am using oracle 10 g the description i posted here i found on the Symantec site please tell me how to uncheck roll forward on oracle table spaces.
Re: Oracle 10 g Query [message #586721 is a reply to message #586720] Mon, 10 June 2013 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 58482
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this an Oracle question?
"uncheck roll forward on oracle table spaces" is meaningless in Oracle.
Post your question on a Symantec forum.

Regards
Michel
Re: Oracle 10 g Query [message #586724 is a reply to message #586721] Mon, 10 June 2013 05:45 Go to previous message
mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan
Member
Ok thanks.
Previous Topic: Disable RedoLog for a single user?
Next Topic: Protocol used by RMAN
Goto Forum:
  


Current Time: Tue Jul 22 09:07:09 CDT 2014

Total time taken to generate the page: 0.11159 seconds