Oracle 10.2.0.4 on OEL 5.4
Working an exercise to create a DG setup. After successful completion of creation of standby with
RMAN> run {
2> set until sequence = ?? thread = 1;
3> duplicate target database for standby dorecover;}
I connect to the standby (which was left in mount by rman) and execute
alter database recover managed standby database cancel;
--
ALTER DATABASE ADD standby logfile group 4 (
'/ora01/oradata/mydb/sbyredo04a.rdo',
'/ora02/oradata/mydb/sbyredo04b.rdo') SIZE 51200K;
alter database returns
SQL> alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active
SQL> --
SQL> ALTER DATABASE ADD standby logfile group 4 (
2 '/ora01/oradata/mydb/sbyredo04a.rdo',
3 '/ora02/oradata/mydb/sbyredo04b.rdo') SIZE 51200K;
ALTER DATABASE ADD standby logfile group 4 (
*
ERROR at line 1:
ORA-01184: logfile group 4 already exists
alert log shows
Mon May 2 14:13:41 2011
ALTER DATABASE ADD standby logfile group 4 (
'/ora01/oradata/mydb/sbyredo04a.rdo',
'/ora02/oradata/mydb/sbyredo04b.rdo') SIZE 51200K
ORA-1184 signalled during: ALTER DATABASE ADD standby logfile group 4 (
'/ora01/oradata/mydb/sbyredo04a.rdo',
'/ora02/oradata/mydb/sbyredo04b.rdo') SIZE 51200K...
but then
SQL> select group#,
2 thread#,
3 sequence#,
4 status
5 from v$standby_log;
GROUP# THREAD# SEQUENCE# STATUS
---------- ---------- ---------- ----------
4 0 0 UNASSIGNED
5 0 0 UNASSIGNED
6 0 0 UNASSIGNED
7 0 0 UNASSIGNED
4 rows selected.
but then ....
[oracle@vmlnx02 dgsetup]$ cd /ora01/oradata/mydb
[oracle@vmlnx02 mydb]$ ls -l
total 1011508
-rw-r----- 1 oracle oinstall 5251072 May 2 14:13 audit_ts_01.dbf
-rw-r----- 1 oracle oinstall 7061504 May 2 14:14 control01.ctl
-rw-r----- 1 oracle oinstall 52429312 May 2 14:13 redo01a.rdo
-rw-r----- 1 oracle oinstall 52429312 May 2 14:14 redo02a.rdo
-rw-r----- 1 oracle oinstall 52429312 May 2 14:14 redo03a.rdo
-rw-r----- 1 oracle oinstall 199237632 May 2 14:13 sysaux01.dbf
-rw-r----- 1 oracle oinstall 450895872 May 2 14:13 system01.dbf
-rw-r----- 1 oracle oinstall 209723392 May 2 14:13 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 May 2 14:13 users01.dbf
To summarize
- the ADD STANDBY REDO command fails, saying the group already exists - but . . .
- v$standby_log reportss the groups exist
- a directory listing of where the files should exist shows they do not exist.
Am I having a blatent DSA, or I'm I simply overlooking some subtlety?
As an (probably) aside, while monitoring the alert log of the standby, I noticed that at first it complained about the online redo log files (not the standby redo logs) didn't exist, but that eventually cleared itself.
Edited by: EdStevens on May 2, 2011 3:29 PM