Home » RDBMS Server » Backup & Recovery » rman backup type (Oracle 10.2.0.3, SOLARIS)
rman backup type [message #416210] Fri, 31 July 2009 03:35 Go to next message
suresh.wst
Messages: 45
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 #416214 is a reply to message #416210] Fri, 31 July 2009 03:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this important?

Regards
Michel
Re: rman backup type [message #416285 is a reply to message #416214] Fri, 31 July 2009 08:14 Go to previous messageGo to next message
suresh.wst
Messages: 45
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 #416288 is a reply to message #416285] Fri, 31 July 2009 08:27 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, but how is it important it is a cold or hot bakcup?

Regards
Michel
Re: rman backup type [message #416294 is a reply to message #416285] Fri, 31 July 2009 08:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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 #416605 is a reply to message #416210] Mon, 03 August 2009 08:23 Go to previous messageGo to next message
replicated
Messages: 31
Registered: July 2009
Member
The only way is to check your scripts or the log files.
Re: rman backup type [message #419409 is a reply to message #416210] Fri, 21 August 2009 22:59 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 58558
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
Previous Topic: Can I Use These RMAN backups
Next Topic: Retrieve truncated data (merged)
Goto Forum:
  


Current Time: Fri Jul 25 04:26:47 CDT 2014

Total time taken to generate the page: 0.09083 seconds