Dicas ORACLE DBA

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