This content has been marked as final. Show 2 replies
"Alter database create standby controlfile" this command will not change controlfile size.
i think you have replaced primary database control file with this standby file.
post your OS information and db version.
post 300 lines from alert log file of primary database.
SigCle wrote:This command i used for Creating a standby database control file which mean the control file need to be created for standby database :
When do this step :
Alter database create standby controlfile ..
Is all primary controlfile reset ?
original size 2M .. and after do : Alter database create standby controlfile to control.ctl, all original controlfile resized to 50K.
Now primary databae can't be opened.
Any helps are very appreciated.
The created file must meet two conditions:
Its filename must be different from any other control file
Must be created after the backup of the datafiles.