Amazon books

Wednesday, October 10, 2012

RMAN Backup to DISK and TAPE on same RUN block


This backup will do a disk and tape backup on same block using the TAG from disk backup:

run{
crosscheck archivelog all;
crosscheck backup;
backup
 device type disk incremental level 0
 format '+ORAPRD_RECO'
 database
 tag 'SEMANAL_ORAPRD';
backup device type sbt backupset from tag  'SEMANAL_ORAPRD';
backup device type disk current controlfile format '+ORAPRD_RECO';
backup device type sbt current controlfile format 'BKP_CTL_SEMANAL_ORAPRD_%U';
}

Best Regards,
Paulo Portugal

Create and Registering ACFS windows RAC


1-Create ACFS:

D:\ORACLE\11.2.0\grid\BIN\acfsformat.exe /b 4k \\.\asm-scripts-20


2-Register ACFS created:

D:\ORACLE\11.2.0\grid\BIN\acfsutil.exe registry /a /f \\.\asm-scripts-20 D:\ORACLE\ACFS\SCRIPTS


Best Regards,
Paulo Portugal

Change ACFS mount point! ACFSDISMOUNT ACFSMOUNTVOL and ACFSUTIL


The steps to change ACFS mount point that I used was:

--Dismount old mount point
--Dismount
D:\ORACLE\11.2.0\grid\BIN>acfsdismount D:\ORACLE\ACFS\SCRIPTS

--Mount in new directory (Create the new directory before this step)
D:\ORACLE\11.2.0\grid\BIN>acfsmountvol /v  D:\ORACLE\ACFS\ZSCRIPTS  asm-scripts-20
acfsmountvol: volume: asm-scripts-20, ponto de montagem: D:\ORACLE\ACFS\ZSCRIPTS
acfsmountvol: verificando o estado do volume
acfsmountvol: criando o ponto de montagem
acfsmountvol: Montado com sucesso D:\ORACLE\ACFS\ZSCRIPTS.

--Unregister old mount point and register new one using commands below:
acfsutil registry /d asm-scripts-20
acfsutil registry /a asm-scripts-20 D:\ORACLE\ACFS\ZSCRIPTS

OBS: /d (DELETE)  /a (ADD)

Best Regards,
Paulo Portugal

Wednesday, October 3, 2012

ORA-15505: cannot start workload capture because instance 1 encountered errors

When starting CAPTURE got this error:

SYS@dborig> BEGIN
dbms_workload_capture.start_capture(UNISTR('CAPTURE-dborig-20120908132124'), UNISTR('DATA_PUMP_DIR'), NULL, 'INCLUDE', FALSE);
END;  2    3 
  4  /
BEGIN
*
ERROR at line 1:
ORA-15505: cannot start workload capture because instance 1 encountered errors
while accessing directory "/u01/app/oracle/product/11.2.0/db_1/rdbms/log/"
ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 811
ORA-06512: at line 2

---SOLUTION:
Create a new DIRECTORY object in an empty directory on your file system.

Run dbms_workload_capture.start_capture again.

Best Regards,
Paulo Portugal

CELL-01514: Connect Error. Verify that Management Server is listening at the specified HTTP port: 8888.

Error when trying to run any command at CELLCLI prompt.

To fix that, check if your MS is running. Check error logs in /opt/oracle/cell/log/diag/asm/cell/trace/ms-odl.log file.

Restart your MS using commands below:


[root@cell1 init.d]# ./celld status
     rsStatus:               running
     msStatus:               running
     cellsrvStatus:          running
[root@cell1 init.d]# ./celld stop

Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
[root@cell1 init.d]# ./celld start

Starting the RS, CELLSRV, and MS services...
Getting the state of RS services...
 running
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Starting MS services...
The STARTUP of MS services was successful.
[root@cell1 init.d]# ./celld status
     rsStatus:               running
     msStatus:               running
     cellsrvStatus:          running
[root@cell1 init.d]#


Best Regards,
Paulo Portugal