Hi, I try to make a backup with Octopus from an Oracle database, but controller throws exception "ORA-00942: table or view does not exist". Controller logs Working....DR$POLICY_TAB but DR$POLICY_TAB is not a table from my shema
My virtual database configuration is set to static schema (<DatabaseSchema dynamicPrecision="static"> with all my tables described) I set log4j to debug and see on controller initialization 11:47:29,584 DEBUG controller.virtualdatabase.db Backend xxx added successfully 11:47:29,631 DEBUG sequoia.controller.recoverylog Connection to jdbc:oracle:thin:@xxx:1521:xxx as user xxx 11:47:29,866 DEBUG sequoia.controller.recoverylog Log table create statement: CREATE TABLE SEQ_RECOVERY (log_id NUMBER(1 2) NOT NULL,vlogin VARCHAR2(255) NOT NULL,sqlStmt VARCHAR2(4000)NOT NULL,sqlStmt_param VARCHAR2(4000),auto_conn_tran CHA R(1) NOT NULL,transaction_id NUMBER(12) NOT NULL,request_id NUMBER(12),exec_status CHAR(1) NOT NULL,exec_time NUMBER(12) ,update_count NUMBER(8),PRIMARY KEY (log_id)) 11:47:29,866 DEBUG sequoia.controller.recoverylog Checkpoint table create statement: CREATE TABLE SEQ_CHECKPOINT (name V ARCHAR2(255) NOT NULL,log_id NUMBER(12),PRIMARY KEY (name)) 11:47:29,866 DEBUG sequoia.controller.recoverylog Backend table create statement: CREATE TABLE SEQ_BACKEND (database_nam e VARCHAR2(255) NOT NULL, backend_name VARCHAR2(255),backend_state INTEGER, checkpoint_name VARCHAR2(255) ) 11:47:29,866 DEBUG sequoia.controller.recoverylog Dump table create statement: CREATE TABLE SEQ_DUMP (dump_name VARCHAR2 (255) NOT NULL,dump_date DATE,dump_path VARCHAR2(255) NOT NULL,dump_format VARCHAR2(255) NOT NULL,checkpoint_name VARCHA R2(255) NOT NULL,backend_name VARCHAR2(255) NOT NULL,tables VARCHAR2(255) NOT NULL) 11:47:30,069 DEBUG sequoia.controller.recoverylog Table found: DR$POLICY_TAB 11:47:30,069 DEBUG sequoia.controller.recoverylog Table found: CS_SRS 11:47:30,069 DEBUG sequoia.controller.recoverylog Table found: OGIS_SPATIAL_REFERENCE_SYSTEMS .. .. with many table I did not describe in configuration 1) why sequoia see those tables, despite I gave a static shema ? 2) what should I do to perform my backup ? Thanks in advance Pierre This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. Security Notice: all e-mail, sent to or from this address, may be accessed by someone other than the recipient, for system management and security reasons. This access is controlled under Regulation of security reasons. This access is controlled under Regulation of Investigatory Powers Act 2000, Lawful Business Practises. _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
