Home » RDBMS Server » Backup & Recovery » How to see which database is currently taken backup in RMAN prompt (oracle 9i & 10g)
How to see which database is currently taken backup in RMAN prompt [message #438299] Thu, 07 January 2010 23:28 Go to next message
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25032
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.
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 Go to previous messageGo to next message
Frank
Messages: 7880
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?
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 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
./fa/1582/0/
Quote:
This should be judged by moderators, don't you think so?


Laughing

regards,
Delna
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way, you cannot customize the prompt.

Regards
Michel
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 Go to previous messageGo to next message
babuknb
Messages: 1734
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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)
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 Go to previous messageGo to next message
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.
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 Go to previous message
martijn
Messages: 283
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)
Previous Topic: Flashback Eight data retention
Next Topic: Help using RMAN to do a simple backup
Goto Forum:
  


Current Time: Fri Dec 02 12:22:40 CST 2016

Total time taken to generate the page: 0.24640 seconds