Bugra Canbakal's Oracle Blog

  • Home
  • About me
  • Contact
  • SITE MAP
You are here: Home / Archives for user managed backup

User managed backup ve restore

March 31, 2013 By Bugra Canbakal Leave a Comment

1.AMAÇ VE KAPSAM

Bu yazıda user managed backup alıp , bu almış olduğumuz backup’ı restore  işlemi uygulayacağız.

2.UYGULAMA

2.1. Tablespacelerin backuplarını cp le alabilmemiz için öncelikle database üstünde tablespacelerin statusunu değiştirmemiz gerekmekte. Tek tek tablespaceleri backup moduna almak yerine “ALTER DATABASE BEGIN BACKUP;” komutunuda kullanabilirsiniz.

Oracle PL/SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
[oracle@sb]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 18 10:21:38 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> select 'alter tablespace '||TABLESPACE_NAME||' begin backup;' from SYS.DBA_DATA_FILES;
'ALTERTABLESPACE'||TABLESPACE_NAME||'BEGINBACKUP;'
-------------------------------------------------------------
alter tablespace USERS begin backup;
alter tablespace UNDOTBS1 begin backup;
alter tablespace SYSAUX begin backup;
alter tablespace SYSTEM begin backup;
alter tablespace EXAMPLE begin backup;
alter tablespace MGMT_ECM_DEPOT_TS begin backup;
alter tablespace MGMT_TABLESPACE begin backup;
alter tablespace MGMT_AD4J_TS begin backup;
 
8 rows selected.
 
SQL> alter tablespace USERS begin backup;
Database altered.
SQL> alter tablespace UNDOTBS1 begin backup;
Database altered.
SQL> alter tablespace SYSAUX begin backup;
Database altered.
SQL> alter tablespace SYSTEM begin backup;
Database altered.
SQL> alter tablespace EXAMPLE begin backup;
Database altered.
SQL> alter tablespace MGMT_ECM_DEPOT_TS begin backup;
Database altered.
SQL> alter tablespace MGMT_TABLESPACE begin backup;
Database altered.
SQL> alter tablespace MGMT_AD4J_TS begin backup;
Database altered.

[Read more…]

Share this:

  • LinkedIn
  • Twitter
  • Google

Filed Under: Oracle Tagged With: resetlog, user managed backup, user managed restore

About Me



Dil

  • Turkish
  • English

Categories

  • Oracle
    • RAC – Real Application Cluster
    • RMAN
    • Single Node
    • Standby – Dataguard
  • OS
    • Linux

Blogroll

  • Emre Baransel
  • Gökhan Atıl
  • H. Tonguc Yılmaz
  • Kamil Türkyılmaz
  • Tanel Poder
  • Turkce Oracle
  • Turkish Oracle User Group
  • Uwe Hesse
  • Zekeriya Beşiroğlu

Archives

  • April 2014
  • March 2014
  • August 2013
  • June 2013
  • March 2013
  • January 2013
  • December 2012
  • November 2012
  • July 2012
  • June 2012
  • May 2012
  • January 2012
  • November 2011
  • October 2011
  • August 2011
  • July 2011
  • June 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • June 2010
OCP

Return to top of page

Copyright © 2010-2014 Bugra Canbakal. All rights reserved.