Network error: Connection timed out
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Session stopped
- Press <return> to exit tab
- Press R to restart session
- Press S to save terminal output to file
Network error: Connection timed out
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Session stopped
- Press <return> to exit tab
- Press R to restart session
- Press S to save terminal output to file
Network error: Connection timed out
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Session stopped
- Press <return> to exit tab
- Press R to restart session
- Press S to save terminal output to file
┌──────────────────────────────────────────────────────────────────────┐
│ • MobaXterm Personal Edition v21.3 • │
│ (SSH client, X server and network tools) │
│ │
│ ➤ SSH session to root@192.168.122.1 │
│ • Direct SSH : ✔ │
│ • SSH compression : ✔ │
│ • SSH-browser : ✔ │
│ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
│ │
│ ➤ For more info, ctrl+click on help or visit our website. │
└──────────────────────────────────────────────────────────────────────┘
Last login: Thu Nov 4 14:18:42 2021 from 192.168.122.6
[root@localhost ~]# su - oracle
Last login: Thu Nov 4 14:26:26 CST 2021 on pts/1
[oracle@localhost ~]$ export orcl
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 8 09:42:20 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 8 09:42:51 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> archive log list;
ORA-01012: not logged on
SQL> archive log list;
ORA-01012: not logged on
SQL> startup
ORACLE instance started.
Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 385875968 bytes
Database Buffers 788529152 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /Data/arch
Oldest online log sequence 7
Next log sequence to archive 9
Current log sequence 9
SQL> alter system switch logfile;
System altered.
SQL> sho parameter keep_time
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
SQL> alter system set control_file_record_keep_time=30;
System altered.
SQL> ^C
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:34:15 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235)
RMAN> show all
2> ;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f'; # default
RMAN> exit
Recovery Manager complete.
[oracle@localhost ~]$ cd /Data/oradata/
[oracle@localhost oradata]$ mkdir -p oraback
[oracle@localhost oradata]$ ls
oraback orcl
[oracle@localhost oradata]$ pwd
/Data/oradata
[oracle@localhost oradata]$ cd oraback/
[oracle@localhost oraback]$ pwd
/Data/oradata/oraback
[oracle@localhost oraback]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:45:10 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235)
RMAN> configure channel device type disk format ' /Data/oradata/oraback/%U_%d/%T ';
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 385875968 bytes
Database Buffers 788529152 bytes
Redo Buffers 7880704 bytes
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=355 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 10:52:22
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/040dlcj5_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost oraback]$ su -root
su: invalid option -- 'r'
Usage:
su [options] [-] [USER [arg]...]
Change the effective user id and group id to that of USER.
A mere - implies -l. If USER not given, assume root.
Options:
-m, -p, --preserve-environment do not reset environment variables
-g, --group <group> specify the primary group
-G, --supp-group <group> specify a supplemental group
-, -l, --login make the shell a login shell
-c, --command <command> pass a single command to the shell with -c
--session-command <command> pass a single command to the shell with -c
and do not create a new session
-f, --fast pass -f to the shell (for csh or tcsh)
-s, --shell <shell> run shell if /etc/shells allows it
-h, --help display this help and exit
-V, --version output version information and exit
For more details see su(1).
[oracle@localhost oraback]$ su - root
Password:
Last login: Mon Nov 8 09:29:07 CST 2021 from 192.168.122.6 on pts/0
[root@localhost ~]# cd /Data
[root@localhost Data]# chown -R oracle.oinstall /Data/
[root@localhost Data]# chown -R oracle.oinstall /Data/oradata/oraback/
[root@localhost Data]# chmod -R 775 /Data/oradata/oraback/
[root@localhost Data]# chown -R oracle:oinstall /Data/oradata/oraback/
[root@localhost Data]# su - oracle
Last login: Mon Nov 8 09:42:04 CST 2021 on pts/0
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:56:42 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12162: TNS:net service name is incorrectly specified
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:56:59 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=128 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 10:57:21
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/050dlcsh_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
new RMAN configuration parameters are successfully stored
RMAN> backup databases;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "application, archivelog, as, auxiliary, backuppiece, backupset, backup, channel, check, consistent, controlfilecopy, copies, copy, cumulative, current, database, database root, datafilecopy, datafile, datapump, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, passwordfile, pluggable, pool, proxy, recovery, reuse, section, skipoffline, skip readonly, skipinaccessible, spfile, tablespace, tag, to, validate, ("
RMAN-01008: the bad identifier was: databases
RMAN-01007: at line 1 column 8 file: standard input
RMAN> backup database;
Starting backup at 08-NOV-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:02:38
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/060dld6d_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN>
Network error: Connection timed out
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Session stopped
- Press <return> to exit tab
- Press R to restart session
- Press S to save terminal output to file
Network error: Connection timed out
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Session stopped
- Press <return> to exit tab
- Press R to restart session
- Press S to save terminal output to file
Network error: Connection timed out
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Session stopped
- Press <return> to exit tab
- Press R to restart session
- Press S to save terminal output to file
┌──────────────────────────────────────────────────────────────────────┐
│ • MobaXterm Personal Edition v21.3 • │
│ (SSH client, X server and network tools) │
│ │
│ ➤ SSH session to root@192.168.122.1 │
│ • Direct SSH : ✔ │
│ • SSH compression : ✔ │
│ • SSH-browser : ✔ │
│ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
│ │
│ ➤ For more info, ctrl+click on help or visit our website. │
└──────────────────────────────────────────────────────────────────────┘
Last login: Thu Nov 4 14:18:42 2021 from 192.168.122.6
[root@localhost ~]# su - oracle
Last login: Thu Nov 4 14:26:26 CST 2021 on pts/1
[oracle@localhost ~]$ export orcl
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 8 09:42:20 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 8 09:42:51 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> archive log list;
ORA-01012: not logged on
SQL> archive log list;
ORA-01012: not logged on
SQL> startup
ORACLE instance started.
Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 385875968 bytes
Database Buffers 788529152 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /Data/arch
Oldest online log sequence 7
Next log sequence to archive 9
Current log sequence 9
SQL> alter system switch logfile;
System altered.
SQL> sho parameter keep_time
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
SQL> alter system set control_file_record_keep_time=30;
System altered.
SQL> ^C
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:34:15 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235)
RMAN> show all
2> ;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f'; # default
RMAN> exit
Recovery Manager complete.
[oracle@localhost ~]$ cd /Data/oradata/
[oracle@localhost oradata]$ mkdir -p oraback
[oracle@localhost oradata]$ ls
oraback orcl
[oracle@localhost oradata]$ pwd
/Data/oradata
[oracle@localhost oradata]$ cd oraback/
[oracle@localhost oraback]$ pwd
/Data/oradata/oraback
[oracle@localhost oraback]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:45:10 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235)
RMAN> configure channel device type disk format ' /Data/oradata/oraback/%U_%d/%T ';
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 385875968 bytes
Database Buffers 788529152 bytes
Redo Buffers 7880704 bytes
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=355 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 10:52:22
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/040dlcj5_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost oraback]$ su -root
su: invalid option -- 'r'
Usage:
su [options] [-] [USER [arg]...]
Change the effective user id and group id to that of USER.
A mere - implies -l. If USER not given, assume root.
Options:
-m, -p, --preserve-environment do not reset environment variables
-g, --group <group> specify the primary group
-G, --supp-group <group> specify a supplemental group
-, -l, --login make the shell a login shell
-c, --command <command> pass a single command to the shell with -c
--session-command <command> pass a single command to the shell with -c
and do not create a new session
-f, --fast pass -f to the shell (for csh or tcsh)
-s, --shell <shell> run shell if /etc/shells allows it
-h, --help display this help and exit
-V, --version output version information and exit
For more details see su(1).
[oracle@localhost oraback]$ su - root
Password:
Last login: Mon Nov 8 09:29:07 CST 2021 from 192.168.122.6 on pts/0
[root@localhost ~]# cd /Data
[root@localhost Data]# chown -R oracle.oinstall /Data/
[root@localhost Data]# chown -R oracle.oinstall /Data/oradata/oraback/
[root@localhost Data]# chmod -R 775 /Data/oradata/oraback/
[root@localhost Data]# chown -R oracle:oinstall /Data/oradata/oraback/
[root@localhost Data]# su - oracle
Last login: Mon Nov 8 09:42:04 CST 2021 on pts/0
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:56:42 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12162: TNS:net service name is incorrectly specified
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 10:56:59 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=128 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 10:57:21
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/050dlcsh_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
new RMAN configuration parameters are successfully stored
RMAN> backup databases;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "application, archivelog, as, auxiliary, backuppiece, backupset, backup, channel, check, consistent, controlfilecopy, copies, copy, cumulative, current, database, database root, datafilecopy, datafile, datapump, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, passwordfile, pluggable, pool, proxy, recovery, reuse, section, skipoffline, skip readonly, skipinaccessible, spfile, tablespace, tag, to, validate, ("
RMAN-01008: the bad identifier was: databases
RMAN-01007: at line 1 column 8 file: standard input
RMAN> backup database;
Starting backup at 08-NOV-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:02:38
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/060dld6d_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> 鄂
RMAN>
RMAN>
RMAN> exit
Recovery Manager complete.
[oracle@localhost ~]$ cd /Data/oradata/oraback/
[oracle@localhost oraback]$ ls
[oracle@localhost oraback]$ ll
total 0
[oracle@localhost oraback]$ cd ..
[oracle@localhost oradata]$ ll
total 0
drwxrwxr-x 2 oracle oinstall 6 Nov 8 10:42 oraback
drwxr-xr-x 3 oracle oinstall 209 Nov 3 11:26 orcl
[oracle@localhost oradata]$ cd oraback/
[oracle@localhost oraback]$ cd ..
[oracle@localhost oradata]$ mkdir -p oraback_ctl
[oracle@localhost oradata]$ ll
total 0
drwxrwxr-x 2 oracle oinstall 6 Nov 8 10:42 oraback
drwxr-xr-x 2 oracle oinstall 6 Nov 8 11:06 oraback_ctl
drwxr-xr-x 3 oracle oinstall 209 Nov 3 11:26 orcl
[oracle@localhost oradata]$
[oracle@localhost oradata]$
[oracle@localhost oradata]$ cd /u01/app/oracle19/product/19.2.0.3/db_1/dbs/
[oracle@localhost dbs]$ ls
c-1614149235-20211027-00 c-1614149235-20211029-01 init.ora initorcl.ora.bak orapworcl spfileorcl.ora
c-1614149235-20211029-00 hc_orcl.dat initorcl.ora lkORCL snapcf_orcl.f spfileorcl.ora.bak
[oracle@localhost dbs]$ mv snapcf_orcl.f /Data/oradata/oraback_ctl/
[oracle@localhost dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:07:02 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> show all
2> ;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback_ctl/snapcf_orcl.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback_ctl/snapcf_orcl.f';
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback_ctl/snapcf_orcl.f';
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=128 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:07:54
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/070dldga_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost dbs]$
[oracle@localhost dbs]$
[oracle@localhost dbs]$
[oracle@localhost dbs]$ cd /Data/oradata/oraback_ctl/
[oracle@localhost oraback_ctl]$ mv snapcf_orcl.f /u01/app/oracle19/product/19.2.0.3/db_1/dbs/
[oracle@localhost oraback_ctl]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:09:13 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN>
RMAN>
RMAN>
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback_ctl/snapcf_orcl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
new RMAN configuration parameters are successfully stored
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=128 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:09:52
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/080dldjv_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost oraback_ctl]$ su - root
Password:
Last login: Mon Nov 8 10:55:24 CST 2021 on pts/0
[root@localhost ~]# chmor -R 777 /Data
bash: chmor: command not found...
[root@localhost ~]# chmod -R 777 /Data
[root@localhost ~]# su - oracle
Last login: Mon Nov 8 10:56:33 CST 2021 on pts/0
[oracle@localhost ~]$ cd /Data/
[oracle@localhost Data]$ ll
total 0
drwxrwxrwx 2 oracle oinstall 162 Nov 8 09:47 arch
drwxrwxrwx 5 oracle oinstall 52 Nov 8 11:06 oradata
[oracle@localhost Data]$ cd oradata/
[oracle@localhost oradata]$ ll
total 0
drwxrwxrwx 2 oracle oinstall 6 Nov 8 10:42 oraback
drwxrwxrwx 2 oracle oinstall 6 Nov 8 11:09 oraback_ctl
drwxrwxrwx 3 oracle oinstall 209 Nov 3 11:26 orcl
[oracle@localhost oradata]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:11:26 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12162: TNS:net service name is incorrectly specified
[oracle@localhost oradata]$ export ORACLE_SID=orcl
[oracle@localhost oradata]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:11:43 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=128 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:11:56
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/090dldns_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost oradata]$ ll
total 0
drwxrwxrwx 2 oracle oinstall 6 Nov 8 10:42 oraback
drwxrwxrwx 2 oracle oinstall 6 Nov 8 11:09 oraback_ctl
drwxrwxrwx 3 oracle oinstall 209 Nov 3 11:26 orcl
[oracle@localhost oradata]$ cd /u01/
[oracle@localhost u01]$ ll
total 0
drwxr-xr-x. 4 oracle oinstall 42 Oct 19 16:36 app
[oracle@localhost u01]$ su - root
Password:
Last login: Mon Nov 8 11:10:16 CST 2021 on pts/0
[root@localhost ~]# chmod -R 777 /u01
[root@localhost ~]# ch
bash: ch: command not found...
Similar command is: 'sh'
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# chown -R oracle.oinstall /u01
[root@localhost ~]# chmod -R 777 /u01
[root@localhost ~]# chown -R oracle.oinstall /Data
[root@localhost ~]# chmod -R 777 /Data
[root@localhost ~]# su - oracle
Last login: Mon Nov 8 11:11:07 CST 2021 on pts/0
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:19:25 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=128 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:19:36
ORA-19504: failed to create file "/u01/app/oracle19/product/19.2.0.3/db_1/dbs/ /Data/oradata/oraback/0a0dle67_1_1_ORCL/20211108 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:21:46 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
shconnected to target database: ORCL (DBID=1614149235, not open)
RMAN> show all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release"
RMAN-01008: the bad identifier was: shshow
RMAN-01007: at line 1 column 1 file: standard input
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN>
RMAN>
RMAN>
RMAN> configure channel device type disk format '/Data/oradata/oraback/%U_%d/%T';
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' /Data/oradata/oraback/%U_%d/%T ';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
new RMAN configuration parameters are successfully stored
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=124 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:33:28
ORA-19504: failed to create file "/Data/oradata/oraback/0b0dlf08_1_1_ORCL/20211108"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> configure channel device type disk format '/Data/oradata/oraback/%U_%d/%T/%U';
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T/%U';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=124 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:38:41
ORA-19504: failed to create file "/Data/oradata/oraback/0c0dlfa1_1_1_ORCL/20211108/0c0dlfa1_1_1"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost ~]$ cd /Data/oradata/oraback
[oracle@localhost oraback]$ cd ..
[oracle@localhost oradata]$ ll
total 0
drwxrwxrwx 2 oracle oinstall 6 Nov 8 10:42 oraback
drwxrwxrwx 2 oracle oinstall 6 Nov 8 11:09 oraback_ctl
drwxrwxrwx 3 oracle oinstall 209 Nov 3 11:26 orcl
[oracle@localhost oradata]$ cd oraback
[oracle@localhost oraback]$ mkdir -p 0c0dlfa1_1_1_ORCL/20211108
[oracle@localhost oraback]$ ls
0c0dlfa1_1_1_ORCL
[oracle@localhost oraback]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:43:24 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=125 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:43:32
ORA-19504: failed to create file "/Data/oradata/oraback/0d0dlfj4_1_1_ORCL/20211108/0d0dlfj4_1_1"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost oraback]$ ll
total 0
drwxr-xr-x 3 oracle oinstall 22 Nov 8 11:43 0c0dlfa1_1_1_ORCL
[oracle@localhost oraback]$ rm -f 0c0dlfa1_1_1_ORCL/
rm: cannot remove ‘0c0dlfa1_1_1_ORCL/’: Is a directory
[oracle@localhost oraback]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:46:08 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> run(sql 'alter database noarchivelog';}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "(": expecting one of: "{"
RMAN-01007: at line 1 column 4 file: standard input
RMAN> startup mount;
database is already started
RMAN> run(sql 'alter database noarchivelog';}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "(": expecting one of: "{"
RMAN-01007: at line 1 column 4 file: standard input
RMAN> run(sql'alter database noarchivelog';}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "(": expecting one of: "{"
RMAN-01007: at line 1 column 4 file: standard input
RMAN> run{sql'alter database noarchivelog';}
using target database control file instead of recovery catalog
sql statement: alter database noarchivelog
RMAN> run{sql 'alter database open';}
sql statement: alter database open
RMAN> backup database format '/Data/oradata/oraback%U.bak';
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=249 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/08/2021 11:48:34
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
RMAN> run{sql'alter database archivelog';}
sql statement: alter database archivelog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 11/08/2021 11:49:26
RMAN-11003: failure during parse/execution of SQL statement: alter database archivelog
ORA-01126: database must be mounted in this instance and not open in any instance
RMAN> exit
Recovery Manager complete.
[oracle@localhost oraback]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 8 11:49:45 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 385875968 bytes
Database Buffers 788529152 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost oraback]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:54:51 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235)
RMAN> shutdown immediate;
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 385875968 bytes
Database Buffers 788529152 bytes
Redo Buffers 7880704 bytes
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=363 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:55:53
ORA-19504: failed to create file "/Data/oradata/oraback/0e0dlga8_1_1_ORCL/20211108/0e0dlga8_1_1"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@localhost oraback]$ cd ..
[oracle@localhost oradata]$ cd ..
[oracle@localhost Data]$ mkdir -p oraback
[oracle@localhost Data]$ ll
total 0
drwxrwxrwx 2 oracle oinstall 162 Nov 8 09:47 arch
drwxr-xr-x 2 oracle oinstall 6 Nov 8 11:58 oraback
drwxrwxrwx 5 oracle oinstall 52 Nov 8 11:06 oradata
[oracle@localhost Data]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 11:58:50 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> configure channel device type disk format '/Data/oraback/%U_%d/%T/%U';
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T/%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oraback/%U_%d/%T/%U';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oraback/%T/%F/%U';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oraback/%T/%F/%U';
new RMAN configuration parameters are successfully stored
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=355 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:59:32
ORA-19504: failed to create file "/Data/oraback/0f0dlgh3_1_1_ORCL/20211108/0f0dlgh3_1_1"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oraback/%T/%F/%U';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
new RMAN configuration parameters are successfully stored
RMAN> backup database;
Starting backup at 08-NOV-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 11:59:58
ORA-19504: failed to create file "/Data/oraback/0g0dlghu_1_1_ORCL/20211108/0g0dlghu_1_1"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> configure channel device type disk format '/Data/oradata/oraback/%U_%d/%T/%U';
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oraback/%U_%d/%T/%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T/%U';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
new RMAN configuration parameters are successfully stored
RMAN> configure channel device type disk format '/Data/oradata/oraback/%U_%d/%T';
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T/%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F/%U';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
new RMAN configuration parameters are successfully stored
RMAN> exit
Recovery Manager complete.
[oracle@localhost Data]$ cd /u01/app/oracle19/product/19.2.0.3/db_1/dbs/
[oracle@localhost dbs]$ ls
c-1614149235-20211027-00 c-1614149235-20211029-01 init.ora initorcl.ora.bak orapworcl spfileorcl.ora
c-1614149235-20211029-00 hc_orcl.dat initorcl.ora lkORCL snapcf_orcl.f spfileorcl.ora.bak
[oracle@localhost dbs]$ mv snapcf_orcl.f /Data/oradata/oraback/
[oracle@localhost dbs]$ ls
c-1614149235-20211027-00 c-1614149235-20211029-01 init.ora initorcl.ora.bak orapworcl spfileorcl.ora.bak
c-1614149235-20211029-00 hc_orcl.dat initorcl.ora lkORCL spfileorcl.ora
[oracle@localhost dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 12:04:48 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 12:04:55
ORA-19504: failed to create file "/Data/oradata/oraback/0h0dlgr7_1_1_ORCL/20211108"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN>
RMAN>
RMAN>
RMAN> SHOW ALL;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
RMAN> configure channel device type disk format '/Data/oradata/oraback/%U_%d/%T';
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/Data/oradata/oraback/snapcf_orcl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
new RMAN configuration parameters are successfully stored
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 14:19:49
ORA-19504: failed to create file "/Data/oradata/oraback/0i0dloo4_1_1_ORCL/20211108"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> backup database;
Starting backup at 08-NOV-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 14:27:11
ORA-19504: failed to create file "/Data/oradata/oraback/0j0dlp5v_1_1_ORCL/20211108"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN> configure channel device type disk format # default;
2> ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "new, double-quoted-string, single-quoted-string, "
RMAN-01007: at line 2 column 1 file: standard input
RMAN> configure channel device type disk format; # default
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "new, double-quoted-string, single-quoted-string, "
RMAN-01007: at line 1 column 42 file: standard input
RMAN> configure channel 1 device type disk format '/Data/oradata/oraback/%U_%d/%T';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 14:30:15
ORA-19504: failed to create file "/Data/oradata/oraback/0k0dlpbn_1_1_ORCL/20211108"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> backup database plus archivelog;
Starting backup at 08-NOV-21
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 11/08/2021 14:36:38
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle19/audit/archive/1_1_1087055913.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
RMAN> ^C
user interrupt received
RMAN>
RMAN> change archivelog all crosscheck ;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 device type=DISK
validation failed for archived log
archived log file name=/u01/app/oracle19/audit/archive/1_1_1087055913.dbf RECID=34 STAMP=1087119239
validation failed for archived log
archived log file name=/Data/arch/1_2_1087055913.dbf RECID=35 STAMP=1087125741
validation failed for archived log
archived log file name=/Data/arch/1_3_1087055913.dbf RECID=36 STAMP=1087125741
validation succeeded for archived log
archived log file name=/Data/arch/1_4_1087055913.dbf RECID=37 STAMP=1087126041
validation succeeded for archived log
archived log file name=/Data/arch/1_5_1087055913.dbf RECID=38 STAMP=1087209164
validation succeeded for archived log
archived log file name=/Data/arch/1_6_1087055913.dbf RECID=39 STAMP=1087471141
validation succeeded for archived log
archived log file name=/Data/arch/1_7_1087055913.dbf RECID=40 STAMP=1087638846
validation succeeded for archived log
archived log file name=/Data/arch/1_8_1087055913.dbf RECID=41 STAMP=1088070284
validation succeeded for archived log
archived log file name=/Data/arch/1_9_1087055913.dbf RECID=42 STAMP=1088070466
Crosschecked 9 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
34 1 1 X 27-OCT-21
Name: /u01/app/oracle19/audit/archive/1_1_1087055913.dbf
35 1 2 X 28-OCT-21
Name: /Data/arch/1_2_1087055913.dbf
36 1 3 X 28-OCT-21
Name: /Data/arch/1_3_1087055913.dbf
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archived log
archived log file name=/u01/app/oracle19/audit/archive/1_1_1087055913.dbf RECID=34 STAMP=1087119239
deleted archived log
archived log file name=/Data/arch/1_2_1087055913.dbf RECID=35 STAMP=1087125741
deleted archived log
archived log file name=/Data/arch/1_3_1087055913.dbf RECID=36 STAMP=1087125741
Deleted 3 EXPIRED objects
RMAN> backup database plus archivelog;
Starting backup at 08-NOV-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=37 STAMP=1087126041
input archived log thread=1 sequence=5 RECID=38 STAMP=1087209164
input archived log thread=1 sequence=6 RECID=39 STAMP=1087471141
input archived log thread=1 sequence=7 RECID=40 STAMP=1087638846
input archived log thread=1 sequence=8 RECID=41 STAMP=1088070284
input archived log thread=1 sequence=9 RECID=42 STAMP=1088070466
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 11/08/2021 14:50:07
ORA-19504: failed to create file "/Data/oradata/oraback/0l0dlqgv_1_1_ORCL/20211108"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN> configure retention policy clear;
RMAN configuration parameters are successfully reset to default value
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN> configure retention policy clear;
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN> exit
Recovery Manager complete.
[oracle@localhost dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 15:06:40 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
showconnected to target database: ORCL (DBID=1614149235, not open)
RM
RMAN>
RMAN>
RMAN>
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN> CONFIGURE BACKUP OPTIMIZATION CLEAR;
RMAN configuration parameters are successfully reset to default value
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN> CONFIGURE RETENTION POLICY CLEAR;
RMAN configuration parameters are successfully reset to default value
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Data/oradata/oraback/%T/%F';
RMAN configuration parameters are successfully reset to default value
RMAN> show all
2> ;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT clear;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "clear": expecting one of: "new, double-quoted-string, single-quoted-string, "
RMAN-01007: at line 1 column 43 file: standard input
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "clear": expecting one of: "new, double-quoted-string, single-quoted-string, "
RMAN-01007: at line 1 column 43 file: standard input
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "clear": expecting one of: "new, double-quoted-string, single-quoted-string, "
RMAN-01007: at line 1 column 43 file: standard input
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT CLEAR;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "clear": expecting one of: "new, double-quoted-string, single-quoted-string, "
RMAN-01007: at line 1 column 45 file: standard input
RMAN> CONFIGURE SNAPSHOT CONTROLFILE CLEAR;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "clear": expecting one of: "name"
RMAN-01007: at line 1 column 32 file: standard input
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "clear": expecting one of: "new, double-quoted-string, single-quoted-string, "
RMAN-01007: at line 1 column 44 file: standard input
RMAN> CONFIGURE RETENTION POLICY clear;
CONFIGURE BACKUP OPTIMIZATION clear;
CONFIGURE DEFAULT DEVICE TYPE clear;
CONFIGURE CONTROLFILE AUTOBACKUP clear;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK clear;
CONFIGURE DEVICE TYPE DISK clear;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK clear;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK clear;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK clear;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK clear;
CONFIGURE MAXSETSIZE clear;
CONFIGURE ENCRYPTION FOR DATABASE clear;
CONFIGURE ENCRYPTION ALGORITHM clear;
CONFIGURE COMPRESSION ALGORITHM clear;
CONFIGURE RMAN OUTPUT clear; # 12c
CONFIGURE ARCHIVELOG DELETION POLICY clear;
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
————————————————
版权声明：本文为CSDN博主「贤时间」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/x6_9x/article/details/50300099RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
old RMAN configuration parameters are successfully deleted
RMAN>
old RMAN configuration parameters are successfully deleted
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f';
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release"
RMAN-01008: the bad identifier was: ————————————————
RMAN-01007: at line 1 column 1 file: standard input
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release"
RMAN-01008: the bad identifier was: ▒
RMAN-01007: at line 1 column 1 file: standard input
RMAN> CONFIGURE RETENTION POLICY clear;
CONFIGURE BACKUP OPTIMIZATION clear;
CONFIGURE DEFAULT DEVICE TYPE clear;
CONFIGURE CONTROLFILE AUTOBACKUP clear;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK clear;
CONFIGURE DEVICE TYPE DISK clear;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK clear;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK clear;
CONFIGURE CHANNEL DEVICE TYPE DISK clear;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK clear;
CONFIGURE MAXSETSIZE clear;
CONFIGURE ENCRYPTION FOR DATABASE clear;
CONFIGURE ENCRYPTION ALGORITHM clear;
CONFIGURE COMPRESSION ALGORITHM clear;
CONFIGURE RMAN OUTPUT clear; # 12c
CONFIGURE ARCHIVELOG DELETION POLICY clear;
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release"
RMAN-01008: the bad identifier was: 原文▒
RMAN-01007: at line 1 column 1 file: standard input
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
old RMAN configuration parameters are successfully deleted
RMAN>
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/Data/oradata/oraback/%U_%d/%T';
old RMAN configuration parameters are successfully deleted
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN>
RMAN configuration parameters are successfully reset to default value
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f'; # default
RMAN> backup database;
Starting backup at 08-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
channel ORA_DISK_1: finished piece 1 at 08-NOV-21
piece handle=/u01/app/oracle19/product/19.2.0.3/db_1/dbs/0m0dls2e_1_1 tag=TAG20211108T151630 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 08-NOV-21
Starting Control File and SPFILE Autobackup at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 11/08/2021 15:16:46
ORA-01580: error creating control backup file /u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 4
RMAN> ^C
user interrupt received
RMAN>
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f'; # default
RMAN> backup database;
Starting backup at 08-NOV-21
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/08/2021 15:27:47
ORA-01013: user requested cancel of current operation
RMAN> exit
Recovery Manager complete.
[oracle@localhost dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 15:28:08 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
channel ORA_DISK_1: finished piece 1 at 08-NOV-21
piece handle=/u01/app/oracle19/product/19.2.0.3/db_1/dbs/0o0dlsoi_1_1 tag=TAG20211108T152818 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 08-NOV-21
Starting Control File and SPFILE Autobackup at 08-NOV-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 11/08/2021 15:28:27
ORA-01580: error creating control backup file /u01/app/oracle19/product/19.2.0.3/db_1/dbs/snapcf_orcl.f
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 4
RMAN> exit
Recovery Manager complete.
[oracle@localhost dbs]$ ll
total 1534400
-rw-r----- 1 oracle oinstall 763633664 Nov 8 15:16 0m0dls2e_1_1
-rw-r----- 1 oracle oinstall 763633664 Nov 8 15:28 0o0dlsoi_1_1
-rwxrwxrwx 1 oracle oinstall 11010048 Oct 27 15:58 c-1614149235-20211027-00
-rwxrwxrwx 1 oracle oinstall 11010048 Oct 29 11:28 c-1614149235-20211029-00
-rwxrwxrwx 1 oracle oinstall 11010048 Oct 29 11:55 c-1614149235-20211029-01
-rwxrwxrwx. 1 oracle oinstall 1544 Nov 8 11:55 hc_orcl.dat
-rwxrwxrwx. 1 oracle oinstall 3079 May 14 2015 init.ora
-rwxrwxrwx 1 oracle oinstall 1006 Oct 23 17:16 initorcl.ora
-rwxrwxrwx 1 oracle oinstall 2197 Oct 23 17:02 initorcl.ora.bak
-rwxrwxrwx. 1 oracle oinstall 24 Oct 19 17:01 lkORCL
-rw-r-----. 1 oracle oinstall 2560 Oct 27 16:22 orapworcl
-rw-r--r-- 1 root root 10895360 Nov 8 14:27 snapcf_orcl.f
-rwxrwxrwx 1 oracle oinstall 3584 Nov 8 11:55 spfileorcl.ora
-rwxrwxrwx 1 oracle oinstall 3584 Oct 23 17:03 spfileorcl.ora.bak
[oracle@localhost dbs]$ chown -R oracle.oinstall snapcf_orcl.f
chown: changing ownership of ‘snapcf_orcl.f’: Operation not permitted
[oracle@localhost dbs]$ su - root
Password:
Last login: Mon Nov 8 11:17:44 CST 2021 on pts/0
[root@localhost ~]# chown -R oracle.oinstall /u01
[root@localhost ~]# su - oracle
Last login: Mon Nov 8 11:19:12 CST 2021 on pts/0
[oracle@localhost ~]$ cd $ORACLE_HOME
[oracle@localhost db_1]$ ls
addnode deinstall jdk odbc QOpatch sqldeveloper
apex demo jlib olap R sqlj
assistants diagnostics kmod-20-28.el7.x86_64.rpm OPatch racg sqlpatch
bin dmu kmod-devel-20-28.el7.x86_64.rpm opmn rdbms sqlplus
cfgtoollogs drdaas kmod-kvdo-6.1.3.23-5.el7.x86_64.rpm oracore relnotes srvm
clone dv kmod-oracleasm-2.0.8-28.el7.x86_64.rpm oraInst.loc root.sh suptools
compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm env.ora ldap ord root.sh.old ucp
crs has lib ords root.sh.old.1 usm
css hs LINUX.X64_193000_db_home.zip oss root.sh.old.2 utl
ctx install log oui root.sh.old.3 wwg
cv instantclient md owm runInstaller xdk
data inventory mgw perl schagent.conf
dbjava javavm network plsql sdk
dbs jdbc nls precomp slax
[oracle@localhost db_1]$ cd dbs
[oracle@localhost dbs]$ ls
0m0dls2e_1_1 c-1614149235-20211027-00 c-1614149235-20211029-01 init.ora initorcl.ora.bak orapworcl spfileorcl.ora
0o0dlsoi_1_1 c-1614149235-20211029-00 hc_orcl.dat initorcl.ora lkORCL snapcf_orcl.f spfileorcl.ora.bak
[oracle@localhost dbs]$ ll
total 1534400
-rw-r----- 1 oracle oinstall 763633664 Nov 8 15:16 0m0dls2e_1_1
-rw-r----- 1 oracle oinstall 763633664 Nov 8 15:28 0o0dlsoi_1_1
-rwxrwxrwx 1 oracle oinstall 11010048 Oct 27 15:58 c-1614149235-20211027-00
-rwxrwxrwx 1 oracle oinstall 11010048 Oct 29 11:28 c-1614149235-20211029-00
-rwxrwxrwx 1 oracle oinstall 11010048 Oct 29 11:55 c-1614149235-20211029-01
-rwxrwxrwx. 1 oracle oinstall 1544 Nov 8 11:55 hc_orcl.dat
-rwxrwxrwx. 1 oracle oinstall 3079 May 14 2015 init.ora
-rwxrwxrwx 1 oracle oinstall 1006 Oct 23 17:16 initorcl.ora
-rwxrwxrwx 1 oracle oinstall 2197 Oct 23 17:02 initorcl.ora.bak
-rwxrwxrwx. 1 oracle oinstall 24 Oct 19 17:01 lkORCL
-rw-r-----. 1 oracle oinstall 2560 Oct 27 16:22 orapworcl
-rw-r--r-- 1 oracle oinstall 10895360 Nov 8 14:27 snapcf_orcl.f
-rwxrwxrwx 1 oracle oinstall 3584 Nov 8 11:55 spfileorcl.ora
-rwxrwxrwx 1 oracle oinstall 3584 Oct 23 17:03 spfileorcl.ora.bak
[oracle@localhost dbs]$ export ORACLE_SID=orcl
[oracle@localhost dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 15:30:53 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235, not open)
RMAN> backup database;
Starting backup at 08-NOV-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=243 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/Data/oradata/orcl/undotbs01.dbf
input datafile file number=00001 name=/Data/oradata/orcl/system01.dbf
input datafile file number=00002 name=/Data/oradata/orcl/sysaux01.dbf
input datafile file number=00006 name=/Data/oradata/orcl/data.dbf
input datafile file number=00005 name=/Data/oradata/orcl/hwm_test.dbf
input datafile file number=00009 name=/Data/oradata/orcl/data1.dbf
input datafile file number=00010 name=/Data/oradata/orcl/data2.dbf
input datafile file number=00004 name=/Data/oradata/orcl/users01.dbf
input datafile file number=00007 name=/Data/oradata/orcl/data_ind.dbf
input datafile file number=00008 name=/Data/oradata/orcl/data_ind1.dbf
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
channel ORA_DISK_1: finished piece 1 at 08-NOV-21
piece handle=/u01/app/oracle19/product/19.2.0.3/db_1/dbs/0q0dlsto_1_1 tag=TAG20211108T153103 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-NOV-21
Starting Control File and SPFILE Autobackup at 08-NOV-21
piece handle=/u01/app/oracle19/product/19.2.0.3/db_1/dbs/c-1614149235-20211108-00 comment=NONE
Finished Control File and SPFILE Autobackup at 08-NOV-21
RMAN> alter database open;
Statement processed
RMAN> exit
Recovery Manager complete.
[oracle@localhost dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 8 16:19:24 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=/Data/arch
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost dbs]$ cd /Data/arch
[oracle@localhost arch]$ ll
total 279996
-rwxrwxrwx 1 oracle oinstall 7000064 Oct 28 11:27 1_4_1087055913.dbf
-rwxrwxrwx 1 oracle oinstall 65687040 Oct 29 10:32 1_5_1087055913.dbf
-rwxrwxrwx 1 oracle oinstall 37658624 Nov 1 11:19 1_6_1087055913.dbf
-rwxrwxrwx 1 oracle oinstall 42121728 Nov 3 09:54 1_7_1087055913.dbf
-rwxrwxrwx 1 oracle oinstall 132231168 Nov 8 09:44 1_8_1087055913.dbf
-rwxrwxrwx 1 oracle oinstall 2013184 Nov 8 09:47 1_9_1087055913.dbf
[oracle@localhost arch]$ mkdir -p arch1
[oracle@localhost arch]$ cd arch1/
[oracle@localhost arch1]$ pwd
/Data/arch/arch1
[oracle@localhost arch1]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Nov 8 16:24:42 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1614149235)
RMAN> backup as compressed backupset archivelog all delete input format '/Data/arch/arch1/archivelog_%d_%I_%s_%p_%T';
Starting backup at 08-NOV-21
Oracle error from target database:
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=254 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=37 STAMP=1087126041
input archived log thread=1 sequence=5 RECID=38 STAMP=1087209164
input archived log thread=1 sequence=6 RECID=39 STAMP=1087471141
input archived log thread=1 sequence=7 RECID=40 STAMP=1087638846
input archived log thread=1 sequence=8 RECID=41 STAMP=1088070284
input archived log thread=1 sequence=9 RECID=42 STAMP=1088070466
channel ORA_DISK_1: starting piece 1 at 08-NOV-21
channel ORA_DISK_1: finished piece 1 at 08-NOV-21
piece handle=/Data/arch/arch1/archivelog_ORCL_1614149235_28_1_20211108 tag=TAG20211108T162447 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/Data/arch/1_4_1087055913.dbf RECID=37 STAMP=1087126041
archived log file name=/Data/arch/1_5_1087055913.dbf RECID=38 STAMP=1087209164
archived log file name=/Data/arch/1_6_1087055913.dbf RECID=39 STAMP=1087471141
archived log file name=/Data/arch/1_7_1087055913.dbf RECID=40 STAMP=1087638846
archived log file name=/Data/arch/1_8_1087055913.dbf RECID=41 STAMP=1088070284
archived log file name=/Data/arch/1_9_1087055913.dbf RECID=42 STAMP=1088070466
Finished backup at 08-NOV-21
Starting Control File and SPFILE Autobackup at 08-NOV-21
piece handle=/u01/app/oracle19/product/19.2.0.3/db_1/dbs/c-1614149235-20211108-01 comment=NONE
Finished Control File and SPFILE Autobackup at 08-NOV-21
RMAN>
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
