| rman backup type [message #416210] |
Fri, 31 July 2009 03:35  |
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
|
Member |
|
|
Hi,
How to find whether the rman backup is hot backup (taken when database is running) or cold backup (taken when database is mount stage)? Can we find it using catalog views?
Thanks
Suresh
|
|
|
|
|
|
| Re: rman backup type [message #416285 is a reply to message #416214] |
Fri, 31 July 2009 08:14  |
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
|
Member |
|
|
Hi,
I need to prepare a report which needs the information of the RMAN backup. For that I need to mention which type of RMAN backup is(hot/cold).
Thanks
Suresh
|
|
|
|
|
|
| Re: rman backup type [message #416294 is a reply to message #416285] |
Fri, 31 July 2009 08:37 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
It is a standard practice to 'tag' the type of backup within the script to identify the backupsets.
Ofcourse, scripts will also have the info whether its is hot or cold backup.
Did you get a chance to check the scripts?
[Updated on: Fri, 31 July 2009 08:40] Report message to a moderator |
|
|
|
|
|
| Re: rman backup type [message #419409 is a reply to message #416210] |
Fri, 21 August 2009 22:59 |
purple73
Messages: 7
Registered: August 2009
|
Junior Member |
|
|
Not sure if this helps, but following is what I use to run across all my databases for the current status.
For cold backup you mount the database (right? I don't know; never used it), if so then the control file should contain the cold backup information. All you do is find the value for cold backup in backup_type of v$backup_set view and stick it in the following as another union statement. YMMV - cold backup comment is purely theory.
select backup_type, controlfile_included, incremental_level, start_time, completion_time ,
round(sysdate - completion_time) flag
from v$backup_set
where recid=(
select max(recid)
from v$backup_set
where start_time=(
select max(start_time)
from v$backup_set
where backup_type='D' and incremental_level=0))
union
select backup_type, controlfile_included, incremental_level, start_time, completion_time,
round(sysdate - completion_time) flag
from v$backup_set
where recid=(
select max(recid)
from v$backup_set
where start_time=(
select max(start_time)
from v$backup_set
where backup_type='I'))
union
select backup_type, controlfile_included, incremental_level, start_time, completion_time,
round(sysdate - completion_time) flag
from v$backup_set
where recid=(
select max(recid)
from v$backup_set
where start_time=(
select max(start_time)
from v$backup_set
where backup_type='L'));
[Updated on: Sat, 22 August 2009 00:57] by Moderator Report message to a moderator |
|
|
|
| Re: rman backup type [message #419421 is a reply to message #419409] |
Sat, 22 August 2009 00:58 |
 |
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Isn't your query now easier to read?
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
