Tag Info

Hot answers tagged

2

Try adding (SERVICE=Dedicated) to your TNS entry on the client computer that you are using and then run your query again. There could be other causes but this is the most common: you are trying to access data using a shared connection when a dedicated connection is required. Edit: Are there any other log or trace file entries when this error happens?


2

There aren't any special considerations that need to be taken into account when setting up a RAC->No RAC Primary->Standby configuration. In fact, there's a White Paper written by Oracle which explains the setup. The Oracle documentation is here.


2

Fault-tolerant storage, a stand-by database (Data Guard in your case), and the database backup are three different solutions to different types of problems. Depending on how much downtime you can afford, you may need to implement all three.


2

I simply do not believe. It's impossible. There is process called FAL (Fetch Archive Log), it can happen that redo-logs are not TRANSFERRED in chronological order, but anyway they must be APPLIED in chronological order. Also logical standby has can have some gotchas but those are not related to network link. (For example for some reason LOCK TABLE statement ...


2

If the database is setup correct: no direct path load. If a standby database is depending on the changes captured on the primary database, the primary database should be setup with force logging. If for some reason the force logging setting is not in place, after such an operation the affected datafiles should be transferred to the standby site[s]. Failing ...


1

Without opening the standby for read-only, you won't be able to identify specific changes to specific physical objects, instead you'll have to verify that a specific set of changes have been applied to the remote standby. Views including v$standby_apply_snapshot, v$archived_log, v$archive_gap, v$dataguard_stats, v$managed_standby are all ones that I use on a ...


1

When you drop user on primary then this will be also reflected on secondary site. Also impdp will work as expected. But when you are about to import large amount of data MAA might slow down the whole procedure significantly. If you have enough experience with RMAN you might try: shutdown and disconnect the secondary import data into master backup master ...


1

From the documentation: startup_clauses The startup_clauses let you mount and open the database so that it is accessible to users. MOUNT Clause Use the MOUNT clause to mount the database. Do not use this clause when the database is already mounted. MOUNT STANDBY DATABASE You can specify MOUNT STANDBY DATABASE to mount a ...


1

Yes, no issue at all. This is done over and over. For instance two servers taking each others database(s) in standby mode.


1

If you setup a logical standby, then you can change the data in the logical standby. You will probably have trouble supporting the kind of change that you seem to want. Have you thought about talking to the vendor to see if they can add the logic that you want to the product you pay them for? If the vendor makes the change, then they will/should support it. ...



Only top voted, non community-wiki answers of a minimum length are eligible