This worked for me.
Thanks a lot for quick response.
Hola!
I try to install an active dataguard on oracle 12.1.0.2. When I start database on read only mode, the pdb is only mounted.
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PESC01 MOUNTED nul
I can't save the state, cause I open pdb in read only mode.
SQL> alter pluggable database pesc01 open read only;Base de donnees pluggable modifiee.SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PESC01 READ ONLY NOSQL> alter pluggable database pesc01 save state 2 /alter pluggable database pesc01 save state*ERREUR a la ligne 1 :ORA-16000: base de donnees ou base de donnees pluggable ouverte pour acces enlecture seule
Is there any solution to open pbd in read only mode on active dataguard?
I noticed that for RAC database (12.2), I have to save the state of PDB for each instance separately. Is that correct? If yes, then is there an easier way so I don't have to connect to each instance?
Thanks,
Arun
Have you tried the "instances" clause.
From the docs:
For an Oracle RAC CDB, you can use the instances clause in the pdb_save_or_discard_state clause to specify the instances on which a PDB's open mode is preserved in the following ways:
List one or more instances in the instances clause in the following form:
INSTANCES = ('instance_name' [,'instance_name'] … )
Specify ALL in the instances clause to modify the PDB in all running instances, as in the following example:
INSTANCES = ALL
Specify ALL EXCEPT in the instances clause to modify the PDB in all of the instances, except for the instances listed, in the following form:
INSTANCES = ALL EXCEPT('instance_name' [,'instance_name'] … )
I refere following link.
https://docs.oracle.com/database/121/SQLRF/statements_2008.htm#SQLRF55667
But I have question how to shutdown specific pluggable database?
This is what i looking for.
ez 2 use & so simple.
Hi there!
I have encountered this problem on Oracle 12 c after installation. I can connect using sysdba and password on sqlplus and sql developer but it shows error in alert log file as such:
Errors in file C:\app\Me\virtual\product\12.2.0\dbhome_1\log\diag\rdbms\orcl\orcl\trace\orcl_m000_8724.trc:
ORA-00202: control file: 'C:\APP\ME\VIRTUAL\ORADATA\ORCL\CONTROL02.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'C:\APP\ME\VIRTUAL\ORADATA\ORCL\CONTROL01.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Can we auto-open PDBs in a preferred order, e.g. after instance startup auto-open PDB2 before PDB1 (maybe needed due to an apps dependency)?
Of course we can do this using a 12.1.0.1 after startup trigger, just open them one at a time in the preferred sequence. But can we do it using some flavour of 12.1.0.2 SAVE STATE ? My understanding is that Oracle tries to open them all at the same time via parallelism.
What I'm looking for is to get the same effect as:
ALTER PLUGGABLE DATABASE PDB2 SAVE STATE BEFORE PDB1; ALTER PLUGGABLE DATABASE PDB1 SAVE STATE AFTER PDB2;
(ok not using that syntax because it doesn't exist, but I hope you can see what I'm looking for).
Thanks, Phil
Correct - there is not a declarative way of doing this.
You'll need a script that either does the open in the sequence you want, or similar using srvctl if you're using grid etc.
Note - there are plans to set PDB priority coming in a future release or patchset. I don't have any more timing details than that
i tried to open pdb using the following command and got the error(I'm using db 19.3)
SQL> alter pluggable database all open;
alter pluggable database all open
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01405: fetched column value is NULL
Is there any solution to open pbd in read only mode on active dataguard ?? It comes up in MOUNTED mode after server or database restart.
SQL> select inst_id,INSTANCE_NAME,host_name,status,DATABASE_STATUS from gv$instance;
INST_ID INSTANCE_NAME HOST_NAME STATUS DATABASE_STATUS
---------- --------------- ---------------------- ------------ -----------------
1 CDB_NAME hostname OPEN ACTIVE
SQL> select inst_id,NAME,DATABASE_ROLE,OPEN_MODE,DB_UNIQUE_NAME from gv$database;
INST_ID NAME DATABASE_ROLE OPEN_MODE DB_UNIQUE_NAME
---------- --------------- ---------------- -------------------- ------------------------------
1 CDB_NAME PHYSICAL STANDBY READ ONLY WITH APPLY XXXXXX
SQL> select inst_id,con_id,NAME,OPEN_MODE from gv$pdbs where name not like '%SEED%';
INST_ID CON_ID NAME OPEN_MODE
---------- ---------- --------------- ----------
1 3 PDB_NAME MOUNTED
SQL> SELECT con_name, instance_name, state FROM dba_pdb_saved_states;
CON_NAME INSTANCE_NAME STATE
--------------- --------------- --------------
PDB_NAME CDB_NAME OPEN
We look at the CDB *future* state and try to match the PDBs.
So if your CDB is defined to open as mounted as default (even if you then later come along and open it yourself), then at restart time, the PDBs are also going to default to open as mounted (not open).
So double check that (eg srvctl config database -d XXX) and if you still are observing that discrepancy, then its time to log a call with Support
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
Alert log:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '+DATA/CONDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.341.1168878861'
ORA-17503: ksfdopn:2 Failed to open file +DATA/CONDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.341.1168878861
ORA-15012: ASM file '+DATA/CONDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.341.1168878861' does not exist
