Dicas ORACLE DBA

Error: oracle@localhost$ /etc/init.d/oracleasm createdisk DISCO1 /dev/sdb1 Marking disk "/dev/sdb1" as an ASM disk: asmtool: Device "/dev/sdb1" is already labeled for ASM disk ""     [FAILED] oracle@localhost$ /etc/init.d/oracleasm deletedisk DISCO1 Removing ASM disk "DISCO1"                                 [FAILED] Solution: oracle@localhost$ dd if=/dev/zero of=/dev/sdb1 bs=1024 count=100 100+0 records in 100+0 records out oracle@localhost$ /etc/init.d/oracleasm createdisk DISCO1 /dev/sdb1 Marking disk "/dev/sdb1" as an ASM disk:                  [ OK ]

$sqlplus / as sysdba SQL> alter system set control_files='+DATA' scope=spfile; SQL> alter system set db_create_file_dest='+DATA' scope=spfile; SQL> alter system set db_recovery_file_dest='+DATA' scope=spfile; [oracle@database ~]$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 18 00:06:29 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to target database: ORCL (not mounted) RMAN> restore controlfile from '/u01/app/oracle/oradata/orcl/control01.ctl'; Starting restore at 18-OCT-11 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=10 device type=DISK channel ORA_DISK_1: copied control file copy output file name=+DATA/orcl/controlfile/current.256.764813197 Finished restore at 18-OCT-11 RMAN> exit Recovery Manager complete. [oracle@database ~]$ sqlplus / as sysdba SQL> alter databas...

Qual a diferença entre startup e startup upgrade: ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY; ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY; ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=MEMORY; ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY; ALTER SYSTEM SET recyclebin=‘OFF’ DEFERRED SCOPE=MEMORY;