data guard oracle 11g step by step

Tags: style blog color using file data sp div problemThe backup file was exported from 11g with the exp command, and the above error occurred with IMP Import under 10g, in the case of a lower version of the backup that does not support a higher version, so the use of 11g test, or the above problem.In fact, the size of the table space is not enough, the following

=scott:tom View the results of the import, using the Tom user connection Export Table Space Create a table AA on the XX table space and insert a record for the table Export Table Space Delete data files while table space xx is deleted The AA table is gone. Import Table Space Before you import a tablespace, you need to create a table space of XX Import Table Space xx Verify that the AA table recovers back. Export Full Library [Email protected]]$

V$parameter Record values for all items in the initialization parameter file V$lock Set all information for an object lock by accessing a database session V$session There's a conversation message. V$sql Log details of SQL statements V$sqltext Record statement information for an SQL statement V$bgprocess Show background process information V$process Information abo

The export is derived from the MS-brought OLE DB provider Access interface: 1. Right-click the database to Export "task"-"Export Data"-"Set export data source 2. Set Oracle as Target data source 3. Set the target table (create) 4. Edit Field Since SQL Server's T-SQL is not the s

There is a new feature in 11G. When the table has no data, no segment is allocated to save space. Solution: 1. insert a row and then roll back to generate a segment. This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be exported. 2. Set the deferred_segment_creation parameter. Show parameter deferred_segme

11g Oracle Export table does not export data as null by default 1, oracle11g default to empty table does not assign segment, so use EXP export oracle11g database, empty table will not export.2, set the Deferred_segment_creation parameter is false, whether it is empty table or Non-empty table, are allocated segment. In Sqlplus, execute the following command:Sql>

Oracle 11g provides a sample schema for the Data Warehouse, and you can download the sample installation files by following the links below.Http://www.oracle.com/technology/products/bi/olap/doc_sample_schemas/global_11g_schema.zipUpload the downloaded file to the Oracle server and unzip it.[[emailprotected]~]$mkdirglob

'*.diagnostic_dest= '/u01/app/oracle '*.dispatchers= ' (protocol=tcp) (SERVICE=BBDGXDB) '*.fal_client= ' BBDG '*.fal_server= ' Bbsvri1 '#*.log_archive_config= ' dg_config= (BBSVR,BBDG) '#*.log_archive_dest_1= ' Location=use_db_recovery_file_dest valid_for= (all_logfiles,all_roles) db_unique_name= BBDG '#*.log_archive_dest_2= ' Service=bbsvr valid_for= (online_logfiles,primary_role) Db_unique_name=bbsvri1 '*.log_archive_format= ' Arc_%t_%s_%r.arc '*.l

installationOracle under Linux is in a running state after installation is complete. After restarting the machine, Oracle does not add Oracle to the Windows service as it did under Windows, and the Orcle service needs to be started manually under LinuxUnder Oracle User, execute the following commandEnter Sqlplus$ sqlplus/nologConnect to the database as SYSDBA an

failedora-01200:actual file size of 128679 Issmaller than correct size of 340480BlocksOra-01110:data file 2: '/HOME/ORADATA/POWERDES/SYSAUX01.DBF 'Workaround:DD if=/dev/zeroof=/home/oradata/powerdes/sysaux01.dbf bs=8192 count=1 seek=340480 ----------------------------------------------------------------------------------------------------------- -----Original Blog address: http://blog.itpub.net/26230597/viewspace-1484099/Hara Douglas Fir (MCHDBA)----

= (Hr_resume_qingdao)4, some Error recordsLocate the data fileERROR at line 1:Ora-01503:create Controlfile failedora-01200:actual file size of 128679 Issmaller than correct size of 340480BlocksOra-01110:data file 2: '/HOME/ORADATA/POWERDES/SYSAUX01.DBF 'Workaround:DD if=/dev/zeroof=/home/oradata/powerdes/sysaux01.dbf bs=8192 count=1 seek=340480 ---------------------------------------------------------------

Pl/sql Procedure: Data reading of Clob field types in Oracle 11g the database column of the LOB type stores only the locator, which points to the storage location of the large object. manipulate LOB data with the Dbms_lob package. When reading data with an

In order to do the virtual machine, you need to the server 11g of the user's complete data out. The oracle10g on the virtual machine, directly exported, cannot be imported to the virtual machine. So, try to export the data using a 10g client, With command: Exp exoa/***** @exoa1 file=20100526.dmp grants=y full=y After execution, the system prompts: EXP-00008:

="SELECT * from TEST"; OracleConnection myconnection=NewOracleConnection (connectionString); OracleCommand mycommand=Myconnection.createcommand (); myCommand.CommandText=queryString; Myconnection.open (); OracleDataAdapter Orada=NewOracleDataAdapter (mycommand); DataSet DS=NewDataSet (); Orada.fill (DS); Myconnection.close (); DataTable Dtbl=ds. tables[0]; This. Datagridview1.datasource =dtbl; } (4) operation, the results are as follows: As with the

The export is derived from the MS-brought OLE DB provider Access interface: 1. Right-click the database to Export "task"-"Export Data"-"Set export data source 2. Set Oracle as Target data source 3. Set the target table (create) 4. Edit Field Since SQL Server's T-SQL is not the s

Flashback Data Archive (Flash back archive)The rollback information for the Undo table space Record, although it can provide a back-flash query, but for a long time, this information will be overwritten, in fact, as long as the transaction is submitted, they become an object can be overwritten, so often in the back-flash query, we will not find the undo block and received 1555 errors, 11G introduces the fla

Tags: Oracle 11g dataThis exception may occur because the exported user's table may have an empty data table.First of all:View: sql>show parameter deferred_segment_creation;If true, the parameter is changed to false;In Sqlplus, execute the following command: Sql>alter system set Deferred_segment_creation=false;Then: You can manually assign extent for

[From] Https://oracle-base.com/articles/10g/dml-error-logging-10gr2You need to record a specific record of errors in a large number of DML operations, and see that there are two scenarios, one of which is to use the bulk DML operation Bulk collect with the SAVE exceptions clause and then do the processing. A little cumbersome, do not want to use. Another option, then, is to keep the log ERRORS behind the DML statement.LOG ERRORS [into [schema.] Table]