Fri Nov 24 09:11:42 2017
skgxpvfynet: mtype: 61 process 11799 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4)
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_11799.trc  (incident=123381):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sendmsg failed with status: 105
ORA-27301: OS failure message: No buffer space available
ORA-27302: failure occurred at: sskgxpsnd2
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_123381/orcl2_ora_11799_i123381.trc
Fri Nov 24 09:11:42 2017
skgxpvfynet: mtype: 61 process 11801 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4)
opiodr aborting process unknown ospid (11743) as a result of ORA-603
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_11801.trc  (incident=123382):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sendmsg failed with status: 105
ORA-27301: OS failure message: No buffer space available
ORA-27302: failure occurred at: sskgxpsnd2
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_123382/orcl2_ora_11801_i123382.trc
Dumping diagnostic data in directory=[cdmp_20171124091142], requested by (instance=2, osid=11743), summary=[incident=123380].

mysql> show create table employees\G;
*************************** 1. row ***************************
       Table: employees
Create Table: CREATE TABLE `employees` (
  `emp_no` int(11) NOT NULL,
  `birth_date` date NOT NULL,
  `first_name` varchar(14) NOT NULL,
  `last_name` varchar(16) NOT NULL,
  `gender` enum('M','F') NOT NULL,
  `hire_date` date NOT NULL,
  `base_salaries` decimal(8,2) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `idx_emp_hire` (`hire_date`),
  KEY `idx_emp_no` (`emp_no`)
) ENGINE=InnoDB AUTO_INCREMENT=300151 DEFAULT CHARSET=utf8

alter table employees drop primary key;
create index idx_emp_no on employees(emp_no);
alter table employees add id int;
alter table employees change id id int not null auto_increment primary key;

SQL> select name,open_mode,log_mode,force_logging,flashback_on from v$database;

NAME      OPEN_MODE            LOG_MODE     FOR FLASHBACK_ON
--------- -------------------- ------------ --- ------------------
ORCL      READ WRITE           ARCHIVELOG   NO  NO

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/arch/
Oldest online log sequence     246
Next log sequence to archive   249
Current log sequence           249

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
recovery_parallelism                 integer     0

alter system set log_archive_dest='';
alter system set db_recovery_file_dest_size=10g;
alter system set db_recovery_file_dest='/u01/app/fra';

# 2880单位是分钟minutes
alter system set db_flashback_retention_target=2880;

alter database flashback on;

# 原库：CRM (DBID=3657993631)  异机：DGT (DBID=1562574039)
sqlplus / as sysdba
exec dbms_backup_restore.nidbegin('dgt','DGT','3657993631','1562574039',0,0,10);

variable a number;
variable b number;
variable c number;

exec dbms_backup_restore.nidprocessdf(0,0,:a,:b,:c);
exec dbms_backup_restore.nidprocesscf(:a,:b);
exec dbms_backup_restore.nidend;

select dbid from v$database;

rman target /
catalog start with '/oradata/nfs/crmpn_rman/arc_temp';

run
{allocate channel ci type disk;
set archivelog destination to '/u01/';
restore archivelog all;
release channel ci;
}