Just another RMAN backup-script for Windows

By | May 16th, 2010|Categories: Database, RMAN|Tags: , |

I was asked to deliver a backup-script for a windows-database. However I'm not a o.s.-scripting guru at all and certainly not on Windows, I came to the following script. It looks a lot like the one I use on Linux, just translated it into a .cmd-file. The challenge was to get it in one-command file.

RMAN: restore database on another node including rename

By | October 18th, 2009|Categories: Database, RMAN|Tags: , |

Consider this, you've got no DataGuard at your disposal. Single node, relying on your RMAN-backup on disk, which is fortunately copied to tape. Now your complete node is burning down. What's is left is your RMAN-backup. In a bad scenario you'll have to restore this to another node.

Cloning / duplicating with RMAN, the basics

By | October 18th, 2009|Categories: Database, RMAN|Tags: , |

It is considered a skill every DBA should have, cloning / duplicating a database with RMAN. My own basic checklist through an example: Cloning of the DEVDB on the node LARRIE to node ELLISON, new database name DEVDBNEW

RMAN-06053 tijdens Point in Time Recovery

By | December 6th, 2008|Categories: RMAN|

Zo’n 6 keer uitgevoerd op een ontwikkel-database: restoren via rman naar een bepaalde tijd. 7e keer gaat het restore-gedeelte goed, recovery niet: RMAN-06053, missing log – terwijl die er toch echt is naar mijn bescheiden mening. Database versie 10.2.0.3 op Suse 9.

[…]

Backup database shell-script with RMAN

By | November 14th, 2008|Categories: RMAN|Tags: , |

A proper backup is the base for a well and relaxed administration of yout databases.What follows is a backup-script which I use for several customers. It's backing up all in the same directory and I tested the restore frequently.