Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Susja

  • Rank
  1. Hello, I am getting familiar with backup/restore process. For that reason on Windows 7 I installed Oracle 11.2 g and started to play. Eventually I need to restore database on another server but first I want to try it locally. First in builtin ORCL db I created table Test1, inserted one record and verified it from SQL Developer and sqlplus queries. Then I took backup using following steps: SQL> shutdown immediate; SQL> startup mount pfile='C:\app\Ilana\admin\ORCL\pfile\init.ora.52201722308 RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'C:\backup\rman/full_%u_%s_%p'; RMAN> BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG; It created 2 files in C:\backup\rman e.g. File1 and File2. I assume that File1 is datafile and File2 is control filr. Then I deleted table Test1 After that I restored ORCL using the following steps: SQL> Select Dbid from v$database ; 1802923837 set Dbid=1802923837; SQL> shutdown immediate; startup nomount pfile='C:\app\admin\orcl\pfile\init.ora.512...' RMAN> connect target / RESTORE CONTROLFILE FROM "\backup\rman/File2' 5. ALTER DATABASE MOUNT; 6. RESTORE DATABASE; 7. RECOVER DATABASE; 8. ALTER DATABASE OPEN RESETLOGS; After that I checked ORCL both in SQL Developer and sqlplus but I do no see my table Test1 My question: What I might did wrong that Test1 was not restored? Thanks ** Someone from another forum pointed me to the issue. My issue was that I restored everything i.e. I did complete Restore i.e. including 'table deletion' as well. After I used parameter SCN I was able to restore 'incomplete' and get my table. My ticket could be closed or ignored ..
  2. Susja

    Create a new database from backup file

    Thanks for the link ... there are a lot of topics. In my case I need to restore a database on another server hence I decided to follow this article: https://www.slideshare.net/OsamaMustafa/res...-different-host I hit an issue and need your help. Here's what I did: 1. Installed on Windows 7 Oracle 11.2 Express Edition. It comes with database XE 2. Successfully followed steps described in the article on Page 1 and Page 2 3. The problem started on Page 3: set ORACLE_SID=VAPROD C:\Windows\system32>rman target / Recovery Manager: Release - Production on Sat May 27 20:15:04 2017 Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-12560: TNS:protocol adapter error C:\Windows\system32> ** In case I don't setup ORACLE_SID I have this: Copyright © 2009 Microsoft Corporation. All rights reserved. C:\Windows\system32>rman target / Recovery Manager: Release - Production on Sat May 27 20:27:47 2017 Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: XE (DBID=2825710501) RMAN> set dbid 1707466105 executing command: SET DBID RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at 05/27/2017 20:31:29 RMAN-06188: cannot use command when connected to a mounted target database RMAN> Could someone please help me and explain what I'm doing wrong? Thanks
  3. Hello I have an Oracle database SE 11.2 g. I have daily full backup. It runs on Windows 7. On another PC I installed Oracle 11.2 g Express Edition. I want to use it for testing purposes. It does not have any Connections or databases yet. How could I create a new database using backup file? I have all credentials related to that backup Thanks
  4. Susja

    Restore off-line database

    Hello I have a laboratory device which is connected to PC running Windows 7 and use Oracle 11.2 We are doing daily backups but never had a chance to verify that it'll work if required I.e never tried to restore. I have another PC also running Windows 7. This PC is off-line. Here's my proposal: 1. I'll go to Oracle.com and download Oracle 11.2 database software 2. I will install Oracle on that PC 3. I'll take one of the daily backup and try to restore it on that PC 4. I expect to get same database I have on 'original' location. Do you think it's feasible/implementable? Thanks
  5. Susja

    How to create additional backup ...

    Well those 2 articles are great. It's clear to me how to handle destination but could you please elaborate a little bit how could I start and handle second/additional backup from OEM? My point is: how to start it from scratch? Not being depended from existing one? Sorry but I am still a little bit confused with first article. I would prefer OEM but if not possible I could try with RMAN. Thanks for great articles.
  6. Susja

    Duration of Backup

    All set Thanks
  7. Susja

    How to create additional backup ...

    Well this is a good idea ... Actually in my case backup happened on drive C: but for unknown reason it doesn't get deleted according to retention policy. That's why we wanted first not touch existing backup but create another one like from scratch and expect that it will behave according to retention policy. It sounds to me that your proposal will just duplicate existing backup to another disc but it is not 'another ' backup. Is it possible to create 'another' I.e. new backup additionally to existing one? Thanks
  8. Hello, I've got Oracle 11g and it already has scheduled backup to local drive C:\backup Currently I don't want to break existing one but create another one with destination to external disc. I use Enterprise Manager - Availability - Schedule Backup and follow the steps BUT at the step for backup destination I see 'hard-coded' C:\backup and it does not have the option to change it. My question: 1. could I have more than one backup running against the same database? 2. how could I change destination for 'alternative' backup? Thanks
  9. Well I read that interesting article. I tried to make some changes nothing has happened I.e. expired/obsolete backups don't get deleted. Finally I decided to schedule another backup and point it to another disc on another PC. I never did it before hence I decided to use Enterprise console would be easier for me. Expectation is that 'new' backup will work properly i.e. will delete expired pieces properly. My question : will this backup have the same retention policy as the first one or I should setup retention policy explicitly for each backup? Thanks
  10. Susja

    Duration of Backup

    Hello, My system is running Full Backup and incremental backup to external disc. I want to setup another Backup process and I don't want to overlap. My goal is to check when current Backup starts and ends. I ran this query: select * from v$rman_backup_job_details; or this one: select * from v$rman_backup_subjob_details; The problem is that it does not tell me when it starts / ends in timestamp format, it states like this: START_TIME and END_TIME 18-APR-17. My question: how could I get start and end time of backup process in hours or minutes? Thanks
  11. Well ... this article was very helpful although I can't state that I understood all steps. Anyway ... I'm not sure what redundancy has been set in my case ... I only know that retention policy in my case is 10 days and backup not determined as 'expired' or 'obsolete' anymore . I am going to do this: ( I don't need more than 1 copy of backup ) 1. configure retention policy to redundancy 1; After that: 2. configure retention policy to recovery window of 10 days; Does it sound right for you? Thanks
  12. Well eventually I was able to delete all backup and arhievelog files using these commands: delete noprompt backupset <12345>, <12346>; BUT the problem still is there. I mean files that should be deleted as 'expired' or 'obsolete' or etc do not have attribute 'expired' hence not get deleted. My retention policy is 10 days but none of the files older that 10 days are marked 'expired'. Any clue what this could be and how to troubleshoot it? Thanks
  13. Hi, I tried all steps described in topic you pointed me http://dbaforums.org/oracle/index.php?showtopic=16916 but it did not have any effect. Then I ran these sets of commands: list backup summary o Run “crosscheck backup;” o Run “crosscheck archivelog all;” o Run “crosscheck backupset;” o Run “delete noprompt expired backup;” o Run “delete noprompt expired backupset;” o Run “delete noprompt expired archivelog all; • Run “list backup summary’” again and see that nothing has changed o Run “delete noprompt backupset <12345> <12346;”> o Run “list backup summary” again and see that nothing has changed Finally ran this: delete force noprompt backupset 12345 12346;” but again nothing has changed. Note: From the thread you pointed me I did all steps except this one: (my management did not recommend me to do it) 3. If your database is flashback enabled, then just for a moment, disable this. SQL> shutdown immediate; SQL> startup mount; SQL> alter flashback off; SQL> alter flashback on; SQL> alter database open; Any other suggestions? It sounds to me that those files for some reason do not have 'attributes' for deletion. Thanks
  14. Thanks so much. I just browsed it and it looks very valuable. I'll read more carefully later. I'm just confused why you mentioned/pointed to January 1st. Does it have some relation to particular timestamp? Sorry for that, Thanks
  15. Hello, We have established process to delete files from FRA for a while but recently it stopped to delete 'expired', 'obsolete' files. The issue started January 1st. Retention policy is 10 days. I noticed that we have files from December 21 2016. They were not deleted while it should be only for the last 10 days. This is the script that runs every day. I ran it manually and here's the output: RMAN> run { 2> crosscheck archivelog all; 3> delete expired archivelog all; 4> delete expired backup; 5> delete obsolete; 6> } 7> EXIT using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 ...... \2017_03_17\O1_MF_1_2517_DDR25H66_.ARC RECID=5071 STAMP=938865776 Crosschecked 613 objects released channel: ORA_DISK_1 released channel: ORA_DISK_2 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=201 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=16 device type=DISK specification does not match any archived log in the repository using channel ORA_DISK_1 using channel ORA_DISK_2 specification does not match any backup in the repository RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 10 days using channel ORA_DISK_1 using channel ORA_DISK_2 no obsolete backups found Recovery Manager complete. *** Today I ran it manually again but get another output: using channel ORA_DISK_2 specification does not match any backup in the repository RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 10 days using channel ORA_DISK_1 using channel ORA_DISK_2 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 7263 10-MAR-17 Backup Piece 7263 10-MAR-17 C:\BACKUPS\ORACLE\C-1707466105-20170310-03 Backup Set 7266 10-MAR-17 Backup Piece 7266 10-MAR-17 C:\BACKUPS\ORACLE\C-1707466105-20170310-04 Backup Set 7267 10-MAR-17 Backup Piece 7267 10-MAR-17 C:\BACKUPS\ORACLE\C-1707466105-20170310-05 deleted backup piece backup piece handle=C:\BACKUPS\ORACLE\C-1707466105-20170310-03 RECID=7263 STAMP=938239310 deleted backup piece backup piece handle=C:\BACKUPS\ORACLE\C-1707466105-20170310-04 RECID=7266 STAMP=938260910 deleted backup piece backup piece handle=C:\BACKUPS\ORACLE\C-1707466105-20170310-05 RECID=7267 STAMP=938260944 Deleted 3 objects Recovery Manager complete. C:\BAT> ** It sounds to me that for some reason it stopped to recognize 'expired' file and does not delete it anymore. Could you please help me to troubleshoot and fix the issue? Thanks