| hi [message #56326] |
Wed, 19 March 2003 11:31  |
NANA
Messages: 5
Registered: March 2003
|
Junior Member |
|
|
|
how to do hot backup without control file?
|
|
|
|
|
|
| Re: errror doing hot backup [message #56328 is a reply to message #56327] |
Wed, 19 March 2003 11:34  |
Satish Shrikhande
Messages: 167
Registered: October 2001
|
Senior Member |
|
|
Install Oracle with no database.
ORADIM - new -sid DB -intpwd tiger2
ORADIM - delete -sid BSS
Restore all the file , recover without no control file.
sqldba72
connect internal/tiger2
CREATE CONTROLFILE SET DATABASE DB RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 50
MAXINSTANCES 16
MAXLOGHISTORY 1600
LOGFILE
GROUP 1 ('E:ORACLElog1db.ora','E:ORACLElog2db.ora') SIZE 10M,
GROUP 2 ('E:ORACLElog3db.ora','E:ORACLElog4db.ora') SIZE 10M
DATAFILE
'E:ORACLEdbdata01.ora',
'E:ORACLEdbdata02.ora',
'E:ORACLEdbdata07.ora',
'E:ORACLEdbsys.ora',
'E:ORACLEdbuser.ora
;
alter database backup controlfile to trace;
startup mount pfile='d:orantdatabaseinitbss.ora'
alter database recover from controlfile until cancel;
alter database open resetlogs;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
