OraFAQ Forum: Backup & Recovery » How to see which database is currently taken backup in RMAN prompt

Home » RDBMS Server » Backup & Recovery » How to see which database is currently taken backup in RMAN prompt (oracle 9i & 10g)

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

How to see which database is currently taken backup in RMAN prompt [message #438299]

Thu, 07 January 2010 23:28

jajati_julu07
Messages: 1
Registered: January 2010
Location: delhi

Junior Member

Dear Expert,

can you tell me How to see which database is currently taken backup in RMAN prompt.

suppose in my oracle server more than 20 database is there, so how could i see which database is currently taken backup in rman prompt?

[MERGED by LF]

[Updated on: Fri, 08 January 2010 00:51] by Moderator

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438300 is a reply to message #438299]

Thu, 07 January 2010 23:32

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

This post should be in BACKUP & RECOVERY under RDBMS SERVER.
Don't you think so?

regards,
Delna

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438304 is a reply to message #438299]

Thu, 07 January 2010 23:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/m/438299/136107/#msg_438299
do NOT cross/multi-post

follow Posting Guidelines

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438305 is a reply to message #438300]

Thu, 07 January 2010 23:46

Frank
Messages: 7901
Registered: March 2000

Senior Member

delna.sexy wrote on Fri, 08 January 2010 06:32

This post should be in BACKUP & RECOVERY under RDBMS SERVER.
Don't you think so?

regards,
Delna

This should be judged by moderators, don't you think so?

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438306 is a reply to message #438305]

Thu, 07 January 2010 23:49

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Quote:

This should be judged by moderators, don't you think so?

regards,
Delna

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438328 is a reply to message #438299]

Fri, 08 January 2010 02:03

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No way, you cannot customize the prompt.

Regards
Michel

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438395 is a reply to message #438328]

Fri, 08 January 2010 10:39

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>so how could i see which database is currently taken backup in rman prompt?

I guess in RMAN prompt you can not see. If you want check from operating system or your backup logs or RMAN background process.

-Babu

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438422 is a reply to message #438299]

Fri, 08 January 2010 18:16

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

Senior Member
Account Moderator

>>so how could i see which database is currently taken backup in rman prompt?
"In" RMAN prompt or "from" RMAN prompt?
However you are connecting (interactive or script/log), you should see something like this

connected to target database: xxx (DBID=nnnnnnnn)

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438476 is a reply to message #438299]

Sat, 09 January 2010 12:39

ebrian
Messages: 2794
Registered: April 2006

Senior Member

That's why it's helpful to generate a log of the RMAN session and label the backup files appropriately. Therefore, you could use something like lsof and/or strace to see what files a process has open and is writing to.

Report message to a moderator

Re: How to see which database is currently taken backup in RMAN prompt [message #438477 is a reply to message #438299]

Sat, 09 January 2010 12:48

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

I would not check with rman.

I would create a script which runs through all your db's in oratab and check per database.

Or maybe oracle grid control can show you in one view.
(I never used it, so I might be totally wrong)

Report message to a moderator

Previous Topic:	Flashback Eight data retention
Next Topic:	Help using RMAN to do a simple backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 05 01:36:47 CST 2025