Chcete-li zálohovat databázi na nějakou síťovou storage, tak se musíte držet základních pravidel, která jsou popsané v této note How to Configure RMAN to Write to Shared Drives on Windows…
[oracle@dbserver1]$ emca -config dbcontrol db -repos recreate -cluster STARTED EMCA at May 20, 2015 11:24:44 AM EM Configuration Assistant, Version 10.2.0.5.0 Production Copyright (c) 2003, 2009, Oracle. All rights reserved….
SYS@rac1> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 2200 Next log sequence to archive 2203 Current log sequence 2203…
ORA-00245: control file backup failed; target is likely on a local file system RMAN-08132: WARNING: cannot update recovery area reclaimable file list RMAN> show all; … CONFIGURE SNAPSHOT CONTROLFILE NAME…
Chyba 1. ORA-31693: Table data object “USER1″.”DOC” failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-01555: snapshot too old: rollback segment number 11…
SQL> select JOB_ID, JOB_NAME, JOB_DESCRIPTION from sysman.mgmt_job; JOB_ID ——————————– JOB_NAME —————————————————————- JOB_DESCRIPTION ——————————————————————————– 0DB38BB49E3AE3F7E050A8C0030C1D0F BACKUP_ABRA_HOURLY_INCREMENT Whole Database Backup SQL> begin sysman.mgmt_jobs.stop_all_executions(‘BACKUP_ABRA_HOURLY_INCREMENT’,’SYS’); sysman.mgmt_jobs.delete_job(‘BACKUP_ABRA_HOURLY_INCREMENT’,’SYS’); end; / 2 3 4 5 begin *…
Alert.log Mon Feb 02 22:00:03 2015 Errors in file /opt/oracle/app/oracle/diag/rdbms/prod/prod/trace/prod_j004_14211.trc: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SQ_SQL_SW_6362″ ORA-13717: Tuning Package License is needed for using this feature. ORA-06512: at…
SQL> select group#,sequence#,bytes,archived,status from v$log; GROUP# SEQUENCE# BYTES ARC STATUS ———- ———- ———- — —————- 1 25495 52428800 NO INACTIVE 2 25496 52428800 NO ACTIVE 3 25497 52428800 NO CURRENT…
