Logo MurCode
Oracle Новое сообщение

Восстановление RMAN-ом

Faustofel
Дата: 09.10.2015 16:01:30
пытаюсь конвертом перенести с практически пустой машины (Апекс только стоит) базу на linux

+ 
sqlplus / as sysdba
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE OPEN READ ONLY;
exit;


rman target /
CONVERT DATABASE  
NEW DATABASE 'base'
TRANSPORT SCRIPT 'c:/temp/convertdb/transportscript.sql'
TO PLATFORM 'Linux x86 64-bit' format='/temp/convertdb/%U'
DB_FILE_NAME_CONVERT 'C:/app/oradata/base' '/temp/convertdb';


меняю соответственно в файлах ora и sql пути, все по идее нормально подхватывается но на скрипте происходит ошибка

+ 
SQL> @TRANSPORTSCRIPT.SQL
ORACLE instance started.

Total System Global Area 6697619456 bytes
Fixed Size                  2265904 bytes
Variable Size            3556773072 bytes
Database Buffers         3120562176 bytes
Redo Buffers               18018304 bytes

Control file created.

ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/temp/convertdb/DATA_D_BASE_I-782749902_TS-SYSTEM_FNO-1_0JQJ9HUG'


ALTER TABLESPACE TEMP ADD TEMPFILE '/temp/convertdb/DATA_D-BASE_I-782749902_TS-TEMP_FNO-1_06QJ9HSS'
*
ERROR at line 1:
ORA-01109: database not open

опять систем файл - что этому гаду надо то?
Vadim Lejnin
Дата: 09.10.2015 17:40:54
Faustofel
пытаюсь конвертом перенести с практически пустой машины (Апекс только стоит) базу на linux

+ 
sqlplus / as sysdba
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE OPEN READ ONLY;
exit;


rman target /
CONVERT DATABASE  
NEW DATABASE 'base'
TRANSPORT SCRIPT 'c:/temp/convertdb/transportscript.sql'
TO PLATFORM 'Linux x86 64-bit' format='/temp/convertdb/%U'
DB_FILE_NAME_CONVERT 'C:/app/oradata/base' '/temp/convertdb';


меняю соответственно в файлах ora и sql пути, все по идее нормально подхватывается но на скрипте происходит ошибка

+ 
SQL> @TRANSPORTSCRIPT.SQL
ORACLE instance started.

Total System Global Area 6697619456 bytes
Fixed Size                  2265904 bytes
Variable Size            3556773072 bytes
Database Buffers         3120562176 bytes
Redo Buffers               18018304 bytes

Control file created.

ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/temp/convertdb/DATA_D_BASE_I-782749902_TS-SYSTEM_FNO-1_0JQJ9HUG'


ALTER TABLESPACE TEMP ADD TEMPFILE '/temp/convertdb/DATA_D-BASE_I-782749902_TS-TEMP_FNO-1_06QJ9HSS'
*
ERROR at line 1:
ORA-01109: database not open

опять систем файл - что этому гаду надо то?


Версия какая?
Какая платформа?
Faustofel
Дата: 12.10.2015 09:08:53
Oracle 11R2 на Windows 2008 R2 пытаюсь конвертировать в Oracle 11R2 на Oracle linux 6
Vadim Lejnin
Дата: 12.10.2015 11:33:47
Faustofel
Oracle 11R2 на Windows 2008 R2 пытаюсь конвертировать в Oracle 11R2 на Oracle linux 6

Покадите файл
@TRANSPORTSCRIPT.SQL
Faustofel
Дата: 12.10.2015 11:42:48
+
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- The contents of online logs will be lost and all backups will
-- be invalidated. Use this only if online logs are damaged.

-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
--  ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE

STARTUP NOMOUNT PFILE='/temp/convertdb/INIT_00QJ9HSS_1_0.ORA'
CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/temp/convertdb/ARCH_D-ORCL_ID-782749902_S-40_T-1_A-892571539_03QJ9HSS'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/temp/convertdb/ARCH_D-ORCL_ID-782749902_S-38_T-1_A-892571539_04QJ9HSS'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/temp/convertdb/ARCH_D-ORCL_ID-782749902_S-39_T-1_A-892571539_05QJ9HSS'  SIZE 50M BLOCKSIZE 512
DATAFILE
  '/temp/convertdb/DATA_D-ORCL_I-782749902_TS-SYSTEM_FNO-1_0JQJ9HUG',
  '/temp/convertdb/DATA_D-ORCL_I-782749902_TS-SYSAUX_FNO-2_0IQJ9HTM',
  '/temp/convertdb/DATA_D-ORCL_I-782749902_TS-UNDOTBS1_FNO-3_0KQJ9HV9',
  '/temp/convertdb/DATA_D-ORCL_I-782749902_TS-USERS_FNO-4_0MQJ9HVQ',
  '/temp/convertdb/DATA_D-ORCL_I-782749902_TS-APEX_FNO-5_0HQJ9HSS',
  '/temp/convertdb/DATA_D-ORCL_I-782749902_TS-APEX_2145708263408580_FNO-6_0LQJ9HVP'
CHARACTER SET AL32UTF8
;

-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;

-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/temp/convertdb/DATA_D-ORCL_I-782749902_TS-TEMP_FNO-1_06QJ9HSS'
     SIZE 30408704  AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
-- End of tempfile additions.
--

set echo off
prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
prompt * Your database has been created successfully!
prompt * There are many things to think about for the new database. Here
prompt * is a checklist to help you stay on track:
prompt * 1. You may want to redefine the location of the directory objects.
prompt * 2. You may want to change the internal database identifier (DBID)
prompt *    or the global database name for this database. Use the
prompt *    NEWDBID Utility (nid).
prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SHUTDOWN IMMEDIATE
STARTUP UPGRADE PFILE='/temp/convertdb/INIT_00QJ9HSS_1_0.ORA'
@@ ?/rdbms/admin/utlirp.sql
SHUTDOWN IMMEDIATE
STARTUP PFILE='/temp/convertdb/INIT_00QJ9HSS_1_0.ORA'
-- The following step will recompile all PL/SQL modules.
-- It may take serveral hours to complete.
@@ ?/rdbms/admin/utlrp.sql
set feedback 6;

останавливается на 
ALTER DATABASE OPEN RESETLOGS;


выдает ошибку
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/temp/convertdb/DATA_D-RCL51_I-782749902_TS-SYSTEM_FNO-1_0JQJ9HUG'
Vadim Lejnin
Дата: 12.10.2015 12:10:59
Потестировать можете?
Похоже на ситуацию MOS NOTE: 1455135.1
Vadim Lejnin
Дата: 12.10.2015 12:13:23
SQL> recover database until change scn+1
Где scn - scn of offline backup
Faustofel
Дата: 12.10.2015 12:59:38
Дело в том что база нулячая. Пустая именно для тестов.
Там и бэкапы даже не делались.
Vadim Lejnin
Дата: 12.10.2015 13:04:25
Faustofel
Дело в том что база нулячая. Пустая именно для тестов.
Там и бэкапы даже не делались.


select hxfil file#,fhscn checkpoint_change#, fhafs Absolute_Fuzzy_SCN from x$kcvfh;
recover database until change XXXX ;

Пройдет?
Faustofel
Дата: 12.10.2015 16:34:15
рабочий сервер
SQL> select hxfil file#,fhscn checkpoint_change#, fhafs Absolute_Fuzzy_SCN from x$kcvfh;

     FILE# CHECKPOINT_CHANG ABSOLUTE_FUZZY_S
---------- ---------------- ----------------
         1 1248746          0
         2 1248746          0
         3 1248746          0
         4 1248746          0
         5 1248746          0
         6 1248746          0

6 строк выбрано.

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    1248747


новый сервер
SQL> STARTUP NOMOUNT PFILE='/temp/convertdb/INIT_4294967295.ORA'
ORACLE instance started.

Total System Global Area 6697619456 bytes
Fixed Size                  2265904 bytes
Variable Size            3556773072 bytes
Database Buffers         3120562176 bytes
Redo Buffers               18018304 bytes
SQL> create spfile from pfile='/temp/convertdb/INIT_4294967295.ORA';

File created.

SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 6697619456 bytes
Fixed Size                  2265904 bytes
Variable Size            3556773072 bytes
Database Buffers         3120562176 bytes
Redo Buffers               18018304 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/temp/convertdb/1'

SQL> recover database until change 1248747;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.

SQL>  alter database open;
 alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/temp/convertdb/1'

SQL> RECOVER DATAFILE 1;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.


вот тут http://www.dba-oracle.com/t_ora_16433_rman_cloning_startup.htm нашел что
автор
In essence, a ORA-16433 after an RMAN clone indicates:

A pathing issue whereby Oracle cannot locate the dbf files.
Incorrect data files name, as per the control file.


как проверить пути файлов?