OraFAQ Forum: Backup & Recovery » TRANSPORT TABLESPACE Command problem

Home » RDBMS Server » Backup & Recovery » TRANSPORT TABLESPACE Command problem (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TRANSPORT TABLESPACE Command problem [message #392261]

Tue, 17 March 2009 03:49

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

When I issue TRANSPORT TABLESPACE command like follows:

run
{
transport tablespace 'USERS'
Tablespace destination 'E:\oracle\trn\tts_rman'
Auxiliary destination 'E:\oracle\trn\aux_dest'
dump file 'trn.dmp'
import script 'imp.src'
export log 'exp.log';
}

I get an error like follows:

---------------------------------------------------------------
RMAN-01008: the bad identifier was: transport
---------------------------------------------------------------

Could anyone please tell me what the error is?

Report message to a moderator

Re: TRANSPORT TABLESPACE Command problem [message #392263 is a reply to message #392261]

Tue, 17 March 2009 03:52

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ALWAYS copy and paste your session.
ALWAYS post it formatted.
ALWAYS post your Oracle version with 4 decimals.

Regards
Michel

[Updated on: Tue, 17 March 2009 03:53]

Report message to a moderator

Re: TRANSPORT TABLESPACE Command problem [message #392264 is a reply to message #392263]

Tue, 17 March 2009 03:58

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

Thats ok.
Sorry for that.

But I am in a critical problem. Please suggest me why the TRANSPORT command is not working in RMAN?

Recovery Manager: Release 10.1.0.2.0 - Production

Report message to a moderator

Re: TRANSPORT TABLESPACE Command problem [message #392275 is a reply to message #392264]

Tue, 17 March 2009 04:44

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Michel Cadot wrote on Tue, 17 March 2009 09:52

ALWAYS copy and paste your session.
ALWAYS post it formatted.
ALWAYS post your Oracle version with 4 decimals.

Regards
Michel

You will get a faster answer if you post what we ask.
I don't diagnose without seeing the problem.

Regards
Michel

[Updated on: Tue, 17 March 2009 04:45]

Report message to a moderator

Re: TRANSPORT TABLESPACE Command problem [message #392872 is a reply to message #392261]

Thu, 19 March 2009 09:21

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

Hi,

I suggest you try this
transport tablespace USERS
instead of
transport tablespace 'USERS'

Regards,
Alex

[Updated on: Thu, 19 March 2009 09:46] by Moderator

Report message to a moderator

if online redolog file corupted [message #394724 is a reply to message #392261]

Sun, 29 March 2009 22:30

sivaram.t
Messages: 1
Registered: March 2009
Location: INDIA-Chennai

Junior Member

hi friends please explain me if online redolog file corupted?

Report message to a moderator

Re: TRANSPORT TABLESPACE Command problem [message #394725 is a reply to message #392261]

Sun, 29 March 2009 22:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

>hi friends please explain me if online redolog file corrupted?
I hope you have good backups along with documented & tested recovery procedure.

GOOGLE is your friend, but only when you use it.
Results 1 - 10 of about 19,900 for oracle corrupt redo log.

Please do NOT hijack old threads. Start your own next time.

Report message to a moderator

Previous Topic:	import problem
Next Topic:	Backing up rman backupsets to tape

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 23:32:34 CDT 2024