Skip to Main Content

Oracle Database Discussions

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!

stadnby logfile created automatically on primary db

user00726May 11 2009 — edited May 12 2009
these standby logfile automatically created on primary database.....


even though standby database is down and it was set to be manually....


please help me......
There is space for up to 251 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 120586240;
Clearing standby activation ID 1372076409 (0x51c83979)
The primary database controlfile was created using the
'MAXLOGFILES 255' clause.
There is space for up to 251 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 120586240;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 120586240;
Clearing standby activation ID 1372076409 (0x51c83979)
The primary database controlfile was created using the
'MAXLOGFILES 255' clause.
There is space for up to 251 standby redo logfiles
space on drives
root@ai2 # df -bk
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/vx/dsk/rootvol  12096820 4545081 7430771    38%    /
/proc                      0       0       0     0%    /proc
fd                         0       0       0     0%    /dev/fd
mnttab                     0       0       0     0%    /etc/mnttab
swap                 10709560     136 10709424     1%    /var/run
swap                 10709464      40 10709424     1%    /tmp
/dev/vx/dsk/oracle   6064293 6003653       0   100%    /oracle
/dev/vx/dsk/rootdisk_15vol
                      492872    5069  438516     2%    /global/.devices/node@1
/dev/vx/dsk/node@2    492872    5052  438533     2%    /global/.devices/node@2
10.0.0.1:/arch       20656681 17056684 3393431    84%    /arch
root@ai2 #
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2009
Added on May 11 2009
9 comments
1,019 views