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: 396
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
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: 10625
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Use ORACLE_SID
or
a valid TNSNAMES.ORA entry to identify the instance.
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: 396
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.
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: 10625
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
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: 396
Registered: December 2009
Senior Member
Mahesh,

Sukriya...
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: 10625
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.

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: 396
Registered: December 2009
Senior Member
Fine Mahesh.......
Previous Topic: Restore Linux exp in Windows ora install
Next Topic: control file autobackup format changing
Goto Forum:
  


Current Time: Thu Sep 18 21:31:31 CDT 2014

Total time taken to generate the page: 0.10732 seconds