Hello folks;
I defined a crontab task (on the oracle linux user at 2 PM o'clock everyday) to compress and backup the database Oracle 11.2.0.3.0 with this script :
login="sys/<passwd> as sysdba"
sqlplus -s "$login" << EOF
shutdown immediate;
exit;
EOF
echo 'compress base DBSAVE...'
date
tar -cvf - /data5/oradata/DBSAVE/DBSAVE | gzip > /data4/sauvOracle/DBSAVE.$DATE_FILE.tar.gz
echo 'end of compression of DBSAVE...'
date
sqlplus -s "$login" << EOF
startup;
exit;
EOF
But i get this issue everyday :
Wed Jul 11 02:00:13 2012
Instance shutdown complete
Wed Jul 11 02:15:31 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options.
Using parameter settings in server-side spfile /app1/oracle/product/11.2.0/db_1/dbs/spfileDBSAVE.ora
System parameters with non-default values:
processes = 150
nls_language = "FRENCH"
nls_territory = "FRANCE"
nls_length_semantics = "CHAR"
sga_target = 408M
control_files = "/data5/oradata/DBSAVE/DBSAVE/control01.ctl"
control_files = "/data1/oradata/flash_recovery_area/DBSAVE/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/data1/oradata/flash_recovery_area"
db_recovery_file_dest_size= 4977M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(protocol=TCP)"
shared_servers = 1
job_queue_processes = 1000
audit_file_dest = "/data1/oradata/admin/DBSAVE/adump"
audit_trail = "DB"
db_name = "DBSAVE"
open_cursors = 300
pga_aggregate_target = 135M
diagnostic_dest = "/data1/oradata"
Wed Jul 11 02:15:33 2012
PMON started with pid=2, OS id=7453
Wed Jul 11 02:15:33 2012
VKTM started with pid=3, OS id=7455 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Wed Jul 11 02:15:33 2012
GEN0 started with pid=4, OS id=7459
Wed Jul 11 02:15:33 2012
DIAG started with pid=5, OS id=7461
Wed Jul 11 02:15:33 2012
DBRM started with pid=6, OS id=7463
Wed Jul 11 02:15:33 2012
PSP0 started with pid=7, OS id=7465
Wed Jul 11 02:15:33 2012
DIA0 started with pid=8, OS id=7467
Wed Jul 11 02:15:34 2012
MMAN started with pid=9, OS id=7469
Wed Jul 11 02:15:34 2012
DBW0 started with pid=10, OS id=7471
Wed Jul 11 02:15:34 2012
LGWR started with pid=11, OS id=7473
Wed Jul 11 02:15:34 2012
CKPT started with pid=12, OS id=7475
Wed Jul 11 02:15:34 2012
SMON started with pid=13, OS id=7477
Wed Jul 11 02:15:34 2012
RECO started with pid=14, OS id=7479
Wed Jul 11 02:15:34 2012
MMON started with pid=15, OS id=7481
Wed Jul 11 02:15:34 2012
MMNL started with pid=16, OS id=7483
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Reusing ORACLE_BASE from an earlier startup = /data1/oradata
Wed Jul 11 02:15:35 2012
ALTER DATABASE MOUNT
ORA-00210: ouverture impossible du fichier de controle indique
ORA-00202: fichier de controle : '/data1/oradata/flash_recovery_area/DBSAVE/control02.ctl'
ORA-27086: impossible de verrouiller le fichier - en cours d'utilisation
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 17566
ORA-00210: ouverture impossible du fichier de controle indique
ORA-00202: fichier de controle : '/data5/oradata/DBSAVE/DBSAVE/control01.ctl'
ORA-27086: impossible de verrouiller le fichier - en cours d'utilisation
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 17566
ORA-205 signalled during: ALTER DATABASE MOUNT...
Wed Jul 11 02:15:36 2012
Checker run found 2 new persistent data failures
The control files exist :
-rw-r----- 1 oracle oinstall 9748480 Jul 11 10:33 /data1/oradata/flash_recovery_area/DBSAVE/control02.ctl
-rw-r----- 1 oracle oinstall 9748480 Jul 11 10:33 /data5/oradata/DBSAVE/DBSAVE/control01.ctl
What's the matter ?
There is a patch to apply ?
Thanks for your help, regards.