Hi All,
I'm trying to do a system copy for Solution Manager running under Windows 2003 32bits and Oracle 10.2 and i found the following problem,
This is the procedure that i followed...
1.- Offline backup of the source system using brbackup
2.- copy and rename the backup trace file to use it later to recreate the control files
3.- prepare the control file and replace the old SID with the new SID,
- At the CREATE Statement Change REUSE for SET and NORESETLOGS for RESETLOGS
- Remove all the rest of the statements
4 - Remove old online redo logs and controlfiles from the target system
5 - Copy the xxxxxxxxxxxx.aft file and replace old SID with new SID and check locations of the files.
6.- Restore the database using,
brrestore -b xxxxxxxxx.aft -p init<sid>.sap -m all
7.-startup nomunt
recreate the controlfile using the modified .sql file
shutdown
8.- startup mount exclusive
recover database until cancel using backup controlfile;
then CANCEL
alter database archivelog;
alter database open resetlogs <---- This is the last step and the database crash!!!
database is terminated.... theres no way i can open the database
Any ideas???
Points will be rewarded!
Cheers
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.