SQLPLUS
SQL> startupORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1348244 bytesVariable Size 490737004 bytesDatabase Buffers 352321536 bytesRedo Buffers 5124096 bytesDatabase mounted.Database opened.SQL> select NAME, STATE, TOTAL_MB, FREE_MB from v$asm_diskgroup;
NAME STATE TOTAL_MB FREE_MB—————————— ———– ———- ———-DATA MOUNTED 3067 3008
SQL> select FILE_NAME from dba_data_files;
FILE_NAME——————————————————————————–/opt/app/oracle/oradata/orcl/users01.dbf/opt/app/oracle/oradata/orcl/undotbs01.dbf/opt/app/oracle/oradata/orcl/sysaux01.dbf/opt/app/oracle/oradata/orcl/system01.dbf/opt/app/oracle/oradata/orcl/example01.dbf
SQL> select NAME from v$tempfile;
NAME——————————————————————————–/opt/app/oracle/oradata/orcl/temp01.dbf
SQL> select MEMBER from v$logfile;
MEMBER——————————————————————————–/opt/app/oracle/oradata/orcl/redo03.log/opt/app/oracle/oradata/orcl/redo02.log/opt/app/oracle/oradata/orcl/redo01.log
SQL> select NAME from v$controlfile;
NAME——————————————————————————–/opt/app/oracle/oradata/orcl/control01.ctl/opt/app/oracle/fast_recovery_area/orcl/control02.ctl
SQL> show parameter db_create_file_dest
NAME TYPE VALUE———————————— ———– ——————————db_create_file_dest stringSQL> alter system set db_create_online_log_dest_1=’+DATA‘ scope=spfile;
System altered.
SQL> show parameter control_files
NAME TYPE VALUE———————————— ———– ——————————control_files string /opt/app/oracle/oradata/orcl/control01.ctl, /opt/app/oracle/fast_recovery_area/orcl/control02.ctl
SQL> alter system reset control_files scope=spfile sid=’*‘;
System altered.
RMAN
[oracle@server grid]$ rman target /
Recovery Manager: Release 11.2.0.3.0 – Production on Thu Jun 14 15:28:30 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 849530880 bytes
Fixed Size 1348244 bytesVariable Size 490737004 bytesDatabase Buffers 352321536 bytesRedo Buffers 5124096 bytes
RMAN> restore controlfile from ‚/opt/app/oracle/oradata/orcl/control01.ctl‘;
Starting restore at 14-JUN-12allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: copied control file copyoutput file name=+DATA/orcl/controlfile/current.256.785950179Finished restore at 14-JUN-12
RMAN> alter database mount;
database mountedreleased channel: ORA_DISK_1
RMAN> backup as copy database format ‚+DATA‘;
Starting backup at 14-JUN-12allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=134 device type=DISKchannel ORA_DISK_1: starting datafile copyinput datafile file number=00001 name=/opt/app/oracle/oradata/orcl/system01.dbfoutput file name=+DATA/orcl/datafile/system.257.785950257 tag=TAG20120614T153055 RECID=2 STAMP=785950289channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35channel ORA_DISK_1: starting datafile copyinput datafile file number=00002 name=/opt/app/oracle/oradata/orcl/sysaux01.dbfoutput file name=+DATA/orcl/datafile/sysaux.258.785950293 tag=TAG20120614T153055 RECID=3 STAMP=785950317channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25channel ORA_DISK_1: starting datafile copyinput datafile file number=00003 name=/opt/app/oracle/oradata/orcl/undotbs01.dbfoutput file name=+DATA/orcl/datafile/undotbs1.259.785950317 tag=TAG20120614T153055 RECID=4 STAMP=785950337channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25channel ORA_DISK_1: starting datafile copyinput datafile file number=00005 name=/opt/app/oracle/oradata/orcl/example01.dbfoutput file name=+DATA/orcl/datafile/example.260.785950343 tag=TAG20120614T153055 RECID=5 STAMP=785950355channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15channel ORA_DISK_1: starting datafile copycopying current control fileoutput file name=+DATA/orcl/controlfile/backup.261.785950359 tag=TAG20120614T153055 RECID=6 STAMP=785950358channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01channel ORA_DISK_1: starting datafile copyinput datafile file number=00004 name=/opt/app/oracle/oradata/orcl/users01.dbfoutput file name=+DATA/orcl/datafile/users.262.785950359 tag=TAG20120614T153055 RECID=7 STAMP=785950359channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setincluding current SPFILE in backup setchannel ORA_DISK_1: starting piece 1 at 14-JUN-12channel ORA_DISK_1: finished piece 1 at 14-JUN-12piece handle=+DATA/orcl/backupset/2012_06_14/nnsnf0_tag20120614t153055_0.263.785950361 tag=TAG20120614T153055 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 14-JUN-12
RMAN> switch database to copy;
datafile 1 switched to datafile copy „+DATA/orcl/datafile/system.257.785950257″datafile 2 switched to datafile copy „+DATA/orcl/datafile/sysaux.258.785950293″datafile 3 switched to datafile copy „+DATA/orcl/datafile/undotbs1.259.785950317″datafile 4 switched to datafile copy „+DATA/orcl/datafile/users.262.785950359″datafile 5 switched to datafile copy „+DATA/orcl/datafile/example.260.785950343“
RMAN> alter database open;
database opened
[oracle@server grid]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 14 15:34:41 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – ProductionWith the Partitioning, Automatic Storage Management, OLAP, Data Miningand Real Application Testing options
SQL> select FILE_NAME from dba_data_files;
FILE_NAME——————————————————————————–+DATA/orcl/datafile/users.262.785950359+DATA/orcl/datafile/undotbs1.259.785950317+DATA/orcl/datafile/sysaux.258.785950293+DATA/orcl/datafile/system.257.785950257+DATA/orcl/datafile/example.260.785950343
SQL> select NAME from v$controlfile;
NAME——————————————————————————–+DATA/orcl/controlfile/current.256.785950179
SQL> alter tablespace temp add tempfile ‚+DATA‘ size 25m;
Tablespace altered.
SQL> select file_name from dba_temp_files;
FILE_NAME——————————————————————————–/opt/app/oracle/oradata/orcl/temp01.dbf+DATA/orcl/tempfile/temp.264.785950793
SQL> alter tablespace temp drop tempfile ‚/opt/app/oracle/oradata/orcl/temp01.dbf‘;
Tablespace altered.
SQL> select file_name from dba_temp_files;
FILE_NAME——————————————————————————–+DATA/orcl/tempfile/temp.264.785950793
SQL> alter system set db_create_online_log_dest_1=’+DATA‘ scope=spfile;
System altered.
SQL> select group#, status from v$log;
GROUP# STATUS———- —————-1 INACTIVE2 CURRENT3 INACTIVE
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database add logfile group 1 size 52428800;
Database altered.
SQL> select l.group# , l.bytes , l.status , l.archived , lf.memberfrom v$logfile lf , v$log lwhere lf.group# = l.group#; 2 3
GROUP# BYTES STATUS ARC———- ———- —————- —MEMBER——————————————————————————–3 52428800 INACTIVE NO/opt/app/oracle/oradata/orcl/redo03.log
2 52428800 CURRENT NO/opt/app/oracle/oradata/orcl/redo02.log
1 52428800 UNUSED YES+DATA/orcl/onlinelog/group_1.265.785951239
SQL> alter system switch logfile;
System altered.
SQL> select group#, status from v$log;
GROUP# STATUS———- —————-1 CURRENT2 ACTIVE3 INACTIVE
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database add logfile group 3 size 52428800;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> select group#, status from v$log;
GROUP# STATUS———- —————-1 ACTIVE2 ACTIVE3 CURRENT
SQL> alter system checkpoint;
System altered.
SQL> select l.group# , l.bytes , l.status , l.archived , lf.memberfrom v$logfile lf , v$log lwhere lf.group# = l.group#; 2 3
GROUP# BYTES STATUS ARC———- ———- —————- —MEMBER——————————————————————————–3 52428800 INACTIVE NO+DATA/orcl/onlinelog/group_3.266.785951395
2 52428800 INACTIVE NO/opt/app/oracle/oradata/orcl/redo02.log
1 52428800 CURRENT NO+DATA/orcl/onlinelog/group_1.265.785951239
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database add logfile group 2 size 52428800;
Database altered.
SQL> select l.group# , l.bytes , l.status , l.archived , lf.memberfrom v$logfile lf , v$log lwhere lf.group# = l.group#; 2 3
GROUP# BYTES STATUS ARC———- ———- —————- —MEMBER——————————————————————————–3 52428800 INACTIVE NO+DATA/orcl/onlinelog/group_3.266.785951395
2 52428800 UNUSED YES+DATA/orcl/onlinelog/group_2.267.785951587
1 52428800 CURRENT NO+DATA/orcl/onlinelog/group_1.265.785951239