Hot answers tagged

8

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 ...


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

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 ...


3

du of asmcmd doesn't support this, just put it in a loop. $ dg=fra; for dir in $(asmcmd ls $dg); do echo $dg/$dir; asmcmd du $dg/$dir; done


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 ...


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

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 ...


2

Why not just create luns on the new storage, with same size as on old storage and add them to the existing disk groups. Next drop the old disks from the disk group and when the re-balance is over, your system is migrated to the new storage, without any downtime. Works like a charm. ASM is way smarter than a filesystem.


2

The Oracle docs for 11.2 ASM migration are here: http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm#OSTMG12000 These explain the process that you need to go through to migrate to ASM from filesystem storage.


2

No need to de-install Oracle rdbms software. Just install and configure ASM. If you have enough storage available you can copy your database to ASM using rman.


2

i've found the definitive answer from the oracle docs http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC109 in the Oracle Database Standard Edition and Oracle Real Application Clusters (Oracle RAC) section, it specifies "Oracle Automatic Storage Management is required for creating and managing all Oracle database file types. Raw ...


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: ...


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 ...


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.


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

You can use 12c ASM for 11g databases (even 10g), neither the MOS note nor the forum thread says you can not use it. As far as the table in the MOS is concerned, for 12c, just ignore the first column. Starting with 11.2, the clusterware and ASM come together integrated, called Grid Infrastructure, and not separately as in earlier releases, so they will ...


1

You won't need downtime just to add additional redo logs to your redo groups. Take a look at this: Oracle Configuration Best Practices And then look at this: Creating Redo Log Groups and Members You will need downtime to add additional control files: Creating Additional Copies, Renaming, and Relocating Control Files


1

Your permissions are incorrect. Oracle recommends role separation, which it appears you've followed by creating separate oracle and grid users. But I'm willing to wager that your ORACLE_HOME is under /u01/app/database or similar, which means that the chmod and chown commands you ran also changed permissions and ownership on the database home, too. This ...


1

Cause The security limits requirements were not set according the recommended values The message [client(15674)]CRS-10001:CRS-6021: No msg for has:crs-6021 [n][65536] makes think about the value recommended for oracle hard nofile 65536 in /etc/security/limits.conf Then these messages makes think that probably the other parameters in ...


1

In case one does not want to use AMM MEMORY_MAX_TARGET setting has to be not set at all: alter system reset memory_target; alter system reset memory_max_target;


1

Check if autostart for Oracle Restart is enabled: $ cat /etc/oracle/scls_scr/$HOSTNAME/oracle/ohasdstr enable If it is not enabled, then enable it: crsctl enable has Check if ASM autostart is enabled: crsctl stat res ora.asm If ASM is not registered in GI, add it with: srvctl add asm ... Check if used diskgroups are registered: srvctl status ...


1

ASM metadata describes the location of the password file on the ASM disk. With that information, even you can read it directly from the disk, with the help of kfed (which is installed with the Oracle binaries) and OS specific tools for reading the disk directly, for example dd, without using ASM. Same goes for the SPFILE (since 11g). More about this topic: ...


1

Just make sure auto controlfile backup is turned on. If you added or dropped a datafile(s) before the controlfile was backed up, and you had a hardware failure which resulted in the single CF not be accessible, it would be a pain to restore...not impossible, just a huge pain and a time sink during a sensitive time resuming services. Cheers, JD


1

First of all, I checked that there were no extents on DISK1. $ . oraenv ORACLE_SID = [+ASM1] ? SQL> select PXN_KFFXP, -- physical extent number XNUM_KFFXP, -- virtual extent number DISK_KFFXP, -- disk number AU_KFFXP -- allocation unit number from X$KFFXP where DISK_KFFXP=1; no rows selected I cleared the ...



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