datagurad常见错误解决方法
DATAGURAD常见错误：
1
ERROR at line 1:
ORA-01511: error in renaming log/datafiles
ORA-01270: RENAME operation is not allowed if STANDBY_FILE_MANAGEMENT is auto
因为你在备库standby_file_management为auto必须改为手动，才能重命名
以下操作需要手动。
ALTER DATABASE RENAME
ALTER DATABASE ADD/DROP LOGFILE
ALTER DATABASE ADD/DROP STANDBY LOGFILE MEMBER
ALTER DATABASE CREATE DATAFILE AS
2
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY *
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
说明当前有活动session
你可以用以下语句查询有那些活动的会话
SELECT SID, PROCESS, PROGRAM FROM V$SESSION
WHERE TYPE = ‘USER’
AND SID <> (SELECT DISTINCT SID FROM V$MYSTAT);
如果没什么重要的，可以在切换时加上。with session shutdown
3
ORA-01102
如果你遇到次错误，是因为你switchover后需要设置db_unique_name
4
注意service=”的名字必须在tnsname.ora里有定义，如果主库没有定义好，那么将导致备库无法接收
