C:\Documents and Settings\Administrator>set oracle_sid=RAJNISH
C:\Documents and Settings\Administrator>rman
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 3 15:47:31 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: RAJNISH (DBID=3847011337)
RMAN> backup as copy database format '+TEST_DB';
C:\Documents and Settings\Administrator>rman
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 3 15:52:11 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: RAJNISH (DBID=3847011337, not open)
RMAN> backup as copy database format '+TEST_DB';
Starting backup at 03-JUN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=D:\RAJNISH\RAJNISH\SYSTEM01.DBF
output filename=+TEST_DB/RAJNISH/datafile/system.262.752860385 tag=TAG20110603T15
5254 recid=2 stamp=752860392
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=D:\RAJNISH\RAJNISH\SYSAUX01.DBF
output filename=+TEST_DB/RAJNISH/datafile/sysaux.263.752860399 tag=TAG20110603T15
5254 recid=3 stamp=752860404
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=D:\RAJNISH\RAJNISH\UNDOTBS01.DBF
output filename=+TEST_DB/RAJNISH/datafile/undotbs1.267.752860407 tag=TAG20110603T
155254 recid=4 stamp=752860408
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=D:\RAJNISH\RAJNISH\USERS01.DBF
output filename=+TEST_DB/RAJNISH/datafile/users.269.752860409 tag=TAG20110603T155
254 recid=5 stamp=752860409
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=+TEST_DB/RAJNISH/controlfile/backup.268.752860411 tag=TAG20110603
T155254 recid=6 stamp=752860410
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 03-JUN-11
channel ORA_DISK_1: finished piece 1 at 03-JUN-11
piece handle=+TEST_DB/RAJNISH/backupset/2011_06_03/nnsnf0_tag20110603t155254_0.26
0.752860413 tag=TAG20110603T155254 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 03-JUN-11
RMAN> SWITCH DATABASE TO COPY;
datafile 1 switched to datafile copy "+TEST_DB/RAJNISH/datafile/system.262.752860385"
datafile 2 switched to datafile copy "+TEST_DB/RAJNISH/datafile/undotbs1.267.752860407"
datafile 3 switched to datafile copy "+TEST_DB/RAJNISH/datafile/sysaux.263.752860399"
datafile 4 switched to datafile copy "+TEST_DB/RAJNISH/datafile/users.269.752860409"
C:\Documents and Settings\Administrator>set oracle_sid=RAJNISH
C:\Documents and Settings\Administrator>rman
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 3 15:59:02 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: RAJNISH (not mounted)
RMAN> restore controlfile from 'D:\RAJNISH\RAJNISH\CONTROL01.CTL';
Starting restore at 03-JUN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: copied control file copy
output filename=+TEST_DB/RAJNISH/controlfile/current.258.752860769
Finished restore at 03-JUN-11
RMAN>
SQL>
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 385878368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
Database mounted.
SQL> alter database open;
Database altered.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+TEST_DB/RAJNISH/datafile/users.269.752860409
+TEST_DB/RAJNISH/datafile/sysaux.263.752860399
+TEST_DB/RAJNISH/datafile/undotbs1.267.752860407
+TEST_DB/RAJNISH/datafile/system.262.752860385
SQL> alter system set control_files ='+TEST_DB' scope = spfile;
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 385878368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
SQL> select name from v$controlfile 2 ;
NAME
--------------------------------------------------------------------------------
+TEST_DB/RAJNISH/controlfile/current.258.752860769
SQL>
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 CURRENT
2 UNUSED
3 UNUSED
SQL> alter database add logfile group 4 '+TEST_DB' SIZE 50M;
Database altered.
SQL> alter database add logfile group 5 '+TEST_DB' SIZE 50M;
Database altered.
SQL> alter database add logfile group 6 '+TEST_DB' SIZE 50M;
Database altered.
SQL> ALTER SYSTEM CHECKPOINT;
System altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 INACTIVE
2 CURRENT
3 UNUSED
4 UNUSED
5 UNUSED
6 UNUSED
6 rows selected.
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> ALTER SYSTEM CHECKPOINT;
System altered.
SQL> ALTER DATABASE DROP LOGFILE GROUP 2;
Database altered.
SQL> ALTER DATABASE DROP LOGFILE GROUP 3;
Database altered.
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
4 CURRENT
5 UNUSED
6 UNUSED
SQL> SELECT * FROM V$LOGFILE;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
-------------------------------------------------------------------------
IS_
---
4 ONLINE
+TEST_DB/RAJNISH/onlinelog/group_4.256.752860901NO
5 ONLINE
+TEST_DB/RAJNISH/onlinelog/group_5.270.752860907NO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
6 ONLINE
+TEST_DB/RAJNISH/onlinelog/group_6.271.752860913NO
SQL> SELECT NAME FROM V$TEMPFILE;
NAME
--------------------------------------------------------------------------------
D:\RAJNISH\RAJNISH\TEMP01.DBF
SQL> CREATE TEMPORARY TABLESPACE TEMP2
2 TEMPFILE '+TEST_DB' SIZE 2M;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
Database altered.
SQL> DROP TABLESPACE TEMP;
Tablespace dropped.
SQL> SELECT NAME FROM V$TEMPFILE;
NAME
--------------------------------------------------------------------------------
+TEST_DB/RAJNISH/tempfile/temp2.272.752861229
SQL>
Now enjoy with ASM......:)
