-
1. Re: ORA-1511 when relocating all files on physical standby
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 -
2. Re: ORA-1511 when relocating all files on physical standby
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.
...
-
3. Re: ORA-1511 when relocating all files on physical standby
If you compare
SELECT NAME FROM V$DATAFILE;
to say users02.dbf to they say the same location?
Best Regards
mseberg
-
4. Re: ORA-1511 when relocating all files on physical standby
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
-
5. Re: ORA-1511 when relocating all files on physical standby
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
-
6. Re: ORA-1511 when relocating all files on physical standby
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.
-
7. Re: ORA-1511 when relocating all files on physical standby
1 person found this helpfulSorry, 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
-
8. Re: ORA-1511 when relocating all files on physical standby
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.
-
9. Re: ORA-1511 when relocating all files on physical standby
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
-
10. Re: ORA-1511 when relocating all files on physical standby
Just to be sure: The files existed there before you did the rename?
-
11. Re: ORA-1511 when relocating all files on physical standby
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.
-
12. Re: ORA-1511 when relocating all files on physical standby
1 person found this helpfulReviewing 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
-
13. Re: ORA-1511 when relocating all files on physical standby
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!).
-
14. Re: ORA-1511 when relocating all files on physical standby
Hello,
ORA-01516: nonexistent log file, data file, or temporary file "string"
Did you check the ownership and permissions for the files ?
Regards,
Shivananda
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.