Veritas Netbackup: Can not connect to Client

Error:

Can not connect to client.

Restart the Net backup client service.

Refresh the net backup client.

Oracle 12c: Control,Data,Redo log and Temp files in CDB and PDB

[oracle@oracle12c bin]$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 4 01:36:08 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


SQL> conn / as sysdba
Connected.
SQL>    
SQL>
SQL> show con_name



CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL>
SQL> show con_id



CON_ID
------------------------------
1


SQL>
SQL>
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/ora/oracle/app/oracle/oradata/cdb1/system01.dbf
/ora/oracle/app/oracle/oradata/cdb1/sysaux01.dbf
/ora/oracle/app/oracle/oradata/cdb1/undotbs01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdbseed/system01.dbf
/ora/oracle/app/oracle/oradata/cdb1/users01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdbseed/sysaux01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb2/system01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb2/sysaux01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb2/pdb2_users01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb1/system01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb1/sysaux01.dbf

NAME
--------------------------------------------------------------------------------
/ora/oracle/app/oracle/oradata/cdb1/pdb1/pdb1_users01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb3/system01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb3/sysaux01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb3/pdb3_users01.dbf
/ora/oracle/app/oracle/oradata/cdb1/movefile/userdat.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb1copy/system01.dbf.clone
/ora/oracle/app/oracle/oradata/cdb1/pdb1copy/sysaux01.dbf.clone
/ora/oracle/app/oracle/oradata/cdb1/pdb1copy/pdb1_users01.dbf.clone
/ora/oracle/app/oracle/oradata/cdb1/pdb1copy/userdat.dbf.Clone

20 rows selected.




SQL>
SQL>
SQL> select con_id,name from v$tempfile;

    CON_ID   NAME
--------------------------------------------------------------------------------
1           /ora/oracle/app/oracle/oradata/cdb1/temp01.dbf

2          /ora/oracle/app/oracle/oradata/cdb1/pdbseed/pdbseed_temp01.dbf
   
 3          /ora/oracle/app/oracle/oradata/cdb1/pdb1/temp01.dbf

4         /ora/oracle/app/oracle/oradata/cdb1/pdb2/temp01.dbf

5         /ora/oracle/app/oracle/oradata/cdb1/pdb3/temp01.dbf

6        /ora/oracle/app/oracle/oradata/cdb1/pdb1copy/temp01.dbf.Clone


6 rows selected.

SQL>      
SQL>


SQL> select * from v$controlfile;

STATUS
-------
NAME
--------------------------------------------------------------------------------
IS_ BLOCK_SIZE FILE_SIZE_BLKS  CON_ID
--- ---------- -------------- ----------

/ora/oracle/app/oracle/oradata/cdb1/control01.ctl
NO 16384 1096       0


/ora/oracle/app/oracle/fast_recovery_area/cdb1/control02.ctl
NO 16384 1096       0

STATUS
-------
NAME
--------------------------------------------------------------------------------
IS_ BLOCK_SIZE FILE_SIZE_BLKS  CON_ID
--- ---------- -------------- ----------


SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/ora/oracle/app/oracle/oradata/cdb1/redo03.log
/ora/oracle/app/oracle/oradata/cdb1/redo02.log
/ora/oracle/app/oracle/oradata/cdb1/redo01.log

SQL> alter session set container = pdb1;

Session altered.

SQL> show con_name

CON_NAME
------------------------------
PDB1
SQL> show con_id

CON_ID
------------------------------
3
SQL>
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/ora/oracle/app/oracle/oradata/cdb1/undotbs01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb1/system01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb1/sysaux01.dbf
/ora/oracle/app/oracle/oradata/cdb1/pdb1/pdb1_users01.dbf
/ora/oracle/app/oracle/oradata/cdb1/movefile/userdat.dbf

SQL> select con_id,name from v$tempfile;

    CON_ID
----------
NAME
--------------------------------------------------------------------------------
3
/ora/oracle/app/oracle/oradata/cdb1/pdb1/temp01.dbf


SQL> select * from v$controlfile;

STATUS
-------
NAME
--------------------------------------------------------------------------------
IS_ BLOCK_SIZE FILE_SIZE_BLKS  CON_ID
--- ---------- -------------- ----------

/ora/oracle/app/oracle/oradata/cdb1/control01.ctl
NO 16384 1096       0


/ora/oracle/app/oracle/fast_recovery_area/cdb1/control02.ctl
NO 16384 1096       0

STATUS
-------
NAME
--------------------------------------------------------------------------------
IS_ BLOCK_SIZE FILE_SIZE_BLKS  CON_ID
--- ---------- -------------- ----------


SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/ora/oracle/app/oracle/oradata/cdb1/redo03.log
/ora/oracle/app/oracle/oradata/cdb1/redo02.log
/ora/oracle/app/oracle/oradata/cdb1/redo01.log

SQL>

Oracle 12c Database RMAN Full Backup using SQL Developer

Oracle 12c Database: Cloning PDB using SQL Developer

How to clone a PDB1 database using of SQL Developer

Modify the State to Read Only (If Open then Shutdown and Open in Read Only mode)


Use the Clone Pluggable Database Option

First you have to shutdown the PDB1 database.

 

See the status of PDB1.

 Start database read only mode.

 Right click on PDB1 database and select the Clone Pluggable database option.

 Change the Database Name: NEW_PDB & Select the File Name Conversion option.

Goto to SQL tab and change the Clone database files path.

Clone database created.

You can start the clone NEW_PDB database.

Create the new connection for "test" user which ready created in PDB1.

Verify the data in NEW_PDB database.

 

Now you start the PDB1 database for normal operation.

Oracle 12c: Opening a PDB Using SQL Developer

You can open Pluggable database using SQL Deverloper

Make a connection to the CDB and using the DBA view expand the container database.

Select the PDB1 database

 Right click on PDB1 & Select the Modify State.

Select the READ ONLY.

You can see the Status of PDB1 database. (Read Only)

Create user for testing....You are getting error because PDB1 database read only mode.

Now you start the PDB1 database.

 

Oracle 12c Database Enable Archive Log Mode for CDB using SQL Developer

Enable Archive Log Mode using SQL Developer

Enable the Archive mode

Edit the Listener.ora file.

\

Verifying if Archiver is started in CDB1

Verifying if Archiver is started in all pluggable databases like  PDB1 

Oracle 12c Database Recovering Pluggable Database