1. Get the current control_file location

SQL> show parameter control_files

NAME TYPE VALUE

control_files string /u01/oracle/dbaclass/control01.ctl

2. Set the new location of controfile:

SQL> alter system set control_files='/u03/oracle/dbaclass/control01.ctl' scope=spfile;

System altered.

3. start the database in nomount stage:

shutdown immediate;
startup nomount

4. Restore controlfile to new location:

RMAN> restore controlfile from '/u01/oracle/dbaclass/control01.ctl';

Starting restore at 13-JAN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2201 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=/u03/oracle/dbaclass/control01.ctl
Finished restore at 13-JAN-19

5. restart the database:

alter database mount;
alter database open;

6. Check the control_file again:

SQL> show parameter control_files

NAME TYPE VALUE

control_files string /u03/oracle/dbaclass/control01.ctl

Si datapump en erreur => CTRL-C

stop_job=immediate # peut être long, à tester sans le "immediate"

Faire les alter nécessaires.

Pour reprendre, vérifier les jobs datapump :
SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;

Puis lancer le datapump :

impdp attach=SYS_IMPORT_FULL_01 # job_name

Dans datapump, si job_mode est "NOT RUNNING" :
start_job # ajouter =SKIP_CURRENT si c'est vraiment nécessaire.

Puis, pour faire l'équivalent d'un "fg" :
continue_client

$ ./rda.pl -T ora600:/u01/app/oracle/product/10.2.0/db_1/bdump/racdb1_pz99_8329.trc