OraFAQ Forum: Backup & Recovery » Selecting specific DB for RMAN and Export

Home » RDBMS Server » Backup & Recovery » Selecting specific DB for RMAN and Export (Oracle 9i.2, Windows. )

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

Selecting specific DB for RMAN and Export [message #476024]

Mon, 20 September 2010 13:59

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Need a small clarifications on below.

1) How to select a specific DB among many to perform RMAN?

2) And also for Exporting?

In the above both the case by default only one DB getting selected.

Thanks in advance

Report message to a moderator

Re: Selecting specific DB for RMAN and Export [message #476025 is a reply to message #476024]

Mon, 20 September 2010 14:02

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Use ORACLE_SID
or
a valid TNSNAMES.ORA entry to identify the instance.

Report message to a moderator

Re: Selecting specific DB for RMAN and Export [message #476028 is a reply to message #476025]

Mon, 20 September 2010 14:42

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Mahesh,

You mean:
RMAN TARGET/SYS password@DB Name.

please show me the syntax for Exporting also.

Thanks a lot Mahesh.

Report message to a moderator

Re: Selecting specific DB for RMAN and Export [message #476030 is a reply to message #476028]

Mon, 20 September 2010 14:46

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

#db is tns entry
exp user/pass@db

#db is ORACLE_SID
export ORACLE_SID=db
exp user/pass

Report message to a moderator

Re: Selecting specific DB for RMAN and Export [message #476033 is a reply to message #476030]

Mon, 20 September 2010 15:22

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Mahesh,

Sukriya...

Report message to a moderator

Re: Selecting specific DB for RMAN and Export [message #476034 is a reply to message #476033]

Mon, 20 September 2010 15:26

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please keep the conversation in English.
I myself can understand only a few words (including the one you have posted) in that language.

Report message to a moderator

Re: Selecting specific DB for RMAN and Export [message #476054 is a reply to message #476034]

Tue, 21 September 2010 02:50

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Fine Mahesh.......

Report message to a moderator

Previous Topic:	Restore Linux exp in Windows ora install
Next Topic:	control file autobackup format changing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 05:37:19 CDT 2024