Månedlig arkiv: March 2010

Recovery Manager tips

De fleste benytter Recovery Manager (rman) til å ta sikkerhetskopi av datafiler. Men rman kan også brukes til å flytte datafiler. Fordelen med det er at du har et godt sikkerhetsnett som beskytter deg og omgivelsen mot de store feilene. … Les videre

Publisert i Uncategorized | 1 kommentar

When is the correct time to upgrade Oracle?

I get the question from my customers every now and then if they do need to upgrade all their databases to the latest and greatest release. You have three options here: Upgrade as seldom as possible, upgrade as soon as … Les videre

Publisert i Uncategorized @en | Skriv en kommentar

Flash recovery area and ORA-19804

Have you seen the Oracle error messages ORA-19804, ORA-19809 or ORA-19815 a lot of times? Then you are not alone, welcome! The reason for this message is that your database have reached the logical, or in worst case physical limit … Les videre

Publisert i Uncategorized @en | Skriv en kommentar

Make life easier with rlwrap

One of my favourite program is rlwrap. This program could be used as a «wrapper» for other programs where I wish to use the arrows keys for easy editing of text in the same way you may have seen while … Les videre

Publisert i Uncategorized @en | Skriv en kommentar

Prompt in SQL*Plus

Are you also using SQL*Plus when you work with Oracle? Well, I may have good news for you! The first thing I change when working in a new database environment is, of course, the SQL-prompt. The prompt could for instance … Les videre

Publisert i Uncategorized @en | Skriv en kommentar