S
S
Sergey c0re2019-10-27 15:59:55
PHP
Sergey c0re, 2019-10-27 15:59:55

How to import full export into Oracle 9i clean base?

All the best.
Oracle DBMS 9.2.0.7 on Linux RedHat Enterpise Server 4
had a problem when importing a full export, I've never done this before, I don't know where to dig :(
I'm doing it on the same physical server

exp userid=\'/ as sysdba\' buffer=20000000 file=$DUMP_FILE_NAME $EXPORT_WHAT &> $LOG_FILE_NAME

I dump the database, instead I create an empty new one without all the tablespaces that were in the original one (the export is the same kind of complete, including tablespaces)
CREATE DATABASE DBNAME20
  USER SYS IDENTIFIED BY pass
  USER SYSTEM IDENTIFIED BY pass
  LOGFILE
    GROUP 1 (
      '/oradata/DBNAME/redo/redo01.log',
      '/oradata/DBNAME/redo2/redo01.log',
      '/oradata/DBNAME/redo3/redo01.log'
    ) SIZE 100M,
    GROUP 2 (
      '/oradata/DBNAME/redo/redo02.log',
      '/oradata/DBNAME/redo2/redo02.log',
      '/oradata/DBNAME/redo3/redo02.log'
    ) SIZE 100M,
    GROUP 3 (
      '/oradata/DBNAME/redo/redo03.log',
      '/oradata/DBNAME/redo2/redo03.log',
      '/oradata/DBNAME/redo3/redo03.log'
    ) SIZE 100M
  MAXINSTANCES 1
  MAXLOGMEMBERS 3
  MAXLOGFILES 5
  MAXLOGHISTORY 10
  MAXDATAFILES 100
  CHARACTER SET UTF8
  NATIONAL CHARACTER SET UTF8
  DATAFILE '/oradata/DBNAME/data/system01.dbf' SIZE 600M REUSE
  EXTENT MANAGEMENT LOCAL
  DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/DBNAME/temp/temp01.dbf' SIZE 256M REUSE
  UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oradata/DBNAME/undo/undotbs01.dbf' SIZE 500M REUSE
;

the base is successfully created.
trying to import:
imp system/hoqualb5 file=/vol/data1/db-backups/important_backups/expbkup.dmp log=~/imp.log full=y

gives an error message:
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully

Maybe something else needs to be created in an empty database before importing, what?
I can't find it in any way... :-/
PS: the export was made with warnings on one table, but it is not important, the
file system fell into the bad with the crashed database, "cured" fsck
PPS: there are no archive logs, apparently they were lost during automatic copying (curve script), which also did not work normally, apparently due to the fact that the files were not read. current res. In general, there are no copies, the problem arose a long time ago, but the database worked (because corrupted blocks on a table that is not used in any way in the application) until the server was overloaded and it did not boot.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
0
0xD34F, 2018-08-30
@Fissium

$str = preg_replace('/[^\n\w]+/', ' ', $str);

A
Alexey Ostroverkhov, 2019-10-27
@erge

You do not have a dictionary, you need to run at least the standard
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
and then see what else is missing. If some components were used, then it is necessary to run scripts for the dictionary on them

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question