Home » RDBMS Server » Backup & Recovery » transportable tablespace and standby database.
transportable tablespace and standby database. [message #275956] Tue, 23 October 2007 08:47 Go to next message
aline
Messages: 92
Registered: February 2002
Member
hello,
I'm trying to do an export with the transportable tablespace option on a standby database.
Do you have any idea against this problem?
 exp "'/ as sysdba'" file=exp_tts.dmp log=exp_tts.log transport_tablespace=y tablespaces=mytest

Export: Release 9.2.0.8.0 - Production on Mon Oct 22 18:12:15 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


EXP-00008: ORACLE error 1219 encountered
ORA-01219: database not open: queries allowed on fixed tables/views only
EXP-00000: Export terminated unsuccessfully
Re: transportable tablespace and standby database. [message #275962 is a reply to message #275956] Tue, 23 October 2007 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to open your standby in read only mode.

Regards
Michel
Re: transportable tablespace and standby database. [message #276002 is a reply to message #275962] Tue, 23 October 2007 11:07 Go to previous messageGo to next message
aline
Messages: 92
Registered: February 2002
Member
hello Michel,
thk for you answer.

You right but if I open my database in read only mode, I have another error.
I know than my tablespace in not in read only mode but my database is in this state!
So I hope it would be ok but unfortunately not Sad
 exp "'/ as sysdba'" file=exp_tts.dmp log=exp_tts.log transport_tablespace=y tablespaces=mytest
Export: Release 9.2.0.8.0 - Production on Tue Oct 23 18:01:55 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 29335 encountered
ORA-29335: tablespace 'MYTEST' is not read only
ORA-06512: at "SYS.DBMS_PLUGTS", line 436
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully



Of course, I tried to unsuccessfully:


SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> alter tablespace mytest read only;
alter tablespace mytest read only
                      *
ERROR at line 1:
ORA-16000: database open for read-only access

[Updated on: Tue, 23 October 2007 11:12]

Report message to a moderator

Re: transportable tablespace and standby database. [message #276007 is a reply to message #276002] Tue, 23 October 2007 11:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes in 9.2 you can transport a tablespace only if it is in read-only mode but you can put your tablespace in read-only mode only if your database is in read-write mode.
So you can't do it with a standby database unless you break the link with the primary (that is you open the standby in read write mode).

So there is no way to do what you wanted. You can only do it with an already read only tablespace (or if you upgrade to a newer version).

Regards
Michel
Re: transportable tablespace and standby database. [message #276009 is a reply to message #276007] Tue, 23 October 2007 11:44 Go to previous messageGo to next message
aline
Messages: 92
Registered: February 2002
Member
ok Michel, thk again, your answer is clever.

But you said this is possible in upper version. Do you know which one?
Re: transportable tablespace and standby database. [message #276011 is a reply to message #276009] Tue, 23 October 2007 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
10.2 using RMAN not with the current way which still requires putting the tablespace in read only mode.

Regards
Michel
Re: transportable tablespace and standby database. [message #276215 is a reply to message #276011] Wed, 24 October 2007 06:54 Go to previous message
aline
Messages: 92
Registered: February 2002
Member
ok,
thank again
Previous Topic: Rman Backup
Next Topic: Use of Reset Log option with alter database open Fails
Goto Forum:
  


Current Time: Tue Dec 06 02:25:56 CST 2016

Total time taken to generate the page: 0.13182 seconds