Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-1511 when relocating all files on physical standby

Mimi MiamiMar 13 2014 — edited Mar 14 2014

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?

This post has been answered by BPeaslandDBA on Mar 13 2014
Jump to Answer

Comments

BPeaslandDBA

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

Mimi Miami

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.

...

mseberg

If you compare

SELECT NAME FROM V$DATAFILE;

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

Best Regards

mseberg

Mimi Miami

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

mseberg

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

Mimi Miami

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.

mseberg

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

Mimi Miami

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.

BPeaslandDBA
Answer

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

Marked as Answer by Mimi Miami · Sep 27 2020
jgarry

Just to be sure: The files existed there before you did the rename? 

Mimi Miami

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. 

mseberg

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

Mimi Miami

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!).

Shivananda Rao

Hello,

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

Did you check the ownership and permissions for the files ?

Regards,

Shivananda

Mimi Miami

Shivananda,

I did check the ownership & permissions and they are all correct.  I would imagine if they were wrong it wouldn't have actually done the rename.  ??

1 - 15
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 11 2014
Added on Mar 13 2014
15 comments
3,494 views