Author: tonymu99

Written by tonymu99

PLS-00201: identifier ‘SYS.DBMS_EXPORT_EXTENSION’ must be declared

This error is due to the execute grant missing on DBMS_EXPORT_EXTENSION Error test*TESTDB1:/home/oracle>exp menu file=export.dmp tables=test_table1 log=export.log Export: Release 11.2.0.3.0 – Production on Thu May 24 10:46:42 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Password: EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 15: PLS-00201: identifier ‘SYS.DBMS_EXPORT_EXTENSION’ must be declared […]

Written by tonymu99

Put standby database into snapshot standby

So we are going to convert our physical standby database into a read-write real time clone of the primary database and we can then temporarily use this environment for carrying out DR testing. The Snapshot Standby database in turn uses the Flashback Database technology to create a guaranteed restore point to which the database can be later […]

Written by tonymu99

Add New ASM Diskgroup

The system i’ll be adding the disk on is a linux system using asmlib. Current Set-up In the current set-up we have 3 disks with 1 disk in the FLASH disk group and the 2 remaning disks in the DATA diskgroup SQL> select PATH, HEADER_STATUS, MODE_STATUS, STATE from v$asm_disk; PATH HEADER_STATU MODE_ST STATE ————— ———— […]

Written by tonymu99

Set-up Oracle Wallet Connection

Set-up the wallet location Create a directory where the wallet is going to be stored in my configuration its /u01/wallet/oracle mkdir /u01/wallet/oracle Create sqlnet.ora vi sqlnet.ora – add the following WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /u01/wallet/oracle) ) ) SQLNET.WALLET_OVERRIDE = TRUE SSL_CLIENT_AUTHENTICATION = FALSE SSL_VERSION = 0 Create tnsnames.ora […]

Written by tonymu99

Useful RMAN Commands

Show all of the RMAN parameters for the database RMAN> show all; Configure the disk channel to the format /backup/ora_df%t_s%s_s%p’ RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/backup/ora_df%t_s%s_s%p’; Configure the disk channel to the format +FLASHDG RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘+FLASHDG’; Backup the database using the standard RMAN parameters RMAN> backup database; […]

Written by tonymu99

ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”

Error in Alert log Errors in file /wload/test/app/oracle/diag/rdbms/TEST/TEST/trace/TEST_j000_7733378.trc: ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” ORA-06502: PL/SQL: numeric or value error ORA-06512: at “DBSNMP.BSLN_INTERNAL”, line 2073 ORA-06512: at line 1 Sat Mar 24 23:01:18 2012 Error from trace file *** 2012-03-24 23:00:13.943 *** SESSION ID:(23.6871) 2012-03-24 23:00:13.943 *** CLIENT ID:() 2012-03-24 23:00:13.943 *** SERVICE […]

Written by tonymu99

Using Guaranteed Restore Points for Primary and Failover

Steps to use Guaranteed Restore Points for backouts of database changes in a dataguard broker environment Failover Create the restore point on the failover databaase first, if there is addtional standby’s do the same on each standby SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; SQL>create restore point AT_test GUARANTEE FLASHBACK DATABASE; SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE […]

Written by tonymu99

Finding table name for lob segment

So i have a lob segment taking up lots of space so i need to find out the corresposding table for the lob. SYSTEM@TEST> select count(*) from dba_lobs where SEGMENT_NAME=’SYS_LOB0000068405C00008$$’; COUNT(*) ———- 1 Just need to query dba_lobs with the corresponding lob segment name. SYSTEM@TEST> select OWNER,TABLE_NAME from dba_lobs where SEGMENT_NAME=’SYS_LOB0000068405C00008$$’; OWNER           […]

Written by tonymu99

Flashback Dataguard Database

Steps to flashback the primary and stanby database to a point in time. Disable dataguard configuration dgmgrl show configuration – check no errors before starting this disable FAST_START FAILOVER; DISABLE CONFIGURATION; Primary srvctl stop database -d PTEST1 srvctl start database -d PTEST1 -o mount SQL>flashback database to timestamp to_timestamp(‘2011-02-17 14:00:00’, ‘YYYY-MM-DD HH24:MI:SS’) or restore point […]