Месяц: Апрель 2017

1. Копируем Бекапсет с арклогами и источника на приёмник.

2. Определяем переменные окружения (oracle_home и oracle_sid)

2. Проверяем параметры

SQL> show parameter convert

NAME TYPE VALUE
------------------------------------ ----------- ------------------------
db_file_name_convert string
log_file_name_convert string
pdb_file_name_convert string
3. Меняем параметры
SQL> alter system set db_file_name_convert='D:\Oradata\TEST','F:\Oradata\TEST' scope =spfile;
System altered.
SQL> alter system set log_file_name_convert='D:\Oradata\TEST','F:\Oradata\TEST' scope =spfile;
System altered.
4. Рестарт БД
SQL> shu immediate;
ORA-01507: database not mounted
ORACLE instance shut down.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1.0289E+10 bytes
Fixed Size 2413360 bytes
Variable Size 5670702288 bytes
Database Buffers 4596957184 bytes
Redo Buffers 18542592 bytes
Проверяем применились ли настройки
SQL> show parameter convert

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string D:\Oradata\TEST, F:\Oradata\TEST
log_file_name_convert string D:\Oradata\TEST, F:\Oradata\TEST
pdb_file_name_convert string

5. rman AUXILIARY /
RUN
{
duplicate database to "TEST" nofilenamecheck
backup location 'D:\Backup\TEST';
}

…вывод на экран…

Прелесть данной конструкции в том, что мы може переименовать БД. Т.е. вместо «TEST» можно поставить «TEST2»

6. Убираем параметры
SQL> alter system reset db_file_name_convert scope=spfile;
System altered.
SQL> alter system reset log_file_name_convert scope=spfile;
System altered.

7. Restart instance and check parameters:
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.0289E+10 bytes
Fixed Size 2413360 bytes
Variable Size 5670702288 bytes
Database Buffers 4596957184 bytes
Redo Buffers 18542592 bytes
Database mounted.
Database opened.

SQL> show parameter convert

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
log_file_name_convert string
pdb_file_name_convert string

—ready!