Home » RDBMS Server » Server Administration » Moving OMF files in ASM (Oracle 11.2.0.3)
Moving OMF files in ASM [message #579651] Wed, 13 March 2013 16:02 Go to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
Does anybody have the steps to move OMF files in ASM. I tried the following and
was not successful.


RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/system.357.809972853"
datafile 2 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/sysaux.363.809972837"
datafile 3 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs1.365.809972737"
datafile 4 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/users.361.809972859"
datafile 5 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs2.360.809972761"
datafile 6 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs3.359.809972787"
datafile 7 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs4.358.809972811"

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/13/2013 16:30:05
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

RMAN> alter database open;


so switch worked resetlogs says can't use it there
so I just try to open and it just hangs

Moving OMF files in ASM [message #579652 is a reply to message #579651] Wed, 13 March 2013 16:21 Go to previous message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
I got it!!!

I killed the open command in rman and did it in the db and it opened

Thx
Previous Topic: Login using global DB name
Next Topic: how to see whether table data is using compresssion
Goto Forum:
  


Current Time: Thu Mar 28 16:15:55 CDT 2024