The good old EXP/IMP untility for logical backups.
-- Exports
-- Schema backup on Linux
exp file=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015.dmp log=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015.log compress=Y owner=WALMART_SAV,WALMART_APP
-- Schema backup in windows:
exp file=H:\expbkp\DJO1_DJO2_22Nov2015.dmp log=H:\expbkp\DJO1_DJO2_22Nov2015.log compress=Y owner=DJO1,DJO2
Export: Release 9.2.0.8.0 - Production on Sun Nov 22 03:38:30 2015
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: sys@savionpr as sysdba
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DJO1
. exporting foreign function library names for user DJO2
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user DJO1
. exporting object type definitions for user DJO2
About to export DJO1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export DJO1's tables via Conventional Path ...
. . exporting table A 0 rows exported
. . exporting table ACLAPPLICATION 1 rows exported
. . exporting table ACLBIZLOGICPERMISSION 3 rows exported
. . exporting table ACLBIZMANAGEPERMISSION 4 rows exported
. . exporting table ACLBIZPULSEPERMISSION 1 rows exported
--------------------------------------------------------------------------------------------------------------------------
-- Imports
-- import schema data
imp file=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015.dmp log=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015_import.log GRANTS=N IGNORE=Y INDEXES=N FROMUSER=WALMART_SAV TOUSER=WALMART_SAV
-- Exports
-- Schema backup on Linux
exp file=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015.dmp log=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015.log compress=Y owner=WALMART_SAV,WALMART_APP
-- Schema backup in windows:
exp file=H:\expbkp\DJO1_DJO2_22Nov2015.dmp log=H:\expbkp\DJO1_DJO2_22Nov2015.log compress=Y owner=DJO1,DJO2
Export: Release 9.2.0.8.0 - Production on Sun Nov 22 03:38:30 2015
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: sys@savionpr as sysdba
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DJO1
. exporting foreign function library names for user DJO2
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user DJO1
. exporting object type definitions for user DJO2
About to export DJO1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export DJO1's tables via Conventional Path ...
. . exporting table A 0 rows exported
. . exporting table ACLAPPLICATION 1 rows exported
. . exporting table ACLBIZLOGICPERMISSION 3 rows exported
. . exporting table ACLBIZMANAGEPERMISSION 4 rows exported
. . exporting table ACLBIZPULSEPERMISSION 1 rows exported
--------------------------------------------------------------------------------------------------------------------------
-- Imports
-- import schema data
imp file=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015.dmp log=/dbwalbkp01/expdp/WALMART_SAV_APP_22Nov2015_import.log GRANTS=N IGNORE=Y INDEXES=N FROMUSER=WALMART_SAV TOUSER=WALMART_SAV
No comments:
Post a Comment