| NONASM TO ASM [message #520262] |
Sat, 20 August 2011 01:10  |
sekharsomu
Messages: 72
Registered: December 2008
|
Member |
|
|
Hi,
i am trying to Migrate a Non asm database to ASM
i was successfully in allocating disk and create a diskgroup
i was also able to take a database copy to diskgroup and latter switch the database file to DG.
But..
ORA-01156:
RMAN> backup as copy database format '+dg1';
Starting backup at 19-AUG-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=134 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
output filename=+DG1/orcl/datafile/system.258.759622571 tag=TAG20110819T221557 r
ecid=3 stamp=759622607
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
output filename=+DG1/orcl/datafile/sysaux.259.759622613 tag=TAG20110819T221557 r
ecid=4 stamp=759622632
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DB
F
output filename=+DG1/orcl/datafile/example.260.759622639 tag=TAG20110819T221557
recid=5 stamp=759622645
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DB
F
output filename=+DG1/orcl/datafile/undotbs1.261.759622653 tag=TAG20110819T221557
recid=6 stamp=759622656
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
output filename=+DG1/orcl/datafile/users.262.759622661 tag=TAG20110819T221557 re
cid=7 stamp=759622661
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=+DG1/orcl/controlfile/backup.263.759622661 tag=TAG20110819T22155
7 recid=8 stamp=759622662
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
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 19-AUG-11
channel ORA_DISK_1: finished piece 1 at 19-AUG-11
piece handle=+DG1/orcl/backupset/2011_08_19/nnsnf0_tag20110819t221557_0.264.7596
22665 tag=TAG20110819T221557 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 19-AUG-11
RMAN> run
2> {
3> shutdown immediate;
4> startup mount;
5> }
database closed
database dismounted
Oracle instance shut down
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 293601280 bytes
Fixed Size 1248624 bytes
Variable Size 121635472 bytes
Database Buffers 167772160 bytes
Redo Buffers 2945024 bytes
RMAN> switch database to copy;
datafile 1 switched to datafile copy "+DG1/orcl/datafile/system.258.759622571"
datafile 2 switched to datafile copy "+DG1/orcl/datafile/undotbs1.261.759622653"
datafile 3 switched to datafile copy "+DG1/orcl/datafile/sysaux.259.759622613"
datafile 4 switched to datafile copy "+DG1/orcl/datafile/users.262.759622661"
datafile 5 switched to datafile copy "+DG1/orcl/datafile/example.260.759622639"
RMAN> recover database;
Starting recover at 19-AUG-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:04
Finished recover at 19-AUG-11
RMAN> sql'alter database open';
sql statement: alter database open
RMAN> backup as copy current controlfile format '+dg1';
Starting backup at 19-AUG-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=+DG1/orcl/controlfile/backup.265.759623015 tag=TAG20110819T22233
4 recid=14 stamp=759623015
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 19-AUG-11
when i tried recover the database after changing the control file path i got some errors latter when i tried to reset logs
i get the follow errors <please do see the code>
SQL> alter system set control_files='+DG1/orcl/controlfile/backup.265.759623015
scope=spfile;
System altered.
SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248624 bytes
Variable Size 125829776 bytes
Database Buffers 163577856 bytes
Redo Buffers 2945024 bytes
Database mounted.
SQL> alter database recover automatic using backup controlfile until cancel;
alter database recover automatic using backup controlfile until cancel
*
ERROR at line 1:
ORA-00279: change 723590 generated at 08/19/2011 20:47:56 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_08_19\O1_MF_1
8_%U_.ARC
ORA-00280: change 723590 for thread 1 is in sequence #8
ORA-00278: log file
'C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_08_19\O1_MF_
_8_%U_.ARC' no longer needed for this recovery
ORA-00308: cannot open archived log
'C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_08_19\O1_MF_
_8_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL> alter database op[en resetlogs;
alter database op[en resetlogs
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01156: recovery in progress may need access to files
please guide me in moving further
|
|
|
|
|
|
|
|
| Re: NONASM TO ASM [message #520265 is a reply to message #520264] |
Sat, 20 August 2011 01:48  |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
So copy the controlfile across again. Then do a complete recovery. It would have been easier if you hadn't opened the database.
|
|
|
|
|
|
| Re: NONASM TO ASM [message #520271 is a reply to message #520270] |
Sat, 20 August 2011 02:16 |
sekharsomu
Messages: 72
Registered: December 2008
|
Member |
|
|
when i tried to copy the control file again in rman it resulted in the following warning can i proceed ...
RMAN> backup as copy current controlfile format '+dg1';
Starting backup at 20-AUG-11
Starting implicit crosscheck backup at 20-AUG-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=152 devtype=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 20-AUG-11
Starting implicit crosscheck copy at 20-AUG-11
using channel ORA_DISK_1
Crosschecked 7 objects
Finished implicit crosscheck copy at 20-AUG-11
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=+DG1/orcl/controlfile/backup.266.759629633 tag=TAG20110820T00135
2 recid=14 stamp=759629635
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 20-AUG-11
RMAN-06497: WARNING: control file is not current, control file autobackup skippe
d [Updated on: Sat, 20 August 2011 02:16] Report message to a moderator |
|
|
|
| Re: NONASM TO ASM [message #520273 is a reply to message #520271] |
Sat, 20 August 2011 02:28 |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
First: I don't see an error.
Second: I don't see an attempt at recovery.
Third: I don't know what you are using at this point as your current controlfile. I hope it isn't the one you tried to recover before.
|
|
|
|
| Re: NONASM TO ASM [message #520274 is a reply to message #520273] |
Sat, 20 August 2011 02:39 |
sekharsomu
Messages: 72
Registered: December 2008
|
Member |
|
|
Thanks budddy now i am able to get it have done a complete recovery and able to open database with resetlogs finally changed the control file path
SQL> select * from v$controlfile;
STATUS
-------
NAME
--------------------------------------------------
IS_ BLOCK_SIZE FILE_SIZE_BLKS
--- ---------- --------------
+DG1/orcl/controlfile/backup.265.759623015
NO 16384 430
SQL> |
|
|
|
| Re: NONASM TO ASM [message #520275 is a reply to message #520274] |
Sat, 20 August 2011 02:46 |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
The best "thank you" you could do would be to write up the whole procedure, and publish it as an article on the blog. Then you'll be famous! And it might help others.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
