So If you attending this year to Oracle Open World 2013 Don’t Forget To Pass by 🙂 and Create your RAC 12c on your Personal laptop.
Thank you
Osama mustafa
Oracle Open World 2013 Rac Attack
BLOG
Officaly DBvisit Partner
After Testing DbVisit Product and Post about it Here, I Didn’t Stop There Because This Product Gives lot of Benefits and Easy To Manage. You Don’t Need to Become DBA to manage it.
The Most Important Thing in Any Products as i see Support Part Because Any Software in this World will Generate New errors you don’t know anything about it. DbVisit Provide you with Support Team Response on you As Soon As Possible with Answers.
DbVisit Solutions Is not expensive if you want to compare with Other Software Proof on this my friend Steve Karam Write Blog here talking About License Here With Examples on Prices.
Finally I am Proud to be DbVisit Gold Partner In Jordan And Covering Middle East Region.
Thank you
Osama Mustafa
Mount NFS Device Is Busy
This Error Appear On Solaris when you try to mount filesystem :
mount -F nfs IP:/export/home/oracle/test /export/home/oracle/test
Output :
nfs mount: mount: /export/home/oracle/test : Device busy
Check why it’s Busy using :
fuser -u /export/home/oracle/test
/export/home/oracle/test : 1432c(oracle)
Kill the process :
kill – 9 1432
Thank you
Osama mustafa
Step By Step to Restore RMAN to New Host
Old Topics But Always Good To share , Find Below the Links for Steps to Restore RMAN to New Host
Step by Step Restore RMAN to New Host Here
Thank you
Osama Mustafa
WebLogic Error BEA-141281
This Solutions for this errors :
Change Directory to Domain directory
cd /u01/app/oracle/domains/IDMDomain/servers/AdminServer
if you have lock you will find folder called tmp
rm -rf AdminServer.lok
Thank you
Osama mustafa
New Slideshare Document ( EnterPrise manager 12c )
Clone Pluggable Database
If you want to Clone One Of Pluggable database , How can you do that :
SQL> select name from v$pdbs ;
NAME
——————————
PDB$SEED
TEST_1
TEST_2
Let’s Clone Test_1 , Create folder on os level to move test_1 data.
[oracle@test12c u01]$ mkdir clone
[oracle@test12c u01]$ cd clone/
[oracle@test12c clone]$ pwd
/u01/clone
Open Test_1 Read Only :
SQL> alter pluggable database test_1 close immediate;Pluggable database altered.
SQL> alter pluggable database test_1 open read only ;Pluggable database altered.
Set this parameter to our created directory above :
SQL> show parameter db_create_file_dest ;
NAME TYPE VALUE
———————————— ———–
db_create_file_dest string
SQL> alter system set db_create_file_dest=’/u01/clone’; System altered.
SQL> show parameter db_create_file_dest ;
NAME TYPE VALUE
———————————— ———–
db_create_file_dest string /u01/clone
SQL> create pluggable database clone from test_1 ;Pluggable database created.
SQL> alter pluggable database clone open ;Pluggable database altered.
Test Clone Pluggable database
[oracle@test12c ~]$ sqlplus sys/sys@test12c:1521/clone as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 13 20:20:24 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL> show con_name ;CON_NAME
——————————
CLONE
SQL> select name from v$pdbs ;
NAME
——————————
PDB$SEED
TEST_1
TEST_2
CLONE
You can drop Clone Database using the below command
SQL > Alter Pluggable database Clone Including Datafiles ;
Thank you
Osama mustafa
Point-In-Time Recovery for a Pluggable Database
Check Pluggable database that you have :
SQL> select name from v$pdbs ;
NAME
——————————
PDB$SEED
TEST_1
TEST_2
TEST_3
Shutdown database , to configure database archivelog
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount ;
ORACLE instance started.
Total System Global Area 1252663296 bytes
Fixed Size 2287864 bytes
Variable Size 838862600 bytes
Database Buffers 402653184 bytes
Redo Buffers 8859648 bytes
Database mounted.
SQL> alter database archivelog ;
Database altered.
SQL> alter database open
Database altered.
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> alter system set db_recovery_file_dest_size = 2G scope=both;
System altered.
SQL> alter pluggable database all open;
Pluggable database altered.
Export ORACLE_SID for container database and enter rman to backup like below
[oracle@test12c backup]$ export ORACLE_SID=db12c
[oracle@test12c backup]$ rman target ‘”/ as sysbackup”‘
Recovery Manager: Release 12.1.0.1.0 – Production on Sat Jul 13 17:13:42 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: DB12C (DBID=1274669151)
Auto Backup controlfile :
RMAN> configure controlfile autobackup on;
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
Backup Script that we need :
Run {
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT ‘/u01/backup/db12c/%U’;
backup database plus archivelog;
}
Where
Format ‘/u01..’: Location for backup
now move to our pluggable database
SQL>alter session set container=test_1 ;
SQL>create tablespace test_1 datafile ‘/u01/app/oracle/oradata/db12c/test_1/test_1.dbf’ size 10m;
SQL>create user test identified by test temporary tablespace temp default tablespace test_1;
SQL>grant create session, create table, unlimited tablespace to test ;
SQL>create table data (id varchar2(100)) tablespace test_1;
Enter Data using The Below code in above table :
begin
for i in 1.. 10000 loop
insert into data values (‘osama’);
end loop;
commit;
end;
After you insert data close pluggable database to start restore.
alter pluggable database test_1 CLOSE ;
Restore script :
run {
set until SCN = 1832026 ;
restore pluggable database test_1;
recover pluggable database Test_1 auxiliary destination=’/u01/backup/db12c’;
alter pluggable database TEST_1 open resetlogs;
}
Note : To get SCN for database before insert use the query below :
SQL > select timestamp_to_scn(sysdate) from v$database;
After Restore :
sqlplus sys/sys@test12c:1521/test_1 ;
SQL> select count(*) from data ;
select count(*) from data
*
ERROR at line 1:
ORA-00942: table or view does not exist
Thank you
Osama Mustafa
Adopting NON-CDB to CBD
This article describe steps to Adopt non-container database 12c to container 12c
[oracle@test12c Desktop]$ ps -ef | grep pmon
oracle 3230 1 0 04:04 ? 00:00:09 ora_pmon_db12c
oracle 12112 1 0 08:20 ? 00:00:07 ora_pmon_NonCDB
oracle 29621 3203 0 18:47 pts/1 00:00:00 grep pmon
Where :
db12c : Container database
NonCDB : Non Container Database
Let Start
[oracle@test12c Desktop]$ export ORACLE_SID=NonCDB
SQL> select instance_name from v$instance ;
INSTANCE_NAME
—————-
NonCDB
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount exclusive
ORACLE instance started.
Total System Global Area 939495424 bytes
Fixed Size 2295080 bytes
Variable Size 348130008 bytes
Database Buffers 583008256 bytes
Redo Buffers 6062080 bytes
Database mounted.
SQL> alter database open read only;
Database altered.
Run the below procedure to generate the manifest file.
SQL> exec dbms_pdb.describe(pdb_descr_file=>’/u01/noncdb.xml’);
PL/SQL procedure successfully completed.
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
I already working on the same host so no need to copy datafiles,if you are not working on same host copy datafiles to same location.
Let’s Work On Container Database .
after copy datafiles to folder, On Os Level , Create directory to use file_name_convert.
[oracle@test12c oradata]$ mkdir newnoncdb
[oracle@test12c newnoncdb]$ pwd
/u01/app/oracle/oradata/newnoncdb
[oracle@test12c Desktop]$ export ORACLE_SID=db12c
[oracle@test12c Desktop]$ sqlplus / as sysdba
SQL> create pluggable database non_cdb as clone
2 using ‘/u01/noncdb.xml’
3 file_name_convert=(‘/u01/app/oracle/oradata/NonCDB’,’/u01/app/oracle/oradata/newnoncdb’) copy;
Pluggable database created.
Where
- using ‘/u01/noncdb.xml’ : file that should be generated using dbms_pdb.describe
- ‘/u01/app/oracle/oradata/NonCDB’ : location for Copied Non_CDB datafile
- ,’/u01/app/oracle/oradata/newnoncdb’ : location for created directory.
SQL> alter pluggable database non_cdb open ;
Pluggable database altered.
SQL> alter pluggable database non_cdb close ;
Pluggable database altered.
SQL> alter pluggable database non_cdb open ;
Pluggable database altered.
NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
NEWDB_PLUG MOUNTED
NEW_PLUG_COPY MOUNTED
NEW_PLUG_MOVE MOUNTED
NON_CDB READ WRITE
Now you plugged NON-CDB to Container Database successfully without any problems and it will works fine.
the below step is optional but recommanded for production to move all thing from non-cdb to cdb. ( specially for upgrade 12c later )
SQL> alter session set container=Non_cdb;
Session altered.
OR
[oracle@test12c newnoncdb2]$ sqlplus sys/sys@test12c:1521/Non_cdb as sysdba ;
SQL> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql
Thank you
Osama Mustafa
Oracle Database 12c Architecture
I want to share the below picture , describe Database 12c Architecture
For the Better Resolution please follow This Link
Thank you
Osama mustafa
Technology Geek 