Home » RDBMS Server » Server Administration » UNDO TABLESPACE (Oracle 12c (12.1.0.1.0)- Solaris)
UNDO TABLESPACE [message #668624] Wed, 07 March 2018 06:02 Go to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Hello Experts:

I have a tablespace named undotbs on primary & standby but while checking on standby by SQL> show parameter undo; the undo_tablespace is UNDOTBS1 which is not exist
But on the primary undo_tablespace is UNDOTBS. Please let me know how I can correct it on standby db's.

@Primary:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 28800
undo_tablespace string UNDOTBS
SQL> select name from v$tablespace where name='UNDOTBS1';

no rows selected

SQL> select name from v$tablespace where name='UNDOTBS';

NAME
------------------------------
UNDOTBS


---Dataguard02

SQL> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1


SQL> select name from v$tablespace where name='UNDOTBS1';

no rows selected

SQL> select name from v$tablespace where name='UNDOTBS';

NAME
------------------------------
UNDOTBS


----Dataguard01

SQL*Plus: Release 12.1.0.1.0 Production on Wed Mar 7 03:19:31 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 36000
undo_tablespace string UNDOTBS1
SQL> select name from v$tablespace where name='UNDOTBS1';

no rows selected

SQL> select name from v$tablespace where name='UNDOTBS';

NAME
------------------------------
UNDOTBS

[Updated on: Wed, 07 March 2018 06:04]

Report message to a moderator

Re: UNDO TABLESPACE [message #668627 is a reply to message #668624] Wed, 07 March 2018 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 21 February 2018 09:11

...Please read and apply How to use [code] tags and make your code easier to read.

John Watson wrote on Wed, 28 February 2018 08:24
Please use [code] tags in your posts. You have been asked to do this before.
...

[Updated on: Wed, 07 March 2018 06:33]

Report message to a moderator

Re: UNDO TABLESPACE [message #668629 is a reply to message #668627] Wed, 07 March 2018 06:42 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Hi Michecl, I am not able to understand. What Should I do via this code. I will understand and try to do that.
Re: UNDO TABLESPACE [message #668631 is a reply to message #668629] Wed, 07 March 2018 06:57 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
After formatting its look like this.


SQL> show parameter undo NAME type value
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean false undo_management string auto undo_retention integer 28800 undo_tablespace string undotbs sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS1';no rows selected sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS';NAME
------------------------------
undotbs
---Dataguard02
sql> show parameter undo;NAME type value
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean false undo_management string auto undo_retention integer 900 undo_tablespace string undotbs1 sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS1';no rows selected sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS';NAME
------------------------------
undotbs
----Dataguard01
sql*PLUS: release 12.1.0.1.0 production ON wed mar 7 03:19:31 2018 copyright (c) 1982, 2013, oracle. ALL rights reserved. connectedTO: oracle DATABASE 12c enterprise edition release 12.1.0.1.0 - 64bit production WITH the partitioning, olap, advanced analytics
AND
real application testing options sql> show parameter undo;NAME type value
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean false undo_management string auto undo_retention integer 36000 undo_tablespace string undotbs1 sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS1';no rows selected sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS';NAME
------------------------------
undotbs
Re: UNDO TABLESPACE [message #668637 is a reply to message #668629] Wed, 07 March 2018 08:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
daulat01 wrote on Wed, 07 March 2018 13:42
Hi Michecl, I am not able to understand. What Should I do via this code. I will understand and try to do that.
Did you click on the link?

Re: UNDO TABLESPACE [message #668651 is a reply to message #668637] Wed, 07 March 2018 13:16 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Yes I clicked the link and find below the output after formatting

SQL> show parameter undo NAME type value
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean false undo_management string auto undo_retention integer 28800 undo_tablespace string undotbs sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS1';no rows selected sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS';NAME
------------------------------
undotbs
---Dataguard02
sql> show parameter undo;NAME type value
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean false undo_management string auto undo_retention integer 900 undo_tablespace string undotbs1 sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS1';no rows selected sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS';NAME
------------------------------
undotbs
----Dataguard01
sql*PLUS: release 12.1.0.1.0 production ON wed mar 7 03:19:31 2018 copyright (c) 1982, 2013, oracle. ALL rights reserved. connectedTO: oracle DATABASE 12c enterprise edition release 12.1.0.1.0 - 64bit production WITH the partitioning, olap, advanced analytics
AND
real application testing options sql> show parameter undo;NAME type value
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean false undo_management string auto undo_retention integer 36000 undo_tablespace string undotbs1 sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS1';no rows selected sql>SELECT NAME
FROM v$tablespace
WHERE NAME='UNDOTBS';NAME
------------------------------
undotbs
Re: UNDO TABLESPACE [message #668652 is a reply to message #668651] Wed, 07 March 2018 14:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is not formatted as you can see yourself.
More it is unreadable.

Re: UNDO TABLESPACE [message #668665 is a reply to message #668651] Thu, 08 March 2018 03:20 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
daulat01 wrote on Wed, 07 March 2018 19:16
Yes I clicked the link and find below the output after formatting
You may have clicked it but it's very obvious that you either:
a) didn't read the page that link goes to (you may have read the first part of the first sentence - there are more words in that sentence plus other sentences, you are supposed to read them to).
b) didn't understand what was written there.

Neither option reflects well on someone who wants a career in almost anything.

So read the page that link goes to. Note the bits that Littlefoot helpfully highlighted in red and try again.
Previous Topic: Reclaiming Space From Tables
Next Topic: Encryption options for Standard editions
Goto Forum:
  


Current Time: Thu Mar 28 07:32:09 CDT 2024