Oracle 11D Backup - ORA-19554 und ORA-27211
Hallo zusammen, ich versuche ein Backup einer Oracle Datenbank zu erstellen, welches immer fehl schlägt. Hier erstmal eine Aufstellung der eingesetzten Systeme: Backup-Server: Windows Server 2008 R2 Enterprise, Backup Exec 15 (Version 14.2 Rev. 1180) Oracle-Server: Windows Server 2003 Standard, Oracle 11d (laut Adminkonsole) oder 11g (laut Eintrag im Startmenü) (wo kann man das genau nachgucken? In der Systemsteuerung unter Software findet sich kein Oracle Eintrag) Ich bin nach dem Handbuch vorgegangen, also Punkt H. Dennoch kommt immer folgender Fehler: Sichern- Oracle-Win::\\<Servername>\<DB-Name> Das Datenbankskript gab einen Fehler zurück. Details finden Sie im Abschnitt für die Skriptausgabe in den Auftragsprotokollen. Und hier die Details zum Script: Recovery Manager: Release 11.2.0.1.0 - Production on Do Nov 26 12:17:12 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Mit Ziel-Datenbank verbunden: <DB-Name>(DBID=1052354931) # ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO 'BE_'; ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE'; SEND 'BSA_SERVICE_HOST=<BE-Server-IP>,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={8B34ECAA-72B5-47CD-B3CC-581CFDF12C55},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\<Servername>\<DB-Name>'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'BE_U' DATABASE FORCE PLUS ARCHIVELOG FORCE DELETE INPUT; BACKUP CURRENT CONTROLFILE FORMAT 'BE_U'; RELEASE CHANNEL ch0; } Befehl wird ausgeführt: SET CONTROLFILE AUTOBACKUP FORMAT Kontrolldatei der Zieldatenbank wird anstelle des Recovery-Katalogs verwendet RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: Fehler bei allocate Befehl in ch0 Kanal auf 11/26/2015 12:17:16 ORA-19554: Fehler beim Zuweisen von Gerät, Gerättyp: SBT_TAPE, Gerätname: ORA-27211: Media Management Library konnte nicht geladen werden EXIT Recovery Manager abgeschlossen. Erreichte Geräte: 1 Genutzte Datenströme: 0 Ich kenn mich 0 mit Oracle an sich aus, vermute aber den Fehler in der fett markierten Zeile. Denke, er weiß nicht, dass er die RMAN Backups auf das Band schreiben muss. Hab schon so einige Forenbeiträge hier via google gefunden, doch keiner hat mir geholfen. Daher mal ein paar Frage: - Muss ich außer dem Agent auf dem Oracle Server auch noch was konfigurieren (z.B. ein RMAN Script)? - Wie sage ich dem Backup, dass es aufs Tape gehört? - Oder liege ich mit meiner Vermutung komplett falsch? Danke Schon mal für eure Hilfe. Gruß Stephan.
Configure Oracle Agent (12c RAC DB) on Linux (OL6u5)
I am configuring Oracle Agent on Linux and have a few questions about setup. Environment Description Oracle Grid Infrastructure 12.1.0.2.3 (Oracle ASM 12.1.0.2.3 configured) Oracle Database 12.1.0.2.3 with Real Application Cluster option (2 node cluster) and Single Tenant (multitenant option) The cluster files, data files and recovery files are on Oracle Automatic Storage Management (ASM). The Oracle software is installed on local driver ext4. Page# reference Backup Exec 15 Administration Guide *************************************************************************** INSTALLING THE AGENT ON LINUX PAGE 1193 *************************************************************************** Installed Agent on Linux as ROOT user ******************************************************************************************** CONFIGURING AN ORACLE INSTANCE ON LINUX SERVERS PAGE 988 ******************************************************************************************** 9/22/2015 QUESTION Is the logon OS user who starts AgentConfig for Oracle Instance configuration REQUIRED to have ROOT privilege? 9/22/2015 QUESTION Is the logon OS user who starts AgentConfig for Oracle Instance configuration REQUIRED to be part of BEOPER group? 9/22/2015 QUESTION Is the logon OS user who starts AgentConfig for Oracle Instance configuration REQUIRED to have any other privileges? 6 Enter the name of the Oracle instance in upper case characters. For example, ORACLENAME. PAGE 980 The name is in the format RAC-<dbname>-<dbid>, where dbname is the database name, and dbid is the database ID. 9/22/2015 QUESTION <dbname> is the database name. Should we use the Initialization Parameter value of db_name as the <dbname>? 9/22/2015 QUESTION Page 980 says, “…enter the fully qualified domain name of each physical node.” The db_name is listed as CDBSBLT, without the fully qualified domain name. Should we add the Initialization Parameter value db_domain to the db_name? <db_name> + <db_domain> = CDBSBLT + CTC.CA.GOV = CDBSBLT.CTC.CA.GOV 7 Enter the user name for the Oracle instance. PAGE 977 Oracle 12c notes New SYSBACKUP privilege for RMAN For Oracle 12c and later, the Oracle Agent supports backup and restore tasks only with a user that has SYSBACKUP privileges. PAGE 981 Displays the user name for the Oracle instance. If the credentials for the Oracle instance change, you must enter a user with SYSDBA rights to the Oracle instance. For Oracle RAC nodes, enter the same set of credentials for all of the nodes. For an Oracle 12c database, you must enter a user name that has SYSBACKUP privileges. 9/22/2015 CUSTOMER QUESTION Is this statement correct, "the credentials cannot be verified if the user account with which you are logged on is a member of the Oracle DBA group?" Did they mean that "the credentials CAN be verified"? 9/22/2015 QUESTION Are the "credentials for an instance" referring to an OS user account or Database user account? 9/22/2015 QUESTION For RAC AND 12c database, the User Name (database user account) must have SYSBACKUP privilege and be entered on all nodes in cluster. Does the RAC and 12c database User Name (database user account) need to have SYSDBA privilege? The Page 977 seems to indicate no but I am uncertain whether page 981 refers to RAC and 12c databases. 8 For Oracle 12c and later versions, when prompted, enter the auxiliary instance path for PDB restores. 9/22/2015 QUESTION If the database uses a Fast Recovery Area then will the auxiliary database data files be created in the Fast Recovery Area? Please confirm the following is true for Linux: PAGE 982 - If the database that you want to restore uses a Fast Recovery Area, RMAN creates the auxiliary database files in this area in the <FRA>/<SID>/datafile directory. 9/22/2015 QUESTION If the database uses a Fast Recovery Area then will we be leaving this entry blank? Please confirm the following is true for Linux: PAGE 982 - If you do not specify this path, RMAN assumes that the Fast Recovery Area is configured and has sufficient space. 9/22/2015 QUESTION If the AUXILIARY INSTANCE PATH must be left blank since Fast Recovery Area on ASM is being used, then does the Oracle User (database user account) have to have explicit read/write access privileges to Fast Recovery Area in ASM Disk Group? How? ******************************************************************************************** ENABLING DATABASE ACCESS FOR ORACLE OPERATIONS ON LINUX SERVERS PAGE 992 ******************************************************************************************** PAGE 992 Note: When you use the Backup Exec Agent Utility, the USER ACCOUNT with which you are logged on should be a MEMBER OF THE ORACLE DBA GROUP. You must have ADMINISTRATOR PRIVILEGES to run the Backup Exec Agent Utility. To enable database access for Oracle operations on Linux servers 1 On the Linux server on which the Oracle instances are installed, open a Terminal window. 9/22/2015 QUESTION Does the User Account (OS User Account) that starts the Backup Exec Agent Utility for “Enabling Database Access for Oracle Operations on Linux Servers” need to be a member of the Oracle DBA group (OSDBA)as this wasn’t a requirement for configuring the Oracle Instance? 9/22/2015 QUESTION Does the User Account (OS User Account) that starts the Backup Exec Agent Utility need to be a member of the BEOPER group? 9/22/2015 QUESTION Is ROOT privilege required for “Enabling Database Access for Oracle Operations on Linux Servers” because I don’t see that requirement anywhere in the documentation other than initial agent for Linux installation? 5 Type the user name that is in the beoper group on the Linux system. 9/22/2015 QUESTION Does this need to be the same OS user account that configured Oracle Instance for Linux Servers? 9/22/2015 QUESTION Is ROOT privilege required for this OS User account because I don’t see that requirement anywhere in the documentation other than initial agent for Linux installation?Opscenter database clone Fails ORA-32002
Hi all, I was tring to clone a database to another client with Opscenter. I successfully run pre-clonet check but when I launc the clone I got the error: 14/09/2015 23:48:01 - begin Restore 14/09/2015 23:48:01 - Info bpbrm(pid=7320) vbodstest is the host to restore to 14/09/2015 23:48:01 - Info bpbrm(pid=7320) reading file list for client 14/09/2015 23:48:01 - connecting 14/09/2015 23:48:01 - Info bpbrm(pid=7320) starting bptm 14/09/2015 23:48:01 - Info bphdb(pid=12090) Restore started 14/09/2015 23:48:01 - connected; connect time: 0:00:00 14/09/2015 23:48:01 - Info bphdb(pid=12090) Waiting for the child status 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Starting Oracle Recovery Manager. 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Using: /opt/oracle/11.2/product/dbhome/bin/rman 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Connection info: target / nocatalog 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Start of Recovery Manager input. 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - SET DBID=2359484838 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - # ----------------------------------------------------------------- 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - # Create spfile from pfile section 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - # ----------------------------------------------------------------- 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - startup force nomount; 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - sql "create spfile from pfile=''/opt/oracle/11.2/product/dbhome/dbs/initODS.ora''"; 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - shutdown immediate; 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - End of Recovery Manager input. 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Start of Recovery Manager output. 14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Recovery Manager: Release 11.2.0.2.0 - Production on Mon Sep 14 23:48:03 2015 14/09/2015 23:48:03 - Info bphdb(pid=12090) INF - connected to target database: ODS (not mounted) 14/09/2015 23:48:03 - Info bphdb(pid=12090) INF - using target database control file instead of recovery catalog 14/09/2015 23:48:07 - Info bphdb(pid=12090) INF - Oracle instance started 14/09/2015 23:48:08 - Error bpbrm(pid=7320) from client vbodstest: ERR - Script exited with status = 1 <the requested operation was partially successful> 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Total System Global Area 14965264384 bytes 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Fixed Size 2241040 bytes 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Variable Size 7079988720 bytes 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Database Buffers 7851737088 bytes 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Redo Buffers 31297536 bytes 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - sql statement: create spfile from pfile=''/opt/oracle/11.2/product/dbhome/dbs/initODS.ora'' 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-00571: =========================================================== 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-00571: =========================================================== 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-03009: failure of sql command on default channel at 09/14/2015 23:48:09 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-11003: failure during parse/execution of SQL statement: create spfile from pfile='/opt/oracle/11.2/product/dbhome/dbs/initODS.ora' 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - ORA-32002: cannot create SPFILE already being used by the instance 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Recovery Manager complete. 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - End of Recovery Manager output. 14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - End Oracle Recovery Manager. 14/09/2015 23:48:08 - Error bpbrm(pid=7320) from client vbodstest: ERR - bphdb exit status = 5: the restore failed to recover the requested files 14/09/2015 23:48:08 - Info bphdb(pid=12090) done. status: 5 14/09/2015 23:48:08 - Info bphdb(pid=12090) done. status: 5: the restore failed to recover the requested files 14/09/2015 23:48:08 - Error bpbrm(pid=7320) client restore EXIT STATUS 5: the restore failed to recover the requested files 14/09/2015 23:48:09 - end Restore; elapsed time: 0:00:08 Could You help me?Using Backup Exec to backup Oracle Database
Hi, I've never used Backup Exec and IIwould like to know if Backup Exec can answermy requests before to decide to use it for our customers. Context: We install our application at our customers, the application usean Oracle database - The size of database can vary from30GB to 600GB - The database is install in a Windows server 2003,2008 or 2012 -The objectif is to backup the Oracle Database running on the server - Only 1 database to backup (for each installation) - The backup destination will be ashared network directory - 1 full backup perday Requirements: - Backup Exec + Agent should install on the same server - Backup should run automatically once a day. Questions: - In case when the server crashes, does it easy to restore the database in the other server ? - Does Backup Exec uses RMAN to do the Oracle database backup ? - Does the backup set can be used by RMAN ? - Does it common to install Backup Exec on the same server ? what is your recommandations ? Regards, Charles.