If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

manual backup of 8i to 11g

it would have been nice if oracle created a backup & convert software for all their databases.

as long as you are the system admin, you have access to the database server, you know the system password and can use exp/imp.
i like to know what is going on, so i tried to do a manual backup and recovery!
Every thing will go well with the manual copying of the database (all datafiles,controlfile,initSID.ora,orapwSID,lkSID,cr_control.sql) but when it comes to the manual restore/importing you have a lot of problem.

now if i copy all the SID directory and put them one place, say /u02/oradata/
and create directories like 11g (eg: database, controlfile, onlinelog), maybe i can get it to work. now all that is stopping me is the sql file to re-create the SIDs,tables and users.

i can get the 8i sql script to re-make the database, but it will not work in 11g.

# now remove everything from the start of the file up to the
# "START NOMOUNT" statement and everything after the semi-colon (.
# now edit the line starting with "CREATE CONTROLFILE"
# replace the word "REUSE" with "SET"
# replace the word "NORESETLOGS" with "RESETLOGS"

*** SESSION ID:(8.15713) 2011-05-04 12:50:53.388
*** 2011-05-04 12:50:53.388
# The following commands will create a new control file and use it
# to open the database.
# Data used by the recovery manager will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DCTEST" NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 8
MAXLOGHISTORY 907
LOGFILE
GROUP 1 '/home/oracle/oradata/DCTEST/redo01.log' SIZE 4M,
GROUP 2 '/home/oracle/oradata/DCTEST/redo02.log' SIZE 4M,
GROUP 3 '/home/oracle/oradata/DCTEST/redo03.log' SIZE 4M
DATAFILE
'/usr/oracle/oradata/DCTEST/system01.dbf',
'/usr/oracle/oradata/DCTEST/tools01.dbf',
'/usr/oracle/oradata/DCTEST/rbs01.dbf',
'/usr/oracle/oradata/DCTEST/temp01.dbf',
'/var/oracle/oradata/DCTEST/eqndxs01.dbf',
'/var/oracle/oradata/DCTEST/drsys01.dbf',
'/usr/oracle/oradata/DCTEST/eqdata01.dbf',
'/usr/oracle/oradata/DCTEST/CATTBS_1.dbf'
CHARACTER SET US7ASCII
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Name your script create_database, because that is what is does. Why use cr_control to confuse the issue? Spend some time reading the documentation and learn something instead of relying on cut and paste from someone else. What do you have against using dbca? There is nothing special about your create database statement which requires extra steps or anything like that.

Have you edited the initORA file and removed old/obsoleted parameters? Why are you using weird paths for your spfile? Do you know what OFA is? Why are you setting LD_LIBRARY_PATH in an 11g environment? Why are you using 11gR1 instead of R2?

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

i use dbca and create a custom dtatabase with default settings, then try to import, it did not work.

I can't believe i fail at a simply thing like this, only think i can do now is do a full OS backup (image the server) so i can recreate it if that machine dies, or two or more HD fail at the same time. all i have now is a daily export of all the SIDs, that it backed up every night to tape.