tag:blogger.com,1999:blog-20737409.post3492362801680987209..comments2016-05-16T17:40:49.553-07:00Comments on Jared Still's Ramblings: Cool but unknown RMAN featureJaredhttp://www.blogger.com/profile/09187267459019576469noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-20737409.post-39771861564889698822010-06-10T08:23:46.607-07:002010-06-10T08:23:46.607-07:00The script I posted is just the RMAN portion that ...The script I posted is just the RMAN portion that is executed by a script.<br />In our case the RMAN command line and RMAN script are generated dynamically , stuffed into a shell variable and then executed.Jaredhttps://www.blogger.com/profile/09187267459019576469noreply@blogger.comtag:blogger.com,1999:blog-20737409.post-46566499583796699562010-06-10T07:44:30.428-07:002010-06-10T07:44:30.428-07:00Thanks. I am not sure (no place to test) but there...Thanks. I am not sure (no place to test) but there could be a difference in the way rman behaves as it pertains to this, if you use shell to create the whole rman script OR create a cmdfile and pass it to rman executable. We use the latter. I have to find a test machine to test it.Amit Vermahttp://www.linkedin.com/in/amitoracledbanoreply@blogger.comtag:blogger.com,1999:blog-20737409.post-23833170395682057592010-06-07T11:01:11.296-07:002010-06-07T11:01:11.296-07:00Here is the template used to generate the RMAN com...Here is the template used to generate the RMAN commands, it should be enough to see how the RMAN commands are setup.<br /><br /><br /> #<br /> BACKUP $BACKUP_TYPE FORMAT "'${FORMAT_PREFIX}_db_${FORMAT_SUFFIX}'" DATABASE<br /> SQL "'ALTER SYSTEM ARCHIVE LOG CURRENT'"<br /> BACKUP FORMAT "'${FORMAT_PREFIX}_arch_${FORMAT_SUFFIX}'" ARCHIVELOG ALL NOT BACKED UP 2 TIMES<br /> DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt<br /> BACKUP FORMAT "'${FORMAT_PREFIX}_ctl_${FORMAT_SUFFIX}'" CURRENT CONTROLFILEJaredhttps://www.blogger.com/profile/09187267459019576469noreply@blogger.comtag:blogger.com,1999:blog-20737409.post-28784003997508383592010-06-07T07:11:01.997-07:002010-06-07T07:11:01.997-07:00Would you be able to post your script here? I move...Would you be able to post your script here? I moved my rman repository to a new server, updated all but one of the scripts and it failed. Looking at your post I would assume that it would continue the backup, but it didn't. May be it is a version issue.Amit Vermanoreply@blogger.comtag:blogger.com,1999:blog-20737409.post-71622630880389763492010-02-26T12:31:25.475-08:002010-02-26T12:31:25.475-08:00[...]Jared Still sheds some light on a cool but un...[...]Jared Still sheds some light on a cool but unknown RMAN feature. [...]Log Bufferhttp://www.pythian.com/news/about-log-buffernoreply@blogger.comtag:blogger.com,1999:blog-20737409.post-50864458099150221442010-02-19T11:17:42.254-08:002010-02-19T11:17:42.254-08:00I found out about this feature during a rather lar...I found out about this feature during a rather large outage that took down, among other servers, the RMAN catalog server. I expected every DB Backup to fail, but was gladly surprised to find that they hadn't. It was not fun to resync all the databases later, but we did not lose any backups... which during a major incident is a good thing.<br /><br />Also, I found out that controlfile autobackup is very important... the few DBs that didn't have it set to ON were a pain to recover.<br /><br />One interesting side note, TSM was actually of much help in locating the proper backups from where to restore the controlfiles. After that, recovery went smoothly.Voldyhttps://www.blogger.com/profile/15481531340477523095noreply@blogger.comtag:blogger.com,1999:blog-20737409.post-60452738293000616662010-02-19T11:10:25.223-08:002010-02-19T11:10:25.223-08:00Yes my worry exatcly - can controlfile catalogs - ...Yes my worry exatcly - can controlfile catalogs - for it is there that the go be synced with RMAN database catalogs?Howardhttps://www.blogger.com/profile/06417385670205912149noreply@blogger.comtag:blogger.com,1999:blog-20737409.post-72399441745951686802010-02-19T11:00:13.047-08:002010-02-19T11:00:13.047-08:00Doing a resync is fairly simple, just fix whatever...Doing a resync is fairly simple, just fix whatever issue is preventing the connection to the catalog. Subsequent backups will cause a resync.<br /><br />You could also connect manually to the catalog and the target via RMAN and and run the RESYNC CATALOG command.<br /><br />Regarding the default value for control_file_record_keep_time, I set that to 60 on production databases, or any database that I may have to someday recover.<br /><br />Another thing I think it a good idea to set: <br /><br />CONFIGURE CONTROLFILE AUTOBACKUP ON;<br /><br />This does somewhat simplify restoring a control file, though that topic could take a whole 'nuther (lengthy) blog entry.<br /><br />Keeping a record of your Database DBID's is probably a good idea. I do that, but haven't checked it lately to see if it needs updating.<br /><br />Thanks for the reminder. :)Jaredhttps://www.blogger.com/profile/09187267459019576469noreply@blogger.comtag:blogger.com,1999:blog-20737409.post-13687935978795841292010-02-19T10:36:00.723-08:002010-02-19T10:36:00.723-08:00We "discovered" that feature some time a...We "discovered" that feature some time ago, but were concerned about how to resync our backup catalog with the backups. What if we needed to restore to the date that it used the control file? Restoring via controlfile can be tricky. You must know your DBID. And another concern is that by default, the controlfile only keeps backups for 7 days; after seven days the controlfile entries are overwritten.Anonymoushttps://www.blogger.com/profile/13671264168151133387noreply@blogger.com