Label:Reference articles Experiment: 1. View current EMCTL status Dbconsole to Runing state 2. Close Emctl Stop Dbconsole 3. Delete the Emdb.nohup file in the/u01/app/oracle/product/11.2.0/db_1/gtone.localdomain_cqrcb/sysman/log directory 4. Restart Emctl start Dbconsole 5. View auto-generated emdb.nohup file Demonstrating the relativity between Emdb.nohup
[Case] database faults caused by Oracle Control File Corruption
Problem:1. All clients cannot log on this morning, and the system prompts that the application server configuration is incorrect. Analysis and connection processing:1. Check the client logs and discover database exceptions.Caused by: Java. SQL. sqlexception: Listener refused the connection with the following error:ORA-12528, TNS: Lis
Tags: oracle ASM File ReplicationWork, sometimes you need to copy files from ASM to the file system or, in turn, do some maintenance operations, this article describes 4 ways to copy files:
CP command in Asmcmd (11g)
Dbms_file_transfer Bag
Convert or Backup as copy of Rman
Ftp
These 4 methods are described below1. CP command in Asmcmd (1
The control file experiment has a maximum of eight control files, at least one of which is an image of each other. If the control file is lost, the database cannot be shut down normally and cannot be started. Add control file, required
The control file experiment has a maximum of eight control files, at least one of wh
3 K blocks, a total of 5 blocks, back up the 15 K (3 K * 5 = 15 K) of the original file ).Skip = xxx indicates the part after if during backup, that is, how many parts of the original file are skipped before the backup starts, on the contrary, seek = xxx indicates the part of the object after the backup, that is, the number of skipped parts of the target file be
1. View Control File Information
SQL * Plus: Release 9.2.0.1.0-Production on Saturday January 5 10:12:00 2008
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
SQL> conn sys/as sysdbaEnter the password :*****Connected.SQL> select name from v $ controlfile;
NAME--------------------------------------------------------------------------------D: \ ORACLE
", "F: \ TEST \ control03.ctl ")SQL> create spfile from pfile;SQL> startup mount;Query Data File Location: select name from v $ datafile;Query Log File Location: select * from v $ logfile;Query Control File Location: select name from v $ controlfile;View the temporary file location: select * from v $ tempfile;Move log
.ctlSQL> select name from v $ controlfile;
NAME--------------------------------------------------------------------------------/U01/app/oracle/oradata/prod/control01.ctl/U01/app/oracle/oradata/prod/control02.ctl/U01/app/oracle/oradata/prod/control03.ctl
B. view the db_create_file_dest parameters.SQL> show parameter db_create_file_dest;
NAME TYPE-----------------
Oracle parameter files are critical to Oracle. No parameter file. Oracle cannot be started.Parameter files are dividedSpfile: The parameter file added after oracle9iR1. It is a binary file and cannot be edited directly.Pfile
type values, if the string contains spaces or tabs, you must enclose the string with single or double quotation marks, for example, NLS_TERRITORY = "czech republic"
Common parameters:
DB_NAME and DB_DOMAIN
The global database tutorial name is usually composed of a local database ID (DB_NAME) and a network domain name (DB_DOMAIN). It uniquely identifies an Oracle database on the network. When there is only one instance, DB_NAME is the same as the inst
Oracle uses the backup control file for recovery, and then creates a tablespace for recovery.
1. Create a tablespace after the backup control file, and all the control files are lost. How can I restore the table using the backup control file?
The procedure is as follows:1. Back up the database
Rman target/catalog RC_AD
The use of parameter files in Oracle startup generally has the following situations 1 Single Instance 1.1 starts by default:
In non-RAC environments, the parameter files for Oracle databases are placed by default in the $oracle_home/dbs directory, and the order in which Oracle automatically looks for parameter files is
Spfile$oracle_sid.ora-> Spfile.ora-> init$or
1. Data File migration
It's easy, just three steps.
Step 1: Move the tablespace Offline to the directory specified by disk D.
Step 2: Modify the tablespace file path alter database rename file 'old file path' to 'new file path ';
Step 3: Make the tablespace Online.
1.1
The ultimate goal of backup is to better recover data and restore data. In the previous chapter, we have already finished the backup of RMAN, but in fact we have also discussed some complex issues.
The ultimate goal of backup is to better recover data and restore data. In the previous chapter, we have already finished the backup of RMAN, but in fact we have also discussed some complex issues.
The ultimate goal of backup is to better recover data and restore data. We have finished focusing o
Introduction to the three configuration files of ORACLE
Overview
In the oracle installation directory $ HOME/network/admin, sqlnet is often seen. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files is not well understood by many people.
Sqlnet. ora is used on the oracle client to configure relevant parameters for
-rf/u02/database/SYBO2SZ/controlf /*
Sys @ SYBO2SZ> ho ls/u02/database/SYBO2SZ/controlf/
--> A ORA-00205 error is received after startup
Sys @ SYBO2SZ> startup
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 2074568 bytes
Variable Size 276826168 bytes
Database Buffers 314572800 bytes
Redo Buffers 6311936 bytes
ORA-00205: error in identifying control file, check alert log for
Tags: des style class Blog Code tarExperimental Purpose: Oracle Direct copy physical file migration, production library has similar construction requirements, so in the experimental environment simple verification. Lab Environment:a host: 192.168.1.200 Solaris10 + Oracle 11.2.0.1B Host: 192.168.1.186 SOLARIS101. Back up the O
Have done some testing, in the startup or shutdown of the database to delete the control file, because this database is only my own test database, then did not care to recover.
Today, when I wanted to start this database, I ran into problems:
[Oracle@bjtest ~]$ Sqlplus "/As SYSDBA"
Sql*plus:release9.2.0.4.0-production on Wednesday June 3 01:47:42 2009
Copyright (c) 1982, 2002,
refer to other spfile files.
H. For a parameter with a string type value, if the string contains spaces or tabs, you must enclose the string in either single or double quotes, such as: Nls_territory= "CZECH Republic"
Common parameters:
Db_name and Db_domain
The global database tutorial name typically consists of a local database identity (db_name) and a network domain name (db_domain) that uniquely identifies an oracle on the network and, in the
Password file function:The password file is used for the DBA user's login authentication.DBA User: A user with sysdba and Sysoper permissions, that is, the SYS and system users of Oracle.Log on Locally:1) Operating system certification:[Email protected] ~]$ sqlplus "/as sysdba"[Email protected] ~]$ Sqlplus/as SYSDBA[Email protected] ~]$ Sqlplus Sys/tiger as Sysdba2) Password
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.