Tag Info

Hot answers tagged

6

This assumes that you've already partitioned the presented disk(s) (and will be using /dev/sd[whatever]N), and that you're using asmlib. There will be a kernel module loaded if you are: [root@oel61 disks]# lsmod | grep oracle oracleasm 53865 1 [root@oel61 disks]# As root, scan for candidate disks: [root@oel61 ~]# /etc/init.d/oracleasm ...


3

The recommendation is to have log switches occur a few times an hour. If you have a 100 log switches an hour with 50MB redo logs, you need e.g 1GB redo logs for 5 log switches/hour. 100*50 MB redo/hour for a 6.5GB database is unusually much though. You can add the new logs, e.g: ALTER DATABASE ADD LOGFILE THREAD 1 SIZE 1G; ALTER DATABASE ADD LOGFILE THREAD ...


3

Just use asmcmd. For example: [oracle@oel61 ~]$ . oraenv ORACLE_SID = [+ASM] ? +ASM The Oracle base remains unchanged with value /u01/app/oracle [oracle@oel61 ~]$ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 ...


2

Without knowing what kernel you're running, I can't say for sure, but my guess is that you're running a recent UEK kernel, and it has the kernel module built in.


2

I found the solution. --------------------------------------To shutdown ----------shutdown database instance first $. oraenv >mydb1 >/u01/app/oracle/product/11.2.0/db_1 $sqlplus / as sysdba SQL> shutdown immediate; ---------stopping Oracle Clusterware, It will shutdown ASM instance itself $ su - # cd /u01/app/11.2.0/grid/bin/ # ./crsctl stop ...


2

KISS principle: Do you have the storage that itself offers you the required availability level (i.e. disk array)? And you do have RMAN backups with a recovery catalog (you need it anyway, for DUPLICATE), don't you? If yes and yes, my version is: no secondary control file at all, one member per each redo group, as there are no secondary datafiles (quite ...


2

DISCLAIMER : Not an Oracle DBA Use srvctl, the grid control program that allows you to manipulate parts of the RAC Cluster Usage: srvctl <command> <object> [<options>] commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config objects: ...


1

Transportable tablespaces and asmcmd cp command should do the trick. Prepare transportable tablespaces metadata set. Copy expdp file to location accessible by impdp from destination database. asmcmd cp datafiles to new location. Import TT metadata set. If your ASM diskgroup uses some storage device with several disks then you should be able to improve ...


1

You can use RMAN for this. There is some documentation I suggest you read in order to accomplish this easy way: http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm


1

Use alter diskgroup mydiskgroup check all; or the remap command. But ASM should manage this for you; perhaps you need a higher redundancy setting on your JBODs,


1

This is a bug which is fixed in 11.2.0.3. Have a look at bug# 9897335. If you have a support contract, you can request a backport if it is feasible. In addition the error tell you which client it is waiting on. Further information can be retrieved from v$asm_client.



Only top voted, non community-wiki answers of a minimum length are eligible