| Oracle 10 g Query [message #586708] |
Mon, 10 June 2013 04:38  |
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 #586720 is a reply to message #586719] |
Mon, 10 June 2013 05:32  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
