Documents - Gebruikersbijdragen [nl]

http://www.lambiek.eu/wiki/api.php?action=feedcontributions&feedformat=atom&user=Lambiek Documents - Gebruikersbijdragen [nl] 2026-05-21T20:13:38Z Gebruikersbijdragen MediaWiki 1.27.4 http://www.lambiek.eu/wiki/index.php?title=Tienduizenden&diff=136 Tienduizenden 2016-03-03T10:37:43Z

<p>Lambiek: /* Punten */</p> <hr /> <div>= Tienduizenden =<br /> <br /> == Inleiding ==<br /> Tienduizenden is een dobbelspel waarbij de spelers tienduizend punten moeten behalen om te winnen.<br /> <br /> == Benodigdheden ==<br /> 5 dobbelstenen<br /> <br /> == Uitleg ==<br /> De speler die aan de beurt is neemt de 5 dobbelstenen en rolt ze op tafel. Er wordt gekeken of er een 1, een 5 of een set van drie gelijke stenen ligt. Deze stenen worden geteld volgens de puntentabel en apart gelegd. Vervolgens heeft de speler volgende keuze:<br /> <br /> * stoppen, de optelling van de worpen word bij het spelertotaal opgeteld. Hier geldt wel een minimale optelling van 350 punten;<br /> * doorgaan met de overige stenen. Hierbij geldt het risico dat bij de volgende worp geen geldige steen geworpen wordt.<br /> <br /> Indien er geen dobbelstenen meer apart te leggen zijn (dus geen 1, geen 5 en geen drietal) dan heeft de speler zijn ronde verspeeld en wordt het optelling niet bij het spelertotaal opgeteld. De volgende speler neemt de 5 dobbelstenen en start zijn/haar ronde.<br /> <br /> Indien alle dobbelstenen afgelegd zijn dan neemt dezelfde speler alle 5 de dobbelstenen weer in de hand en gaat door, net zolang totdat de speler stopt.<br /> <br /> '''Variant''': Er kan afgesproken worden dat een ronde die boven de 1.000 punten komt altijd bij het spelertotaal opgeteld word.<br /> <br /> De speler die als eerste meer dan 10.000 punten scoort wint het spel.<br /> <br /> == Punten ==<br /> {| class="wikitable" width="20%"<br /> ! Dobbelsteen || Punten<br /> |-<br /> | 1 || 100<br /> |-<br /> | 5 || 50<br /> |-<br /> | 3x1 || 1000<br /> |-<br /> | 3x2 || 200<br /> |-<br /> | 3x3 || 300<br /> |-<br /> | 3x4 || 400<br /> |-<br /> | 3x5 || 500<br /> |-<br /> | 3x6 || 600<br /> |-<br /> | 1+2+3+4+5+6 || 1500<br /> |}<br /> <br /> [[Category:Spellen|Tienduizenden]]<br /> [[Category:Dobbelspellen|Tienduizenden]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Categorie:Dobbelspellen&diff=135 Categorie:Dobbelspellen 2016-03-03T10:35:30Z

<p>Lambiek: Nieuwe pagina aangemaakt met '== Dobbelspellen == Deze category bevat de dobbelspellen die beschreven zijn in deze wiki Dobbelspellen'</p> <hr /> <div>== Dobbelspellen ==<br /> <br /> Deze category bevat de dobbelspellen die beschreven zijn in deze wiki<br /> <br /> [[Category:Spellen|Dobbelspellen]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Tienduizenden&diff=134 Tienduizenden 2016-03-03T10:32:08Z

<p>Lambiek: </p> <hr /> <div>= Tienduizenden =<br /> <br /> == Inleiding ==<br /> Tienduizenden is een dobbelspel waarbij de spelers tienduizend punten moeten behalen om te winnen.<br /> <br /> == Benodigdheden ==<br /> 5 dobbelstenen<br /> <br /> == Uitleg ==<br /> De speler die aan de beurt is neemt de 5 dobbelstenen en rolt ze op tafel. Er wordt gekeken of er een 1, een 5 of een set van drie gelijke stenen ligt. Deze stenen worden geteld volgens de puntentabel en apart gelegd. Vervolgens heeft de speler volgende keuze:<br /> <br /> * stoppen, de optelling van de worpen word bij het spelertotaal opgeteld. Hier geldt wel een minimale optelling van 350 punten;<br /> * doorgaan met de overige stenen. Hierbij geldt het risico dat bij de volgende worp geen geldige steen geworpen wordt.<br /> <br /> Indien er geen dobbelstenen meer apart te leggen zijn (dus geen 1, geen 5 en geen drietal) dan heeft de speler zijn ronde verspeeld en wordt het optelling niet bij het spelertotaal opgeteld. De volgende speler neemt de 5 dobbelstenen en start zijn/haar ronde.<br /> <br /> Indien alle dobbelstenen afgelegd zijn dan neemt dezelfde speler alle 5 de dobbelstenen weer in de hand en gaat door, net zolang totdat de speler stopt.<br /> <br /> '''Variant''': Er kan afgesproken worden dat een ronde die boven de 1.000 punten komt altijd bij het spelertotaal opgeteld word.<br /> <br /> De speler die als eerste meer dan 10.000 punten scoort wint het spel.<br /> <br /> == Punten ==<br /> {| class="wikitable" width="20%"<br /> ! Dobbelsteen || Punten<br /> |-<br /> | 1 || 100<br /> |-<br /> | 5 || 50<br /> |-<br /> | 3x1 || 1000<br /> |-<br /> | 3x2 || 200<br /> |-<br /> | 3x3 || 300<br /> |-<br /> | 3x4 || 400<br /> |-<br /> | 3x5 || 500<br /> |-<br /> | 3x6 || 600<br /> |}<br /> <br /> [[Category:Spellen|Tienduizenden]]<br /> [[Category:Dobbelspellen|Tienduizenden]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Tienduizenden&diff=133 Tienduizenden 2016-03-03T10:31:31Z

<p>Lambiek: </p> <hr /> <div>= Tienduizenden =<br /> <br /> == Inleiding ==<br /> Tienduizenden is een dobbelspel waarbij de spelers tienduizend punten moeten behalen om te winnen.<br /> <br /> == Benodigdheden ==<br /> 5 dobbelstenen<br /> <br /> == Uitleg ==<br /> De speler die aan de beurt is neemt de 5 dobbelstenen en rolt ze op tafel. Er wordt gekeken of er een 1, een 5 of een set van drie gelijke stenen ligt. Deze stenen worden geteld volgens de puntentabel en apart gelegd. Vervolgens heeft de speler volgende keuze:<br /> <br /> * stoppen, de optelling van de worpen word bij het spelertotaal opgeteld. Hier geldt wel een minimale optelling van 350 punten;<br /> * doorgaan met de overige stenen. Hierbij geldt het risico dat bij de volgende worp geen geldige steen geworpen wordt.<br /> <br /> Indien er geen dobbelstenen meer apart te leggen zijn (dus geen 1, geen 5 en geen drietal) dan heeft de speler zijn ronde verspeeld en wordt het optelling niet bij het spelertotaal opgeteld.<br /> <br /> Indien alle dobbelstenen afgelegd zijn dan neemt dezelfde speler alle 5 de dobbelstenen weer in de hand en gaat door, net zolang totdat de speler stopt.<br /> <br /> '''Variant''': Er kan afgesproken worden dat een ronde die boven de 1.000 punten komt altijd bij het spelertotaal opgeteld word.<br /> <br /> De speler die als eerste meer dan 10.000 punten scoort wint het spel.<br /> <br /> == Punten ==<br /> {| class="wikitable" width="20%"<br /> ! Dobbelsteen || Punten<br /> |-<br /> | 1 || 100<br /> |-<br /> | 5 || 50<br /> |-<br /> | 3x1 || 1000<br /> |-<br /> | 3x2 || 200<br /> |-<br /> | 3x3 || 300<br /> |-<br /> | 3x4 || 400<br /> |-<br /> | 3x5 || 500<br /> |-<br /> | 3x6 || 600<br /> |}<br /> <br /> [[Category:Spellen|Tienduizenden]]<br /> [[Category:Dobbelspellen|Tienduizenden]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Tienduizenden&diff=132 Tienduizenden 2016-03-03T10:31:02Z

<p>Lambiek: Nieuwe pagina aangemaakt met '= Tienduizenden = == Inleiding == Tienduizenden is een dobbelspel waarbij de spelers tienduizend punten moeten behalen om te winnen. == Benodigdheden == 5 dobbels...'</p> <hr /> <div>= Tienduizenden =<br /> <br /> == Inleiding ==<br /> Tienduizenden is een dobbelspel waarbij de spelers tienduizend punten moeten behalen om te winnen.<br /> <br /> == Benodigdheden ==<br /> 5 dobbelstenen<br /> <br /> == Uitleg ==<br /> De speler die aan de beurt is neemt de 5 dobbelstenen en rolt ze op tafel. Er wordt gekeken of er een 1, een 5 of een set van drie gelijke stenen ligt. Deze stenen worden geteld volgens de puntentabel en apart gelegd. Vervolgens heeft de speler volgende keuze:<br /> <br /> * stoppen, de optelling van de worpen word bij het spelertotaal opgeteld. Hier geldt wel een minimale optelling van 350 punten;<br /> * doorgaan met de overige stenen. Hierbij geldt het risico dat bij de volgende worp geen geldige steen geworpen wordt.<br /> <br /> Indien er geen dobbelstenen meer apart te leggen zijn (dus geen 1, geen 5 en geen drietal) dan heeft de speler zijn ronde verspeeld en wordt het optelling niet bij het spelertotaal opgeteld.<br /> <br /> Indien alle dobbelstenen afgelegd zijn dan neemt dezelfde speler alle 5 de dobbelstenen weer in de hand en gaat door, net zolang totdat de speler stopt.<br /> <br /> '''Variant''': Er kan afgesproken worden dat een ronde die boven de 1.000 komt altijd bij het spelertotaal opgeteld word.<br /> <br /> De speler die als eerste meer dan 10.000 punten scoort wint het spel.<br /> <br /> == Punten ==<br /> {| class="wikitable" width="20%"<br /> ! Dobbelsteen || Punten<br /> |-<br /> | 1 || 100<br /> |-<br /> | 5 || 50<br /> |-<br /> | 3x1 || 1000<br /> |-<br /> | 3x2 || 200<br /> |-<br /> | 3x3 || 300<br /> |-<br /> | 3x4 || 400<br /> |-<br /> | 3x5 || 500<br /> |-<br /> | 3x6 || 600<br /> |}<br /> <br /> [[Category:Spellen|Tienduizenden]]<br /> [[Category:Dobbelspellen|Tienduizenden]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=EMC_CX3-80&diff=131 EMC CX3-80 2011-09-13T13:01:34Z

<p>Lambiek: /* Unable to unbind LUN */</p> <hr /> <div>== EMC CX3-80 Cheat sheet ==<br /> <br /> === Unable to unbind LUN ===<br /> If you get the following error while trying to unbind a LUN:<br /> <br /> <syntaxhighlight lang="bash"><br /> Error: unbind command failed<br /> Being used by a feature of the storage system. Cannot unbind LUN:<br /> </syntaxhighlight><br /> <br /> Use the following command to see what SAN feature locks a LUN from being removed:<br /> <br /> <syntaxhighlight lang="bash"><br /> /nas/sbin/navicli -h <hostname> getlun -messner <lunnumber> -stack<br /> </syntaxhighlight><br /> <br /> Use the following command to unlock a stalled remote mirror:<br /> <br /> <syntaxhighlight lang="bash"><br /> /nas/sbin/navicli -h <hostname> mirror -async -setfeature -off -LUN <lunnumber><br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=EMC_CX3-80&diff=130 EMC CX3-80 2011-09-13T13:01:17Z

<p>Lambiek: </p> <hr /> <div>== EMC CX3-80 Cheat sheet ==<br /> <br /> === Unable to unbind LUN ===<br /> If you get the following error while trying to unbind a LUN:<br /> <br /> <syntaxhighlight lang="bash"><br /> Error: unbind command failed<br /> Being used by a feature of the storage system. Cannot unbind LUN:<br /> </syntaxhighlight><br /> <br /> Use the following command to see what SAN feature locks a LUN from being removed:<br /> <br /> <syntaxhighlight lang="bash"><br /> /nas/sbin/navicli -h <hostname> getlun -messner <lunnumber> -stack<br /> </syntaxhighlight><br /> <br /> Use the following command to unlock a stalled remote mirror:<br /> <br /> <syntaxhighlight lang="bash"><br /> /nas/sbin/navicli -h 172.30.128.33 mirror -async -setfeature -off -LUN 1779<br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Netbackup&diff=129 Netbackup 2011-08-17T10:40:24Z

<p>Lambiek: </p> <hr /> <div>== Netbackup cheatsheet ==<br /> <br /> === Check Drive status ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/vmoprcmd -dp</syntaxhighlight><br /> And/Or<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/tpconfig -d</syntaxhighlight><br /> <br /> === Change Drive status ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/tpconfig -update -drive <index> -drstatus UP</syntaxhighlight><br /> <br /> === Scan bus ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/sgscan</syntaxhighlight><br /> <br /> === Add cleaning type ===<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/volmgr/bin/vmchange -p 0 -m <media> #change the pool to none<br /> /opt/openv/volmgr/bin/vmchange -new_mt hcart2_clean -m <media> #change the media type to HC2_CLN<br /> /opt/openv/volmgr/bin/vmchange -m <media> -n 50 #change number of remaining cleanings<br /> </syntaxhighlight><br /> <br /> === Expire backup images between dates ===<br /> <syntaxhighlight lang="bash"><br /> cd /opt/openv/netbackup<br /> for i in `./bin/admincmd/bpimagelist -d 03/07/2011 11:01:18 -e 03/08/2011 04:48:31 -L |grep "Backup ID" |cut -d ":" -f 2`; do ./bin/admincmd/bpexpdate -backupid $i -d 0 -force;done;<br /> </syntaxhighlight><br /> <br /> ; bpimagelist:<br /> : -d means from date<br /> : -e means till date<br /> : -L means long list<br /> <br /> Pipe output to filter out the backup ids<br /> <br /> Seperate the output to cut out the <backup id> from "Backup ID: <backup id>"<br /> <br /> ; bpexpdate:<br /> : -backupid specify backupid<br /> : -d sets expirydate, 0 means immediate<br /> : -force: don't ask user to confirm<br /> <br /> <br /> === List files in a backup ===<br /> Get the list of backups in the catalog specified by a policy:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpcatlist -policy <policy><br /> </syntaxhighlight><br /> <br /> Query the file list specified by client and backupid:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpflist -client <client> -rl 10 -backupid <backupid><br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Netbackup&diff=128 Netbackup 2011-08-17T08:50:30Z

<p>Lambiek: /* Check Drive status */</p> <hr /> <div>== Netbackup cheatsheet ==<br /> <br /> === Check Drive status ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/vmoprcmd -dp</syntaxhighlight><br /> And/Or<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/tpconfig -d</syntaxhighlight><br /> <br /> === Scan bus ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/sgscan</syntaxhighlight><br /> <br /> === Add cleaning type ===<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/volmgr/bin/vmchange -p 0 -m <media> #change the pool to none<br /> /opt/openv/volmgr/bin/vmchange -new_mt hcart2_clean -m <media> #change the media type to HC2_CLN<br /> /opt/openv/volmgr/bin/vmchange -m <media> -n 50 #change number of remaining cleanings<br /> </syntaxhighlight><br /> <br /> === Expire backup images between dates ===<br /> <syntaxhighlight lang="bash"><br /> cd /opt/openv/netbackup<br /> for i in `./bin/admincmd/bpimagelist -d 03/07/2011 11:01:18 -e 03/08/2011 04:48:31 -L |grep "Backup ID" |cut -d ":" -f 2`; do ./bin/admincmd/bpexpdate -backupid $i -d 0 -force;done;<br /> </syntaxhighlight><br /> <br /> ; bpimagelist:<br /> : -d means from date<br /> : -e means till date<br /> : -L means long list<br /> <br /> Pipe output to filter out the backup ids<br /> <br /> Seperate the output to cut out the <backup id> from "Backup ID: <backup id>"<br /> <br /> ; bpexpdate:<br /> : -backupid specify backupid<br /> : -d sets expirydate, 0 means immediate<br /> : -force: don't ask user to confirm<br /> <br /> <br /> === List files in a backup ===<br /> Get the list of backups in the catalog specified by a policy:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpcatlist -policy <policy><br /> </syntaxhighlight><br /> <br /> Query the file list specified by client and backupid:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpflist -client <client> -rl 10 -backupid <backupid><br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=127 Oracle 2011-08-12T07:18:24Z

<p>Lambiek: /* Standby database */</p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> Make backup of control file from SQL prompt<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> ALTER DATABASE BACKUP CONTROLFILE TO '<location>';<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == Standby database ==<br /> === Start standby database ===<br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> SQL> alter database mount standby database;<br /> SQL> alter database recover managed standby database disconnect from session;<br /> </syntaxhighlight><br /> <br /> === Stop standby database ===<br /> <syntaxhighlight lang="sql"><br /> SQL> alter database recover managed standby database cancel;<br /> SQL> shutdown immediate;<br /> </syntaxhighlight><br /> <br /> === Determine if database is standby ===<br /> <syntaxhighlight lang="sql"><br /> select CONTROLFILE_TYPE from v$database;<br /> </syntaxhighlight><br /> <br /> === Manually register a logfile ===<br /> It is sometimes necessary to manually add a logfile if one misses the transport or so.<br /> <syntaxhighlight lang="sql"><br /> alter database register logfile '/full_path_to/logfile';<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /><br /> <br /> == Links ==<br /> === Backup ===<br /> * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Oracle - Recovery Manager Maintenance Tasks]<br /> * [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm Oracle - RMAN Restore]<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm Oracle - Creating a Standby Database with Recovery Manager]<br /> * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]<br /> * [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files]<br /> === Standby database ===<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm Oracle - Managing a Physical Standby Database]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=126 Oracle 2011-08-09T10:10:28Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> Make backup of control file from SQL prompt<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> ALTER DATABASE BACKUP CONTROLFILE TO '<location>';<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == Standby database ==<br /> === Start standby database ===<br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> SQL> alter database mount standby database;<br /> SQL> alter database recover managed standby database disconnect from session;<br /> </syntaxhighlight><br /> <br /> === Stop standby database ===<br /> <syntaxhighlight lang="sql"><br /> SQL> alter database recover managed standby database cancel;<br /> SQL> shutdown immediate;<br /> </syntaxhighlight><br /> <br /> === Determine if database is standby ===<br /> <syntaxhighlight lang="sql"><br /> select CONTROLFILE_TYPE from v$database;<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /><br /> <br /> == Links ==<br /> === Backup ===<br /> * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Oracle - Recovery Manager Maintenance Tasks]<br /> * [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm Oracle - RMAN Restore]<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm Oracle - Creating a Standby Database with Recovery Manager]<br /> * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]<br /> * [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files]<br /> === Standby database ===<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm Oracle - Managing a Physical Standby Database]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=125 Oracle 2011-08-09T10:06:31Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> Make backup of control file from SQL prompt<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> ALTER DATABASE BACKUP CONTROLFILE TO '<location>';<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == Standby database ==<br /> Start standby database<br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> SQL> alter database mount standby database;<br /> SQL> alter database recover managed standby database disconnect from session;<br /> </syntaxhighlight><br /> <br /> Stop standby database<br /> <syntaxhighlight lang="sql"><br /> SQL> alter database recover managed standby database cancel;<br /> SQL> shutdown immediate;<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /><br /> <br /> == Links ==<br /> === Backup ===<br /> * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Oracle - Recovery Manager Maintenance Tasks]<br /> * [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm Oracle - RMAN Restore]<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm Oracle - Creating a Standby Database with Recovery Manager]<br /> * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]<br /> * [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files]<br /> === Standby database ===<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm Oracle - Managing a Physical Standby Database]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=124 Oracle 2011-08-09T09:19:59Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> Make backup of control file from SQL prompt<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> ALTER DATABASE BACKUP CONTROLFILE TO '<location>';<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /><br /> <br /> == Links ==<br /> * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Oracle - Recovery Manager Maintenance Tasks]<br /> * [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm Oracle - RMAN Restore]<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm Oracle - Creating a Standby Database with Recovery Manager]<br /> * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]<br /> * [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=123 Oracle 2011-08-09T09:18:56Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Make backup from SQL prompt ===<br /> <syntaxhighlight lang="sql"><br /> SQL> ALTER DATABASE BACKUP CONTROLFILE TO '<location>';<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /><br /> <br /> == Links ==<br /> * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Oracle - Recovery Manager Maintenance Tasks]<br /> * [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm Oracle - RMAN Restore]<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm Oracle - Creating a Standby Database with Recovery Manager]<br /> * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]<br /> * [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=122 Oracle 2011-08-09T09:14:22Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /><br /> <br /> == Links ==<br /> * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Oracle - Recovery Manager Maintenance Tasks]<br /> * [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm Oracle - RMAN Restore]<br /> * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm Oracle - Creating a Standby Database with Recovery Manager]<br /> * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=121 Oracle 2011-08-09T09:11:17Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /><br /> * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Recovery Manager Maintenance Tasks]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=120 Oracle 2011-08-09T09:04:13Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Manually add backup files to catalog ===<br /> <syntaxhighlight lang="sql"><br /> CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=119 Oracle 2011-08-09T09:00:13Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> === Make disk backup ===<br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';<br /> BACKUP DATABASE PLUS ARCHIVELOG;<br /> RELEASE CHANNEL d2;<br /> RELEASE CHANNEL d1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';<br /> BACKUP CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL d1;<br /> }<br /> </syntaxhighlight><br /> <br /> === Restore disk backup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> SQL> startup nomount;<br /> RMAN> RESTORE CONTROLFILE FROM '<location>';<br /> SQL> alter database mount;<br /> RMAN> RESTORE DATABASE;<br /> </syntaxhighlight><br /> <br /> === Make backup using Netbackup ===<br /> <br /> <syntaxhighlight lang="sql"><br /> rman target /(@sid) NOCATALOG<br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;<br /> RELEASE CHANNEL t1;<br /> }<br /> <br /> RUN {<br /> ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";<br /> BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);<br /> RELEASE CHANNEL t1;<br /> }<br /> </syntaxhighlight><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Netbackup&diff=118 Netbackup 2011-06-01T08:39:33Z

<p>Lambiek: </p> <hr /> <div>== Netbackup cheatsheet ==<br /> <br /> === Check Drive status ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/vmoprcmd -dp</syntaxhighlight><br /> <br /> === Scan bus ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/sgscan</syntaxhighlight><br /> <br /> === Add cleaning type ===<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/volmgr/bin/vmchange -p 0 -m <media> #change the pool to none<br /> /opt/openv/volmgr/bin/vmchange -new_mt hcart2_clean -m <media> #change the media type to HC2_CLN<br /> /opt/openv/volmgr/bin/vmchange -m <media> -n 50 #change number of remaining cleanings<br /> </syntaxhighlight><br /> <br /> === Expire backup images between dates ===<br /> <syntaxhighlight lang="bash"><br /> cd /opt/openv/netbackup<br /> for i in `./bin/admincmd/bpimagelist -d 03/07/2011 11:01:18 -e 03/08/2011 04:48:31 -L |grep "Backup ID" |cut -d ":" -f 2`; do ./bin/admincmd/bpexpdate -backupid $i -d 0 -force;done;<br /> </syntaxhighlight><br /> <br /> ; bpimagelist:<br /> : -d means from date<br /> : -e means till date<br /> : -L means long list<br /> <br /> Pipe output to filter out the backup ids<br /> <br /> Seperate the output to cut out the <backup id> from "Backup ID: <backup id>"<br /> <br /> ; bpexpdate:<br /> : -backupid specify backupid<br /> : -d sets expirydate, 0 means immediate<br /> : -force: don't ask user to confirm<br /> <br /> <br /> === List files in a backup ===<br /> Get the list of backups in the catalog specified by a policy:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpcatlist -policy <policy><br /> </syntaxhighlight><br /> <br /> Query the file list specified by client and backupid:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpflist -client <client> -rl 10 -backupid <backupid><br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Netbackup&diff=117 Netbackup 2011-06-01T08:38:11Z

<p>Lambiek: </p> <hr /> <div>== Netbackup cheatsheet ==<br /> <br /> === Check Drive status ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/vmoprcmd -dp</syntaxhighlight><br /> <br /> === Scan bus ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/sgscan</syntaxhighlight><br /> <br /> === Add cleaning type ===<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/volmgr/bin/vmchange -p 0 -m <media> #change the pool to none<br /> /opt/openv/volmgr/bin/vmchange -new_mt hcart2_clean -m <media> #change the media type to HC2_CLN<br /> /opt/openv/volmgr/bin/vmchange -m <media> -n 50 #change number of remaining cleanings<br /> </syntaxhighlight><br /> <br /> === Expire backup images between dates ===<br /> <syntaxhighlight lang="bash"><br /> cd /opt/openv/netbackup<br /> for i in `./bin/admincmd/bpimagelist -d 03/07/2011 11:01:18 -e 03/08/2011 04:48:31 -L |grep "Backup ID" |cut -d ":" -f 2`; do ./bin/admincmd/bpexpdate -backupid $i -d 0 -force;done;<br /> </syntaxhighlight><br /> <br /> ; bpimagelist:<br /> : -d means from date<br /> : -e means till date<br /> : -L means long list<br /> <br /> Pipe output to filter out the backup ids<br /> <br /> Seperate the output to cut out the <backup id> from "Backup ID: <backup id>"<br /> <br /> ; bpexpdate:<br /> : -backupid specify backupid<br /> : -d sets expirydate, 0 means immediate<br /> : -force: don't ask user to confirm<br /> <br /> <br /> === List files in a backup ===<br /> Get the list of backups in the catalog specified by a policy:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpcatlist -policy <policy><br /> </syntaxhighlight><br /> <br /> <syntaxhighlight lang="bash"><br /> /opt/openv/netbackup/bin/admincmd/bpflist -client <client> -rl 10 -backupid <backupid><br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=116 Oracle 2011-04-01T19:20:00Z

<p>Lambiek: </p> <hr /> <div>== Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=115 Oracle 2011-04-01T19:19:21Z

<p>Lambiek: </p> <hr /> <div>= Oracle =<br /> <br /> == Startup / Shutdown ==<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> == RMAN ==<br /> <br /> === Segmentation Fault while running sbttest ===<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=114 Oracle 2011-04-01T18:48:20Z

<p>Lambiek: </p> <hr /> <div>== Oracle ==<br /> <br /> === Startup / Shutdown ===<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> === RMAN ===<br /> <br /> ==== Segmentation Fault while running sbttest ====<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=113 Oracle 2011-04-01T18:47:39Z

<p>Lambiek: </p> <hr /> <div>== Oracle ==<br /> <br /> === Startup / Shutdown ===<br /> <br /> Login to SQL prompt:<br /> <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight><br /> <br /> Startup normally<br /> <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight><br /> <br /> Startup without actually mounting<br /> <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight><br /> <br /> Use additional initialization file:<br /> <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight><br /> <br /> Shutdown:<br /> <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight><br /> <br /> Shutdown and terminate existing connections<br /> <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight><br /> <br /> Shutdown and abort everything (last resort):<br /> <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight><br /> <br /> === RMAN ===<br /> <br /> ==== Segmentation Fault while restoring ====<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=112 Oracle 2011-04-01T18:44:41Z

<p>Lambiek: </p> <hr /> <div>== Oracle ==<br /> <br /> === Startup / Shutdown ===<br /> <br /> Login to SQL prompt: sqlplus / as sysdba<br /> <br /> Startup normally<br /> SQL> startup<br /> <br /> Startup without actually mounting<br /> SQL> startup nomount<br /> <br /> Use additional initialization file:<br /> SQL> startup nomount pfile='/path/to/init.ora'<br /> <br /> Shutdown:<br /> SQL> shutdown<br /> <br /> Shutdown and terminate existing connections<br /> SQL> shutdown immediate;<br /> <br /> Shutdown and abort everything (last resort):<br /> SQL> shutdown abort;<br /> <br /> === RMAN ===<br /> <br /> ==== Segmentation Fault while restoring ====<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=111 Oracle 2011-04-01T18:40:22Z

<p>Lambiek: </p> <hr /> <div>== Oracle ==<br /> <br /> === RMAN ===<br /> <br /> ==== Segmentation Fault while restoring ====<br /> <br /> Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == References ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=110 Oracle 2011-04-01T18:38:03Z

<p>Lambiek: </p> <hr /> <div>== Oracle ==<br /> <br /> === RMAN ===<br /> <br /> ==== Segmentation Fault while restoring ====<br /> <br /> http://www.symantec.com/business/support/index?page=content&id=TECH57313<ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == Referenties ==<br /> <references /></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=109 Oracle 2011-04-01T18:36:45Z

<p>Lambiek: </p> <hr /> <div>== Oracle ==<br /> <br /> === RMAN ===<br /> <br /> ==== Segmentation Fault while restoring ====<br /> <br /> <ref>http://www.symantec.com/business/support/index?page=content&id=TECH57313</ref><br /> <br /> == Referenties ==<br /> {{Reflist|3}}</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Oracle&diff=108 Oracle 2011-04-01T18:35:00Z

<p>Lambiek: Nieuwe pagina aangemaakt met '== Oracle == === RMAN === ==== Segmentation Fault while restoring ==== http://www.symantec.com/business/support/index?page=content&id=TECH57313'</p> <hr /> <div>== Oracle ==<br /> <br /> === RMAN ===<br /> <br /> ==== Segmentation Fault while restoring ====<br /> <br /> http://www.symantec.com/business/support/index?page=content&id=TECH57313</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=EMC_CX3-80&diff=107 EMC CX3-80 2011-03-31T06:26:32Z

<p>Lambiek: </p> <hr /> <div>== EMC CX3-80 Cheat sheet ==<br /> <br /> === Unable to unbind LUN ===<br /> If you get the following error while trying to unbind a LUN:<br /> <br /> <syntaxhighlight lang="bash"><br /> Error: unbind command failed<br /> Being used by a feature of the storage system. Cannot unbind LUN:<br /> </syntaxhighlight><br /> <br /> Use the following command to see what SAN feature locks a LUN from being removed:<br /> <br /> <syntaxhighlight lang="bash"><br /> /nas/sbin/navicli -h <hostname> getlun -messner <lunnumber> -stack<br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=EMC_CX3-80&diff=106 EMC CX3-80 2011-03-31T06:23:31Z

<p>Lambiek: Nieuwe pagina aangemaakt met 'EMC CX3-80 Cheat sheet If you get the following error while trying to unbind a LUN: Error: unbind command failed Being used by a feature of the storage system. Canno...'</p> <hr /> <div>EMC CX3-80 Cheat sheet<br /> <br /> If you get the following error while trying to unbind a LUN:<br /> <br /> Error: unbind command failed<br /> Being used by a feature of the storage system. Cannot unbind LUN:<br /> <br /> Use the following command to see what SAN feature locks a LUN from being removed:<br /> <br /> /nas/sbin/navicli -h <hostname> getlun -messner <lunnumber> -stack</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Netbackup&diff=105 Netbackup 2011-03-08T14:57:52Z

<p>Lambiek: </p> <hr /> <div>== Netbackup cheatsheet ==<br /> <br /> === Check Drive status ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/vmoprcmd -dp</syntaxhighlight><br /> <br /> === Scan bus ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/sgscan</syntaxhighlight><br /> <br /> === Add cleaning type ===<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/volmgr/bin/vmchange -p 0 -m <media> #change the pool to none<br /> /opt/openv/volmgr/bin/vmchange -new_mt hcart2_clean -m <media> #change the media type to HC2_CLN<br /> /opt/openv/volmgr/bin/vmchange -m <media> -n 50 #change number of remaining cleanings<br /> </syntaxhighlight><br /> <br /> === Expire backup images between dates ===<br /> <syntaxhighlight lang="bash"><br /> cd /opt/openv/netbackup<br /> for i in `./bin/admincmd/bpimagelist -d 03/07/2011 11:01:18 -e 03/08/2011 04:48:31 -L |grep "Backup ID" |cut -d ":" -f 2`; do ./bin/admincmd/bpexpdate -backupid $i -d 0 -force;done;<br /> </syntaxhighlight><br /> <br /> ; bpimagelist:<br /> : -d means from date<br /> : -e means till date<br /> : -L means long list<br /> <br /> Pipe output to filter out the backup ids<br /> <br /> Seperate the output to cut out the <backup id> from "Backup ID: <backup id>"<br /> <br /> ; bpexpdate:<br /> : -backupid specify backupid<br /> : -d sets expirydate, 0 means immediate<br /> : -force: don't ask user to confirm</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Netbackup&diff=104 Netbackup 2011-03-08T10:35:37Z

<p>Lambiek: </p> <hr /> <div>== Netbackup cheatsheet ==<br /> <br /> === Check Drive status: ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/vmoprcmd -dp</syntaxhighlight><br /> <br /> === Scan bus: ===<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/sgscan</syntaxhighlight><br /> <br /> === Add cleaning type: ===<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/volmgr/bin/vmchange -p 0 -m <media> #change the pool to none<br /> /opt/openv/volmgr/bin/vmchange -new_mt hcart2_clean -m <media> #change the media type to HC2_CLN<br /> /opt/openv/volmgr/bin/vmchange -m <media> -n 50 #change number of remaining cleanings<br /> </syntaxhighlight><br /> <br /> === Expire backup images between dates: ===<br /> <syntaxhighlight lang="bash"><br /> cd /opt/openv/netbackup<br /> for i in `./bin/admincmd/bpimagelist -d 03/07/2011 11:01:18 -e 03/08/2011 04:48:31 -L |grep "Backup ID" |cut -d ":" -f 2`; do ./bin/admincmd/bpexpdate -backupid $i -d 0 -force;done;<br /> <br /> bpimagelist:<br /> -d means from date<br /> -e means till date<br /> -L means long list<br /> <br /> pipe output to filter out the backup ids<br /> seperate the output to cut out the <backup id> from "Backup ID: <backup id>"<br /> <br /> bpexpdate:<br /> -backupid specify backupid<br /> -d sets expirydate, 0 means immediate<br /> -force: don't ask user to confirm<br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Netbackup&diff=103 Netbackup 2011-03-08T10:28:02Z

<p>Lambiek: </p> <hr /> <div>== Netbackup cheatsheet ==<br /> <br /> Check Drive status:<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/vmoprcmd -dp</syntaxhighlight><br /> Scan bus:<br /> <syntaxhighlight lang="bash">/opt/openv/volmgr/bin/sgscan</syntaxhighlight><br /> <br /> Add cleaning type:<br /> <syntaxhighlight lang="bash"><br /> /opt/openv/volmgr/bin/vmchange -p 0 -m <media> #change the pool to none<br /> /opt/openv/volmgr/bin/vmchange -new_mt hcart2_clean -m <media> #change the media type to HC2_CLN<br /> /opt/openv/volmgr/bin/vmchange -m <media> -n 50 #change number of remaining cleanings<br /> </syntaxhighlight><br /> <br /> Expire backup images:<br /> <syntaxhighlight lang="bash"><br /> cd /opt/openv/netbackup<br /> for i in `./bin/admincmd/bpimagelist -d 03/07/2011 11:01:18 -e 03/08/2011 04:48:31 -L |grep "Backup ID" |cut -d ":" -f 2`; do ./bin/admincmd/bpexpdate -backupid $i -d 0 -force;done;<br /> </syntaxhighlight></div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=102 Disable nagios messages logging 2011-02-17T07:14:41Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> To disable the inetd (daemon.notice) log messages do the following:<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> For the nrpe (mail.info) messages I don't have a solution for local zones yet.<br /> <br /> == Remarks ==<br /> <br /> It seems that the nrpe [ID 927837 mail.info] messages still appears in local zones. The nrpe [ID 317013 daemon.notice] messages in the local zones can be prevented by setting tcp_wrappers to false in the local zone.<br /> <br /> [[Category:Howto|Nagios - Disable messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=101 Disable nagios messages logging 2011-02-16T16:22:54Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> == Remarks ==<br /> <br /> It seems that the nrpe [ID 927837 mail.info] messages still appears in local zones. The nrpe [ID 317013 daemon.notice] messages in the local zones can be prevented by setting tcp_wrappers to false in the local zone.<br /> <br /> [[Category:Howto|Nagios - Disable messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Categorie:Howto&diff=100 Categorie:Howto 2011-02-15T14:22:15Z

<p>Lambiek: </p> <hr /> <div>== Lijst van Howtos ==</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Categorie:Howto&diff=99 Categorie:Howto 2011-02-15T14:21:57Z

<p>Lambiek: Nieuwe pagina aangemaakt met '== List of Howtos =='</p> <hr /> <div>== List of Howtos ==</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=98 Disable nagios messages logging 2011-02-15T14:19:15Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto|Nagios - Disable messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=97 Disable nagios messages logging 2011-02-15T14:18:34Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[:Category:Howto|Nagios - Disable messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=96 Disable nagios messages logging 2011-02-15T14:13:19Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto|Nagios - Disable messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=95 Disable nagios messages logging 2011-02-15T14:13:03Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto|[Nagios - Disable messages logging]]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=94 Disable nagios messages logging 2011-02-15T14:12:21Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto|"Nagios - Disable messages logging"]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=93 Disable nagios messages logging 2011-02-15T14:11:50Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto|Nagios - Disable messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=92 Disable nagios messages logging 2011-02-15T14:11:36Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto,Nagios - Disable messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=90 Disable nagios messages logging 2011-02-15T14:10:52Z

<p>Lambiek: Nagios hernoemd naar Disable nagios messages logging: Betere titel</p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Nagios&diff=91 Nagios 2011-02-15T14:10:52Z

<p>Lambiek: Nagios hernoemd naar Disable nagios messages logging: Betere titel</p> <hr /> <div>#DOORVERWIJZING [[Disable nagios messages logging]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=89 Disable nagios messages logging 2011-02-15T14:02:52Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> </syntaxhighlight><br /> <br /> or<br /> <br /> <syntaxhighlight lang="bash"><br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> </syntaxhighlight><br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=88 Disable nagios messages logging 2011-02-15T14:02:24Z

<p>Lambiek: </p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> == Problem ==<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> == Symtoms ==<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> <br /> or<br /> <br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> <br /> == Resolution ==<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> <syntaxhighlight lang="bash"><br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> </syntaxhighlight><br /> <br /> [[Category:Howto]]</div>

Lambiek http://www.lambiek.eu/wiki/index.php?title=Disable_nagios_messages_logging&diff=87 Disable nagios messages logging 2011-02-15T14:01:07Z

<p>Lambiek: Nieuwe pagina aangemaakt met 'Disable deamon.notice logging: --Problem-- Nagios extensive logging into /var/adm/messages --Symtoms-- Logging is found in the /var/adm/messages as follows: Feb 10...'</p> <hr /> <div>Disable deamon.notice logging:<br /> <br /> --Problem--<br /> <br /> Nagios extensive logging into /var/adm/messages<br /> <br /> --Symtoms--<br /> Logging is found in the /var/adm/messages as follows:<br /> <br /> Feb 10 03:12:05 HOST inetd[2755]: [ID 317013 daemon.notice] nrpe[13059] from <ip address> 37236<br /> Feb 10 03:12:05 HOST nrpe[13059]: [ID 927837 mail.info] connect from <client fqdn><br /> <br /> or<br /> <br /> Feb 15 14:53:34 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8461] from <ip address> 42690<br /> Feb 15 14:53:35 HOST inetd[521]: [ID 317013 daemon.notice] nrpe[8472] from <ip address> 42692<br /> <br /> --Resolution--<br /> <br /> If nagios is under SMF (Service Management Facility) then disable the logging using:<br /> inetadm -m svc:/network/nrpe/tcp:default tcp_trace=FALSE<br /> svcadm refresh network/nrpe/tcp<br /> <br /> [[Category:Howto]]</div>

Lambiek