Home » RDBMS Server » Backup & Recovery » Selecting specific DB for RMAN and Export (Oracle 9i.2, Windows. )
Selecting specific DB for RMAN and Export [message #476024] Mon, 20 September 2010 13:59 Go to next message
muktha_22
Messages: 337
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10572
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 Go to previous messageGo to next message
muktha_22
Messages: 337
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10572
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 Go to previous messageGo to next message
muktha_22
Messages: 337
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10572
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 Go to previous message
muktha_22
Messages: 337
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 00:28:09 CDT 2013

Total time taken to generate the page: 0.16746 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.