1 2 Previous Next 15 Replies Latest reply on Mar 14, 2014 2:12 PM by Mimi Miami

ORA-1511 when relocating all files on physical standby

Mimi Miami Mar 13, 2014 7:04 PM

I had to relocate all files on my 11.2 physical standby database to a new mount point (nothing changed on the primary). I cancelled managed recovery on the standby and shutdown the standby, then copied the datafiles, controlfile, ORLs, and SRLs to their new location. After that, I mounted the standby, set standby_file_management=MANUAL and did a "alter database rename file" for all files; however, I saw this error repeatedly for all files:

Example:

ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo06.log' to '/g03/oradata/mydb/redo06.

log'...

I did this:

select name from v$datafile;

select name from v$tempfile;

select member from v$logfile;

All the datafiles and tempfiles were showing in the new correct location as well as all the ORLs and SRLs except one SRL file, which was still showing in its old location. I then did:

select * from v$standby_log and that one particular SRL showed ACTIVE. I started managed recovery and switched logfiles on the primary. I then shutdown the standby again and started it up and this time I was able to rename that one SRL that I couldn't rename before (probably due to the log switch).

Why am I seeing the ORA-1511 errors even though the rename worked? Why did the one SRL rename not work? What is the correct way to do this?

Also, I switched log files a bunch of times on the primary and I noticed the only two out of six SRLs were ever being used. Aren't they supposed to rotate in circular fashion instead of switching back and forth between only two of the six SRLs?

1. Re: ORA-1511 when relocating all files on physical standby

BPeaslandDBA Mar 13, 2014 7:12 PM (in response to Mimi Miami)

Example:
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo06.log' to '/g03/oradata/mydb/redo06.
log'...

Unfortunately, this is not enough to know why the rename did not work. There should have been at least one other error message indicating the root cause of the problem. This error is just saying that the rename didn't work. Can you find the entire error message stack? I wouldn't look at the alert log for current entries, rather I would look at the alert log at the point in time when I did the rename.

Also, I switched log files a bunch of times on the primary and I noticed the only two out of six SRLs were ever being used. Aren't they supposed to rotate in circular fashion instead of switching back and forth between only two of the six SRLs?

No. SRL's are not used in circular fashion like ORL's. When a SRL is needed, the first available one is used.

Cheers,
Brian
Like Show 0 Likes(0)

Actions
2. Re: ORA-1511 when relocating all files on physical standby

Mimi Miami Mar 13, 2014 7:23 PM (in response to BPeaslandDBA)

Here's a snippet of the errors in the alert log when I did the rename. Please note, the rename did work despite the errors, except for one SRL.:

...
Physical Standby Database mounted.
Lost write protection disabled
Thu Mar 13 13:44:26 2014
ARC1 started with pid=22, OS id=28151
Thu Mar 13 13:44:26 2014
ARC2 started with pid=23, OS id=28153
Thu Mar 13 13:44:26 2014
ARC3 started with pid=24, OS id=28155
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Completed: alter database mount
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Thu Mar 13 13:44:33 2014
alter database rename file '/g06/oradata/mydb/redo06.log' to '/g03/oradata/mydb/redo06.log'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo06.log' to '/g03/oradata/mydb/redo06.
log'...
alter database rename file '/g06/oradata/mydb/redo05.log' to '/g03/oradata/mydb/redo05.log'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo05.log' to '/g03/oradata/mydb/redo05.
log'...
alter database rename file '/g06/oradata/mydb/redo04.log' to '/g03/oradata/mydb/redo04.log'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo04.log' to '/g03/oradata/mydb/redo04.
log'...
alter database rename file '/g06/oradata/mydb/redo03.log' to '/g03/oradata/mydb/redo03.log'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo03.log' to '/g03/oradata/mydb/redo03.
log'...
alter database rename file '/g06/oradata/mydb/redo02.log' to '/g03/oradata/mydb/redo02.log'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo02.log' to '/g03/oradata/mydb/redo02.
log'...
alter database rename file '/g06/oradata/mydb/redo01.log' to '/g03/oradata/mydb/redo01.log'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo01.log' to '/g03/oradata/mydb/redo01.
log'...
alter database rename file '/g06/oradata/mydb/standby7.dbf' to '/g03/oradata/mydb/standby7.dbf'
Completed: alter database rename file '/g06/oradata/mydb/standby7.dbf' to '/g03/oradata/mydb/standby7.dbf'
alter database rename file '/g06/oradata/mydb/standby8.dbf' to '/g03/oradata/mydb/standby8.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/standby8.dbf' to '/g03/oradata/mydb/stand
by8.dbf'...
alter database rename file '/g06/oradata/mydb/standby9.dbf' to '/g03/oradata/mydb/standby9.dbf'
Completed: alter database rename file '/g06/oradata/mydb/standby9.dbf' to '/g03/oradata/mydb/standby9.dbf'
alter database rename file '/g06/oradata/mydb/standby10.dbf' to '/g03/oradata/mydb/standby10.dbf'
Completed: alter database rename file '/g06/oradata/mydb/standby10.dbf' to '/g03/oradata/mydb/standby10.dbf'
alter database rename file '/g06/oradata/mydb/standby11.dbf' to '/g03/oradata/mydb/standby11.dbf'
Completed: alter database rename file '/g06/oradata/mydb/standby11.dbf' to '/g03/oradata/mydb/standby11.dbf'
alter database rename file '/g06/oradata/mydb/standby12.dbf' to '/g03/oradata/mydb/standby12.dbf'
Completed: alter database rename file '/g06/oradata/mydb/standby12.dbf' to '/g03/oradata/mydb/standby12.dbf'
alter database rename file '/g06/oradata/mydb/standby13.dbf' to '/g03/oradata/mydb/standby13.dbf'
Completed: alter database rename file '/g06/oradata/mydb/standby13.dbf' to '/g03/oradata/mydb/standby13.dbf'
alter database rename file '/g06/oradata/mydb/system01.dbf' to '/g03/oradata/mydb/system01.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/system01.dbf' to '/g03/oradata/mydb/syste
m01.dbf'...
alter database rename file '/g06/oradata/mydb/sysaux01.dbf' to '/g03/oradata/mydb/sysaux01.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/sysaux01.dbf' to '/g03/oradata/mydb/sysau
x01.dbf'...
alter database rename file '/g06/oradata/mydb/undotbs01.dbf' to '/g03/oradata/mydb/undotbs01.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/undotbs01.dbf' to '/g03/oradata/mydb/undo
tbs01.dbf'...
alter database rename file '/g06/oradata/mydb/users01.dbf' to '/g03/oradata/mydb/users01.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/users01.dbf' to '/g03/oradata/mydb/users0
1.dbf'...
alter database rename file '/g06/oradata/mydb/users02.dbf' to '/g03/oradata/mydb/users02.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/users02.dbf' to '/g03/oradata/mydb/users0
2.dbf'...
alter database rename file '/g06/oradata/mydb/users03.dbf' to '/g03/oradata/mydb/users03.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/users03.dbf' to '/g03/oradata/mydb/users0
3.dbf'...
alter database rename file '/g06/oradata/mydb/users04.dbf' to '/g03/oradata/mydb/users04.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/users04.dbf' to '/g03/oradata/mydb/users0
4.dbf'...
alter database rename file '/g06/oradata/mydb/users05.dbf' to '/g03/oradata/mydb/users05.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/users05.dbf' to '/g03/oradata/mydb/users0
5.dbf'...
alter database rename file '/g06/oradata/mydb/users06.dbf' to '/g03/oradata/mydb/users06.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/users06.dbf' to '/g03/oradata/mydb/users0
6.dbf'...
alter database rename file '/g06/oradata/mydb/users07.dbf' to '/g03/oradata/mydb/users07.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/users07.dbf' to '/g03/oradata/mydb/users0
7.dbf'...
alter database rename file '/g06/oradata/mydb/users08.dbf' to '/g03/oradata/mydb/users08.dbf'
Completed: alter database rename file '/g06/oradata/mydb/users08.dbf' to '/g03/oradata/mydb/users08.dbf'
alter database rename file '/g06/oradata/mydb/temp01.dbf' to '/g03/oradata/mydb/temp01.dbf'
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/temp01.dbf' to '/g03/oradata/mydb/temp01.
dbf'...
Thu Mar 13 13:46:31 2014
alter database recover automatic managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (mydb)
Thu Mar 13 13:46:31 2014
MRP0 started with pid=25, OS id=28169
MRP0: Background Managed Standby Recovery process started (mydb)
started logmerger process
Thu Mar 13 13:46:37 2014
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 32 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
...
Like Show 0 Likes(0)

Actions
3. Re: ORA-1511 when relocating all files on physical standby

mseberg Mar 13, 2014 7:34 PM (in response to Mimi Miami)

If you compare

SELECT NAME FROM V$DATAFILE;

to say users02.dbf to they say the same location?

Best Regards

mseberg
Like Show 0 Likes(0)

Actions
4. Re: ORA-1511 when relocating all files on physical standby

Mimi Miami Mar 13, 2014 7:42 PM (in response to mseberg)

The datafiles are all showing in the correct location on /g03 as well as the tempfile and all the ORLs and SRLs except one, standby8.dbf:

SQL> select name from v$datafile;

NAME
-----------------------------------
/g03/oradata/mydb/system01.dbf
/g03/oradata/mydb/sysaux01.dbf
/g03/oradata/mydb/undotbs01.dbf
/g03/oradata/mydb/users01.dbf
/g03/oradata/mydb/users02.dbf
/g03/oradata/mydb/users03.dbf
/g03/oradata/mydb/users04.dbf
/g03/oradata/mydb/users05.dbf
/g03/oradata/mydb/users06.dbf
/g03/oradata/mydb/users07.dbf
/g03/oradata/mydb/users08.dbf

SQL> select name from v$tempfile;

NAME
------------------------------------
/g03/oradata/mydb/temp01.dbf

SQL> select member from v$logfile;

MEMBER
--------------------------------
/g03/oradata/mydb/redo06.log
/g03/oradata/mydb/redo05.log
/g03/oradata/mydb/redo04.log
/g03/oradata/mydb/redo03.log
/g03/oradata/mydb/redo02.log
/g03/oradata/mydb/redo01.log
/g03/oradata/mydb/standby7.dbf
/g06/oradata/mydb/standby8.dbf <-- this has since been renamed to reflect the correct location after another shutdown/log switch/startup/rename, but this is what it first looked like after my initial rename
/g03/oradata/mydb/standby9.dbf
/g03/oradata/mydb/standby10.dbf
/g03/oradata/mydb/standby11.dbf
/g03/oradata/mydb/standby12.dbf
/g03/oradata/mydb/standby13.dbf
Like Show 0 Likes(0)

Actions
5. Re: ORA-1511 when relocating all files on physical standby

mseberg Mar 13, 2014 7:55 PM (in response to Mimi Miami)

When you did the rename what was the setting of STANDBY_FILE_MANAGEMENT on the standby? And did you change this and change it back after the renames?

Best Regards

mseberg
Like Show 0 Likes(0)

Actions
6. Re: ORA-1511 when relocating all files on physical standby

Mimi Miami Mar 13, 2014 8:00 PM (in response to mseberg)

The setting for STANDBY_FILE_MANAGEMENT was set to MANUAL before the renames and then I changed it back to AUTO after I was finished.
Like Show 0 Likes(0)

Actions
7. Re: ORA-1511 when relocating all files on physical standby

mseberg Mar 13, 2014 8:08 PM (in response to Mimi Miami)

Sorry, I don't see the cause of the issue.

My notes say shutdown the standby, start it mount and do the rename with STANDBY_FILE_MANAGEMENT set to manual the return to AUTO when complete.

Near as I can see you did everything right.

Best Regards

mseberg
1 person found this helpful
Like Show 0 Likes(0)

Actions
8. Re: ORA-1511 when relocating all files on physical standby

Mimi Miami Mar 13, 2014 8:34 PM (in response to mseberg)

I tried it again on another database and got the same results. I was so busy looking at the alert log that I missed what was right in front of me in the SQLPlus screen (ORA-1516 followed by the ORA-1511):

Example:
alter database rename file '/g06/oradata/mydb/redo11.log' to '/g03/oradata/mydb/redo11.log'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file
"/g06/oradata/mydb/redo11.log"

But the files DID exist there and the rename was successful! Strange. Can't seem to figure this one out.

One last question, why can't I rename all the standby redo log files when I mount the standby? Why did only one not allow me to rename it? I didn't think it would be ACTIVE until after I started the managed recovery process.
Like Show 0 Likes(0)

Actions
9. Re: ORA-1511 when relocating all files on physical standby

BPeaslandDBA Mar 13, 2014 8:40 PM (in response to Mimi Miami)

The ORA-1516 is the other message I was looking for. As that message states...the log file does not exist. Or...what the message does not state...is that Oracle cannot see the file. Maybe its a permissions issue?

At this point, since the other files seem ok and it is just this one SRL, why not drop it and recreate it?

Cheers,
Brian
Like Show 0 Likes(0)

Actions
10. Re: ORA-1511 when relocating all files on physical standby

jgarry Mar 13, 2014 8:47 PM (in response to Mimi Miami)

Just to be sure: The files existed there before you did the rename?
Like Show 0 Likes(0)

Actions
11. Re: ORA-1511 when relocating all files on physical standby

Mimi Miami Mar 13, 2014 8:51 PM (in response to BPeaslandDBA)

Hmm. Still it doesn't make sense why Oracle cannot see the files yet it renamed them anyways. I checked the permissions on the directories and file structure of both old and new locations and they are identical.

Instead of dropping and recreating the SRL, I just switched logfiles on the primary, shutdown the standby, mounted the standby, and then was able to rename the SRL (since it was no longer the active SRL).

Thanks for all your help, Brian.
Like Show 0 Likes(0)

Actions
12. Re: ORA-1511 when relocating all files on physical standby

mseberg Mar 13, 2014 8:51 PM (in response to Mimi Miami)

Reviewing everything you have posted I don't see why you cannot rename SRL.

Here's my take on your other SRL question.

Standby redo logs are populated with redo information as fast as the primary redo logs so the loss of data in the event of a failover is minimized because you have not waiting for the redo log to be archived and shipped to the standby. So you may have a redo information rate that low enough it only uses a few of them.

Best Regards

mseberg
1 person found this helpful
Like Show 0 Likes(0)

Actions
13. Re: ORA-1511 when relocating all files on physical standby

Mimi Miami Mar 13, 2014 9:10 PM (in response to mseberg)

I must be doing something wrong because I relocated all files for three different physical standby databases today and got the same error on all three of them. I even checked for the possibility of junk characters in the file names and lengths of filenames all matched exactly with the primary. I just still don't understand how I could be seeing the ORA-1511 and ORA-1516 error despite the fact that the rename was sucessful (for all but one!).
Like Show 0 Likes(0)

Actions
14. Re: ORA-1511 when relocating all files on physical standby

Shivananda Rao Mar 13, 2014 9:29 PM (in response to Mimi Miami)

Hello,

ORA-01516: nonexistent log file, data file, or temporary file "string"

Did you check the ownership and permissions for the files ?

Regards,
Shivananda
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.