Movement Control file to new disk group ( for example +DATA02)

RMAN> backup as copy current controlfile format '+DATA02';
Starting backup at 17-JAN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=+DATA02/ANARDB/controlfile/backup.273.834409791 tag=TAG20131217T122951 RECID=43 STAMP=834409791
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 17-JAN-11
SQL> alter system set db_create_file_dest='+DATA02' scope=spfile;
System altered.
SQL> alter system set control_files='+DATA02/ANARDB/controlfile/Backup.273.834409791' scope=spfile;
System altered.
SQL> shut immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1720328192 bytes
Fixed Size 2229064 bytes
Variable Size 1224740024 bytes
Database Buffers 335544320 bytes
Redo Buffers 157814784 bytes
SQL> alter database mount;
Database altered.
SQL> recover database using backup controlfile;
ORA-00279: change 7857026695002 generated at 01/17/2014 12:10:29 needed for thread 1
ORA-00289: suggestion : /u01/arc_dest/1_11552_797379303.dbf
ORA-00280: change 7857026695002 for thread 1 is in sequence #11552
Specify log: {=suggested | filename | AUTO | CANCEL}
Log applied.
Media recovery complete.
SQL> select status, checkpoint_change#, fuzzy, 
 2 to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
 3 count(*)
 4 from v$datafile_header
group by status, checkpoint_change#, fuzzy, checkpoint_time
 5 6 order by status, checkpoint_change#, fuzzy, checkpoint_time;
------- ---------------------- --- ---------------------------------------------------------- -------------
ONLINE 7857026695003 NO 17-JAN-2014 12:10:29 14
1 row selected.
SQL> alter database open resetlogs;
Database altered.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: