on 07-01-2015 1:46 AM
dear expert,
Now the file system which the controlfile was included will be full. How should i resize the controlfile's size. Please give me a method without moving it.
Hi,
there is only one way how to resize the controlfile and that is to rebuild it.
you can generate script with "alter database backup controlfile to trace" command.
Br
Tomislav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you trying to resize control file, or you want to move control file to another file system/location?
the parameter control_file_record_keep_time can control the control file size.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.