Skip to main content

Posts

Example of datapump utility

CONTENTS page 1. Steps to be performed in Production Database 1 2 Steps to be performed in Test/Dev Database 3 3. Exercises 5 1. Steps to be performed in Production Database • Check the size of the schema select sum(BYTES)/1024/1024 from dba_segments where owner='SLADMIN'; • Check type of objects and status of the objects the schema. col OBJECT_TYPE for a18 set pages 100 col owner for a10 select owner ,object_type,status, count(*) from dba_objects where owner='DSADMIN' group by owner, object_type, status; • Check the total number of objects in the schema. select count(*) from dba_objects where owner like 'DSADMIN'; • Check for constraints validity in the schema. Select constraint_type,count(*) from dba_constraints where...
Post a Comment
Read more
Recent posts

Step to restore rman backup

C:\Documents and Settings\201910>sqlplus sys/mysecretpassword as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on Wed Nov 12 14:32:28 2008 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- C:\AUG\SYSTEM.DBF C:\AUG\UNDOTBS1.DBF C:\AUG\SYSAUX.DBF C:\AUG\USERS.DBF SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> create spfile from pfile; File created. SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string...
Post a Comment
Read more

Migration 10g database from Windows to Linux using RMAN

Database Migration From Windows to Linux Using RMAN Alejandro Vargas Principal Support Consultant Oracle Advanced Customer Services INDEX SUMMARY........................................................................................................................................................................2 The Windows Database....................................................................................................................................................3 List of Steps Needed to Complete the Migration................................................................................................................4 1. Check platform compatibility between source and target OS.........................................................................................5 2. Start the database in read only mode............................................................................................................................6 3. Check database readiness for transp...
Post a Comment
Read more

Migration of 10g database from Windows to Linux using RMAN

Database Migration From Windows to Linux Using RMAN 1/32 INDEX SUMMARY........................................................................................................................................................................2 The Windows Database....................................................................................................................................................3 List of Steps Needed to Complete the Migration................................................................................................................4 1. Check platform compatibility between source and target OS.........................................................................................5 2. Start the database in read only mode............................................................................................................................6 3. Check database readiness for transport from Windows to Linux......................................................
Post a Comment
Read more

Restoring rman backups.

C:\Documents and Settings\201910>sqlplus sys/mysecretpassword as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on Wed Nov 12 14:32:28 2008 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- C:\AUG\SYSTEM.DBF C:\AUG\UNDOTBS1.DBF C:\AUG\SYSAUX.DBF C:\AUG\USERS.DBF SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> create spfile from pfile; File created. SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string...
1 comment
Read more