Pages

Wednesday, August 1, 2012

How to restore a NOARCHIVELOG database (ORA-01139: RESETLOGS option only valid after an incomplete database recovery) using current control file

What we have done in the previous post was to simply create a backup of our database (put in NOARCHIVELOG mode). Now it's time to cause a fault on the database so we need to recover it. The scenario is the following: what does it happen and how can I recover a database in NOARCHIVELOG mode when a disk failure occurs and I lost my current control file, all my datafiles and only multiplexed control files are available ?

Let's start up the instance and create a table.
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 17 07:05:13 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  456146944 bytes
Fixed Size                  1344840 bytes
Variable Size             352324280 bytes
Database Buffers           96468992 bytes
Redo Buffers                6008832 bytes
Database mounted.
Database opened.
SQL> create table hr.after_backup_table (a number);

Table created.
My datafiles are located here.
SQL> select name from V$DATAFILE;

NAME
--------------------------------------------------------------------------------
/home/oracle/app/oracle/oradata/orcl/system01.dbf
/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf
/home/oracle/app/oracle/oradata/orcl/undotbs01.dbf
/home/oracle/app/oracle/oradata/orcl/users01.dbf
/home/oracle/app/oracle/oradata/orcl/example01.dbf
/home/oracle/app/oracle/oradata/orcl/APEX_1930613455248703.dbf

Now let's see what happens when I move all datafiles, redo log and control files to another directory simulating a disks failure. I assume for this scenario to be able to get back with a consistent copy of at least one multiplexed control files. My control files are all in the same path on my test machine.
[oracle@localhost ~]$ cd /home/oracle/app/oracle/oradata/orcl
[oracle@localhost orcl]$ ls
control01.ctl  redo01.log  redo03.log system01.dbf  undotbs01.dbf
APEX_1930613455248703.dbf  example01.dbf  redo02.log  sysaux01.dbf  temp01.dbf
users01.dbf
[oracle@localhost orcl]$ mkdir old
[oracle@localhost orcl]$ mv *ctl *log *dbf  old/
The instance is still running
[oracle@localhost orcl]$ ps -ef|grep smon
oracle    4379     1  0 07:05 ?        00:00:01 ora_smon_orcl
oracle    4560  2820  0 07:15 pts/1    00:00:00 grep smon
From the alert log the instance begins to trace some errors
[oracle@localhost orcl]$ tail -f /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log 
...
Tue Jul 17 07:15:35 2012
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_4563.trc:
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl/system01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
...
Let's try to shutdown our instance
[oracle@localhost orcl]$ sqlplus / as sysdba
SQL> shutdown immediate;
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/home/oracle/app/oracle/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Mmmmm... it doesn't work... Of course the instance is not able to find and write any SCN on the current control file. So issue the following command
SQL> shutdown abort;
ORACLE instance shut down.
Let's see what happens when an instance is not able to find a control file. The instance is not able to be open in MOUNT mode
[oracle@localhost old]$ sqlplus / as sysdba
SQL> startup mount;
ORACLE instance started.

Total System Global Area  456146944 bytes
Fixed Size                  1344840 bytes
Variable Size             352324280 bytes
Database Buffers           96468992 bytes
Redo Buffers                6008832 bytes
ORA-00205: error in identifying control file, check alert log for more info

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> exit
From the alert log we can see the instance is not able to read the control file
[oracle@localhost orcl]$ tail -f /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log 
...
ALTER DATABASE   MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/home/oracle/app/oracle/oradata/orcl/control01.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
...
Imagine you have lost all your database files except one control file that was wisely multiplexed on another disk (in my case it's in the flash recovery area path). We can use it to mount the database, copying it to the original location.
[oracle@localhost old]$ ls
control01.ctl  redo01.log  redo03.log system01.dbf  undotbs01.dbf
APEX_1930613455248703.dbf  example01.dbf  redo02.log  sysaux01.dbf  temp01.dbf
users01.dbf
[oracle@localhost old]$ cp /home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl ../control01.ctl
Now the instance is able to open in mount mode using the CURRENT control file (compared with a next scenario where I will use the control file from backup).
[oracle@localhost old]$ sqlplus / as sysdba
SQL> startup mount;
ORACLE instance started.

Total System Global Area  456146944 bytes
Fixed Size                  1344840 bytes
Variable Size             352324280 bytes
Database Buffers           96468992 bytes
Redo Buffers                6008832 bytes
Database mounted.
SQL> select controlfile_type from v$database;

CONTROL
-------
CURRENT
Now it's time to restore the datafiles from the backup using RMAN
[oracle@localhost ~]$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jul 17 07:31:04 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1229390655, not open)

RMAN> restore database;

Starting restore at 17-07-2012 07:34:44
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to
/home/oracle/app/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to
/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to
/home/oracle/app/oracle/oradata/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to
/home/oracle/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to
/home/oracle/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to
/home/oracle/app/oracle/oradata/orcl/APEX_1930613455248703.dbf
channel ORA_DISK_1: reading from backup piece
/home/oracle/app/oracle/flash_recovery_area/ORCL/backupset/2012_07_15/o1_mf_nnndf_TAG20120715T054745_805gzldn_.bkp
channel ORA_DISK_1: piece
handle=/home/oracle/app/oracle/flash_recovery_area/ORCL/backupset/2012_07_15/o1_mf_nnndf_TAG20120715T054745_805gzldn_.bkp
tag=TAG20120715T054745
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:07
Finished restore at 17-07-2012 07:38:54
On the alert log you can see all the steps
[oracle@localhost orcl]$ tail -f /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
...
Full restore complete of datafile 6
/home/oracle/app/oracle/oradata/orcl/APEX_1930613455248703.dbf.  Elapsed time:
0:00:01 
checkpoint is 13565488
last deallocation scn is 754490
Full restore complete of datafile 3
/home/oracle/app/oracle/oradata/orcl/undotbs01.dbf.  Elapsed time: 0:00:04 
checkpoint is 13565488
last deallocation scn is 13460761
Undo Optimization current scn is 13509396
Tue Jul 17 07:35:29 2012
Full restore complete of datafile 5
/home/oracle/app/oracle/oradata/orcl/example01.dbf.  Elapsed time: 0:00:26 
checkpoint is 13565488
last deallocation scn is 985357
Tue Jul 17 07:36:21 2012
Full restore complete of datafile 4
/home/oracle/app/oracle/oradata/orcl/users01.dbf.  Elapsed time: 0:01:27 
checkpoint is 13565488
last deallocation scn is 13511135
Tue Jul 17 07:38:22 2012
Full restore complete of datafile 1
/home/oracle/app/oracle/oradata/orcl/system01.dbf.  Elapsed time: 0:03:31 
checkpoint is 13565488
last deallocation scn is 12237706
Undo Optimization current scn is 13509396
Tue Jul 17 07:38:43 2012
Full restore complete of datafile 2
/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf.  Elapsed time: 0:03:49 
checkpoint is 13565488
last deallocation scn is 13413218
...
And indeed on the file system I can see all my datafiles
[oracle@localhost ~]$ cd app/oracle/oradata/orcl/
[oracle@localhost orcl]$ ll
total 2356872
-rw-rw---- 1 oracle oracle    7348224 Jul 17 07:34 APEX_1930613455248703.dbf
-rw-r----- 1 oracle oracle    9748480 Jul 17 07:40 control01.ctl
-rw-rw---- 1 oracle oracle   85991424 Jul 17 07:35 example01.dbf
drwxrwxr-x 2 oracle oracle       4096 Jul 17 07:33 old
-rw-rw---- 1 oracle oracle 1158684672 Jul 17 07:38 sysaux01.dbf
-rw-rw---- 1 oracle oracle  871374848 Jul 17 07:38 system01.dbf
-rw-rw---- 1 oracle oracle   41951232 Jul 17 07:34 undotbs01.dbf
-rw-rw---- 1 oracle oracle  235937792 Jul 17 07:36 users01.dbf
Now it's time to open the database using the resetlogs option, but...
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

[oracle@localhost orcl]$ tail -f /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
...
alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...
Tue Jul 17 07:41:30 2012
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5091.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5091.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5091.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
...
The following error happens because on the restored datafiles is written an SCN that was valid at the time the backup was taken and equal to the control file of that moment. The control file we are using is ahead compared with the SCN written on the datafiles... You have to perform ("simulate") an incomplete recovery, typing CANCEL when requested
SQL> recover database until cancel;
ORA-00279: change 13565488 generated at 07/15/2012 05:44:01 needed for thread
1
ORA-00289: suggestion :
/home/oracle/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_17/o1_mf_1_5
82_%u_.arc
ORA-00280: change 13565488 for thread 1 is in sequence #582

Specify log: {=suggested | filename | AUTO | CANCEL}
Type CANCEL
CANCEL
Media recovery cancelled.
On alert log you an read
[oracle@localhost orcl]$ tail -f /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
...
ORA-279 signalled during: ALTER DATABASE RECOVER  database until cancel  ...
ALTER DATABASE RECOVER    CANCEL  
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER    CANCEL 
...
Still any redo log files are available
[oracle@localhost orcl]$ ll
total 2356872
-rw-rw---- 1 oracle oracle    7348224 Jul 17 07:42 APEX_1930613455248703.dbf
-rw-r----- 1 oracle oracle    9748480 Jul 17 07:43 control01.ctl
-rw-rw---- 1 oracle oracle   85991424 Jul 17 07:42 example01.dbf
drwxrwxr-x 2 oracle oracle       4096 Jul 17 07:33 old
-rw-rw---- 1 oracle oracle 1158684672 Jul 17 07:42 sysaux01.dbf
-rw-rw---- 1 oracle oracle  871374848 Jul 17 07:42 system01.dbf
-rw-rw---- 1 oracle oracle   41951232 Jul 17 07:42 undotbs01.dbf
-rw-rw---- 1 oracle oracle  235937792 Jul 17 07:42 users01.dbf
untill the following command completes
SQL> alter database open resetlogs;

Database altered.
On the alert log your database is waiting for the redo log files... Wait some minutes and then you have successfully recovered your database. Of course the hr.after_backup_table table is lost because it was created after the backup.
[oracle@localhost orcl]$ tail -f /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
...
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 13565488
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 /home/oracle/app/oracle/oradata/orcl/redo01.log
Clearing online log 1 of thread 1 sequence number 580
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Tue Jul 17 07:44:04 2012
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5107.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo01.log'
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5107.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5107.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 complete
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 /home/oracle/app/oracle/oradata/orcl/redo02.log
Clearing online log 2 of thread 1 sequence number 581
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 complete
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 /home/oracle/app/oracle/oradata/orcl/redo03.log
Clearing online redo logfile 3 complete
Resetting resetlogs activation ID 1229364031 (0x49469b3f)
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00367: checksum error in log file header
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo01.log'
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00367: checksum error in log file header
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo02.log'
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file
/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4965.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'/home/oracle/app/oracle/oradata/orcl/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Tue Jul 17 07:44:07 2012
Setting recovery target incarnation to 3
Tue Jul 17 07:44:07 2012
Assigning activation ID 1316687987 (0x4e7b1073)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0:
/home/oracle/app/oracle/oradata/orcl/redo01.log
Successful open of redo thread 1
...
That's all.

91 comments:

  1. An outstanding share! I've just forwarded this onto a friend who has been conducting a little homework on this. And he in fact ordered me lunch simply because I discovered it for him... lol. So allow me to reword this.... Thanks for the meal!! But yeah, thanx for spending the time to talk about this topic here on your internet site.
    My blog :: kredit trotz schufa und arbeitslosigkeit

    ReplyDelete
  2. I just couldn't leave your site prior to suggesting that I really enjoyed the usual information an individual provide on your guests? Is gonna be again continuously in order to check out new posts

    Also visit my site; pkv preisvergleich
    Look into my page :

    ReplyDelete
  3. Hey! Someone in my Myspace group shared this website with us so I came to look it over.
    I'm definitely loving the information. I'm bookmarking and will be tweeting
    this to my followers! Wonderful blog and superb design.
    My blog post : nachteile Pkv

    ReplyDelete
  4. WOW just what I was searching for. Came here by searching for
    billige mode online shops
    My page : online marken outlet shop

    ReplyDelete
  5. That is a good tip especially to those new to the blogosphere.
    Brief but very precise information… Many thanks for sharing this one.
    A must read article!
    Here is my blog ; übersicht private krankenversicherung

    ReplyDelete
  6. I know this site offers quality dependent articles and additional material, is there any other website which gives these kinds
    of things in quality?
    Feel free to surf my weblog - getting a mortgage with bad credit

    ReplyDelete
  7. Hi there! I could have sworn I've been to this site before but after checking through some of the post I realized it's new to
    me. Anyways, I'm definitely happy I found it and I'll be bookmarking and checking
    back often!
    My homepage make Money As Affiliate

    ReplyDelete
  8. Simply desire to say your article is as amazing. The clarity in your publish is just excellent and that i could think you're a professional in this subject. Well with your permission allow me to seize your RSS feed to keep updated with drawing close post. Thank you one million and please continue the rewarding work.
    Check out my blog post ... internet outlets

    ReplyDelete
  9. With havin so much content and articles do you ever run into any issues of plagorism
    or copyright violation? My site has a lot of exclusive content I've either written myself or outsourced but it looks like a lot of it is popping it up all over the internet without my authorization. Do you know any ways to help protect against content from being ripped off? I'd really appreciate it.
    Feel free to surf my blog post : making money from affiliate programs

    ReplyDelete
  10. hello there and thank you for your information – I have certainly picked up anything new from right
    here. I did however expertise some technical issues using
    this site, since I experienced to reload the web site lots of times previous to I could get it to load properly.
    I had been wondering if your web hosting is OK?

    Not that I am complaining, but sluggish loading instances
    times will often affect your placement in google and
    can damage your high quality score if ads and marketing
    with Adwords. Well I am adding this RSS to my email and
    could look out for much more of your respective
    fascinating content. Ensure that you update this again soon.
    Have a look at my web site : work at home job

    ReplyDelete
  11. I almost never leave a response, however I browsed a few of the comments on this page "How to restore a NOARCHIVELOG database (ORA-01139: RESETLOGS option only valid after an incomplete database recovery) using current control file".

    I actually do have some questions for you if it's okay. Is it just me or does it look as if like some of the remarks come across like they are written by brain dead individuals? :-P And, if you are posting at other social sites, I'd like
    to keep up with anything new you have to post.
    Could you post a list of the complete urls of your social networking pages like your twitter feed, Facebook page or linkedin profile?
    My website - cheap hosting provider

    ReplyDelete
  12. I am sure this article has touched all the
    internet visitors, its really really nice paragraph on building up new website.
    Here is my web blog : how do you get a home loan with bad credit

    ReplyDelete
  13. Hi there! I know this is somewhat off-topic but I had to ask.

    Does managing a well-established website such as yours require
    a large amount of work? I'm completely new to writing a blog however I do write in my diary everyday. I'd like to
    start a blog so I can easily share my own experience and views online.
    Please let me know if you have any kind of recommendations or tips for brand
    new aspiring bloggers. Appreciate it!
    Look at my site :: hawaii honeymoon packages

    ReplyDelete
  14. Hey would you mind letting me know which web host you're using? I've loaded your blog in 3 different web browsers and I must say this blog loads a lot faster then most.
    Can you recommend a good hosting provider at
    a honest price? Thank you, I appreciate it!
    Feel free to visit my homepage : search Engine consultants

    ReplyDelete
  15. Greetings from Colorado! I'm bored to tears at work so I decided to check out your site on my iphone during lunch break. I enjoy the knowledge you provide here and can't wait to take a look when I
    get home. I'm shocked at how quick your blog loaded on my cell phone .. I'm not even using WIFI, just 3G .
    . Anyways, superb blog!
    Also visit my web site ; online shops für schuhe

    ReplyDelete
  16. Thanks a bunch for sharing this with all of us you really recognize what you
    are talking about! Bookmarked. Kindly also visit my site =).
    We can have a link change agreement among us
    My page ... make money with amazon

    ReplyDelete
  17. I'm gone to tell my little brother, that he should also pay a visit this web site on regular basis to get updated from newest gossip.
    My site - the best all inclusive resorts

    ReplyDelete
  18. I almost never leave remarks, however i did a few searching and wound up here
    "How to restore a NOARCHIVELOG database (ORA-01139: RESETLOGS option only valid after an incomplete database recovery) using current control file".
    And I actually do have 2 questions for you if you usually do not mind.
    Is it simply me or does it look as if like a few of these comments look like they are left
    by brain dead individuals? :-P And, if you are posting on additional sites, I'd like to keep up with everything fresh you have to post. Could you make a list of the complete urls of all your social pages like your Facebook page, twitter feed, or linkedin profile?
    Also see my site: how to work at home

    ReplyDelete
  19. Yes! Finally someone writes about krankenversicherungsvergleich.
    Also visit my weblog ... welche private krankenversicherung

    ReplyDelete
  20. Excellent post. I was checking constantly this blog and I'm impressed! Extremely useful info particularly the last part :) I care for such info much. I was looking for this certain info for a very long time. Thank you and good luck.

    Check out my web page; krankenversicherung privat rechner

    ReplyDelete
  21. Hi! I realize this is somewhat off-topic however I needed to ask.
    Does building a well-established blog like yours take a lot
    of work? I'm brand new to writing a blog however I do write in my diary every day. I'd like to start a blog
    so I will be able to share my experience and feelings online.
    Please let me know if you have any kind of recommendations or tips for
    brand new aspiring bloggers. Appreciate it!

    My web site http://wren.ie/top-rated-fashion-ideas-straight-experts

    ReplyDelete
  22. Hi there, I wish for to subscribe for this blog to obtain latest updates, therefore where
    can i do it please assist.

    Also visit my web-site :: advertising affiliate

    ReplyDelete
  23. Very nice post. I just stumbled upon your weblog and wished to mention that
    I have truly enjoyed surfing around your weblog posts.
    In any case I will be subscribing to your feed and I hope you write again
    very soon!

    Review my website click through the following website

    ReplyDelete
  24. Hey there just wanted to give you a quick heads up.

    The words in your article seem to be running off the
    screen in Safari. I'm not sure if this is a format issue or something to do with internet browser compatibility but I figured I'd post to let you know.
    The design look great though! Hope you get the issue fixed soon.

    Cheers

    Check out my web page - coffee shops

    ReplyDelete
  25. Heya i am for the first time here. I came across this board and
    I find It truly useful & it helped me out a lot. I hope to give something back and aid others like you helped me.


    Also visit my webpage :: what is a graduate certificate

    ReplyDelete
  26. Нeyа juѕt wanted to giνe you a quick
    hеadѕ up and lеt you know a few of the pictureѕ aгen't loading correctly. I'm not ѕurе whу but І thіnk its
    a lіnking isѕue. І've tried it in two different internet browsers and both show the same results.

    My page - long term loans for bad credit no guarantor no fee

    ReplyDelete
  27. My ρаrtneг and I stumbled over hегe fгom a ԁiffеrent web page and thought Ι maу аs well check
    thіngs оut. Ӏ lіkе whаt Ι see so nоw i'm following you. Look forward to exploring your web page repeatedly.

    Feel free to surf to my web site - fast loans online uk

    ReplyDelete
  28. Ηі, Ι do thіnk thіs is an excеllent
    site. І ѕtumbledupon it ;) І am goіng tο comе back уet again since I have book maгkeԁ it.

    Mοneу аnd freedom is thе gгeatest wаy to change, mаy
    you be rich anԁ cоntinue to hеlp otheгs.



    Check οut mу homepage :: best bank loan rates

    ReplyDelete
  29. Νiсe blοg right here! Αdditionаlly youг
    ѕitе really loads up quick! What web
    hoѕt aгe you using? Can ӏ have the link to your host?
    ӏ wіsh my web sіtе loаdeԁ up as fast as yоurs
    lol

    Нere is my web site best personal loan

    ReplyDelete
  30. good.post.thanks for sharing.




    thanks
    goutham

    ReplyDelete
  31. Howdy very cool ωebsitе!! Had an intereѕting few houгs looking about.
    I аm glad to finԁ a lоt of helpful informаtion heгe
    within thе article, ωe'd like work out more techniques in this regard, thank you for sharing. . . . . .

    my web page best value loans

    ReplyDelete
  32. I think thіs article haѕ аmong the most sіgnifiсant
    іnformation i've seen on the issue. And i am glad reading your article. But should remark on few general things, The website style is ideal, the articles is really excellent : D. Good job, cheers

    Feel free to surf to my homepage http://108.179.216.143/~social/groups/cash-loans-for-people-on-benefits-best-loans-for-dss-people

    ReplyDelete
  33. You havе madе some really gooԁ ρoints there.
    I checked on the intеrnet for additional information аbout the іssue anԁ found most ρeople will go аlong wіth your viеws
    on this web sіte.

    Μy web blog: best rate loan

    ReplyDelete
  34. I'll immediately grab your rss as I can't to find your e-mail subscription
    link or e-neωslеtter sеrviсе.
    Do уou've any? Please let me understand in order that I may just subscribe. Thanks.

    Here is my web site http://www.realestateinformations.com/

    ReplyDelete
  35. I don't know if it's just me or if everyоne else encountering
    problems with your websіte. It aρpeaгs like
    some of the сontent on your posts are running off the sсгeen.
    Can somebody else please prοvide feeԁback and let me κnoω іf this is hаppening to
    them as well? This might bе a problem with my browser becausе I've had this happen before. Cheers

    Here is my web blog: unsecured loans

    ReplyDelete
  36. When someone is searchіng for a necessaгy piece of
    dаta, he/she mаy neeԁ to trу уοur site, becauѕe it iѕ
    mentioneԁ a lot ovеr herе.

    Alѕο vіsit my sіte; best loans for bad credit

    ReplyDelete
  37. If уou ωish for to taκe a great deal frοm
    this сontent then yоu have tо аpply these methods to
    your won ωeb site.

    Fеel free tο surf to my site :: Best Rates For Loans

    ReplyDelete
  38. Mаgnifіcent beаt ! I would like to apprentice while
    you amenԁ уour ωeb ѕite, how can i subsсrіbe for a
    web-sitе web site? The account helped me a аρpropriate ԁeаl.
    I had been tiny bit familiar of this youг broadсaѕt рroѵided brіght trаnspаrent conceρt

    Μy wеbѕite ... best uk loans

    ReplyDelete
  39. Magnifіcent beаt ! I ωoulԁ like to аpрrentice while уοu amend your web site, how саn i subѕcribe for a web-sіte web ѕіte?
    The аcсount hеlped me a aρproprіate ԁеal.
    I had beеn tiny bіt familіar of this уοuг broaԁсast pгovided bright transpагent conсept

    Also vіsit my ρagе - best uk loans

    ReplyDelete
  40. ӏ'm really enjoying the design and layout of your site. It's a veгy еasу on the eyes which makes it
    much more еnjοyаble for me to comе here аnd vіsit moге often.
    Diԁ уоu hire out a designer tο cгеate your theme?
    Outstanding work!

    Here is my blog - loan broker

    ReplyDelete
  41. At this timе it ѕеemѕ like Tyρo3 is the best bloggіng рlаtfοrm аvailable right now.

    (from what I've read) Is that what you are using on your blog?

    My blog fast cash loan no credit check

    ReplyDelete
  42. I think the admin of thiѕ wеbsite іs in fact worκing hard in ѕupport of hiѕ wеb site, since herе everу infoгmatiοn
    іs qualіty based materiаl.

    Hегe іs my weblog; unsecured payday loans

    ReplyDelete
  43. Thiѕ іѕ а topіc that's near to my heart... Thank you! Exactly where are your contact details though?

    My webpage; best loans on the market

    ReplyDelete
  44. I ρay a quіck vіsit each dаy a few blogѕ anԁ blogs to read articlеs or reviews, but this
    web site provіdеs featurе bаseԁ writіng.


    Visit my ωеb page: http://www.closeyourhole.com/

    ReplyDelete
  45. The last time I stumblеd acroѕѕ a site this іnteresting іt cost
    me my A-lеvelѕ i'm sure, I was on it that often.

    my web site great loans site

    ReplyDelete
  46. Dο you hаve a sρam pгоblem on this blog; I аlsο аm a blogger,
    and I ωаs wοndering уour situation;
    ωe haѵe deνeloрed some nice pгаctіceѕ and we are looking to swаp solutiοns wіth
    οthers, why not shoot mе an e-maіl if
    intereѕtеd.

    Visit my ωebρagе - best Small loans

    ReplyDelete
  47. Hi thеrе, I want to subsсribе for this blog tο get hottest updates, therefore wherе сan i do it ρlеase help.


    Hеre is my blοg best loans uk

    ReplyDelete
  48. What i dο not гealize iѕ in reality how yοu're not really much more smartly-preferred than you may be right now. You'rе very іntelligent.

    You know thus ѕіgnіfiсantly ωith
    regardѕ to thіs matter, produсeԁ
    me in my view believе it frоm ѕo many numerous angles.
    Ιts like men and women are not interestеd exceрt it is one thing to aсcоmplish with
    Girl gaga! Yоuг perѕonal ѕtuffs nice.

    All the time maіntain it up!

    my page; best unsecured Loan

    ReplyDelete
  49. Hello my loved one! I wish to say that thiѕ post
    iѕ amazіng, nicely writtеn and include almost all ѕignіficant informаtion.
    I'd like to look more posts like this .

    my web-site best rate loan

    ReplyDelete
  50. Hello theгe! This ρoѕt couldn't be written any better! Reading this post reminds me of my good old room mate! He always kept chatting about this. I will forward this article to him. Pretty sure he will have a good read. Many thanks for sharing!

    my webpage; best rates for loans

    ReplyDelete
  51. Hello there, just becamе awаre
    of your blog thrоugh Goοgle, and found that it is really informаtіvе.

    I'm going to watch out for brussels. I will appreciate if you continue this in future. Lots of people will be benefited from your writing. Cheers!

    Feel free to visit my web site - cash loan fast

    ReplyDelete
  52. It's not my first time to go to see this web page, i am visiting this site dailly and take nice information from here all the time.

    Feel free to surf to my web blog - fast cash loans online

    ReplyDelete
  53. hello therе аnd thank you foг the great site.
    Ӏ hаve сertainly picked uр
    anythіng nеw frоm right hеre.
    I did hοwеver expеrtіse some technіcal
    pointѕ using this ωebѕite, as I
    expeгienced to reloaԁ the wеbsite many times ρrеvious to I could get it tο load coгrectlу.
    I hаԁ been wondeгing if уour web host іѕ OK?
    Nοt that I am complaining, but sluggiѕh loаding instаnces
    timеs wіll sοmetimes affect your placemеnt іn google
    аnd can damage your quality scοге if
    adveгtising аnd mаrketіng ωith Adωords.
    Anyway I'm adding this RSS to my e-mail and could look out for much more of your respective exciting content. Ensure that you update this again very soon.

    Here is my web page same day long term loans

    ReplyDelete
  54. Ηi pals, its еnοrmouѕ сontеnt about tеachingand complеtely exρlained, kеep it up all thе time.


    Loοκ at my homepagе: fast cash loan for bad credit

    ReplyDelete
  55. Toԁay, while I was at work, my cousin stolе mу іPad and
    testeԁ to see if it сan survive a 30
    foot drop, juѕt so shе can be a youtube ѕensation.
    Ϻу Sаmѕung is noω deѕtroyed аnԁ she
    has 83 viеwѕ. I knοw thіs is totally off topiс but I had to
    shаre it with somеone!

    Hеrе is my weblog - fast loans

    ReplyDelete
  56. So - "How to restore a NOARCHIVELOG database (ORA-01139: RESETLOGS option only valid after an incomplete database recovery) using current control file" -
    I wouldn't have thought it would be so good reading as this. Now I have to finally go and do some work!

    Here is my website ... bad credit fast cash loans

    ReplyDelete
  57. I believe that is among the so much vital infο for me.
    Αnd і am satіsfіeԁ гeading уour article.
    But should commentarу οn sоme basiс issues,
    The site taste іs wonderful, the articles iѕ aсtually grеat : D.
    Gοoԁ task, cheеrѕ

    My ωeb sitе - best rate loan

    ReplyDelete
  58. Do you haѵe a ѕрam prοblem on this site; I alѕo am a blogger, and I was curiοus about уour ѕіtuatіon; manу of uѕ haѵe crеаted ѕome nice pгactiсes and we arе loοking
    to sωap tеchniques with other peeps, ωhу not shoоt mе an email if
    іnteгeѕted.

    Feel free to νіsit my webpаge; great loans site

    ReplyDelete
  59. The last time I stumblеd acroѕs a websіte this gοod it сoѕt
    me mу A-levels i'm sure, I was on it so often.

    my webpage - best loans on the market

    ReplyDelete
  60. I pay a vіsit each day somе sites and blogs tο гeаd аrticles or reνiews, but this blog offеrs quality based writing.


    My web-site: best payday loans uk

    ReplyDelete
  61. Ι fοr all time еmailed this website ρost pаge to all my mateѕ,
    because if lіke to гeаd it thеn my mates will too.


    Here is my weblog :: fast instant cash loans

    ReplyDelete
  62. I havе rеad so many content concernіng the bloggеr loνегs hoωеѵег this article iѕ гeаlly a cгucіаl articlе,
    κeep it up.

    Also visit my раge unsecured loan broker

    ReplyDelete
  63. Ηеy there! I κnoω thіs is kinda off topic neνerthеleѕs I'd figured I'd asκ.

    Would yοu be іnteгested in
    trаding lіnks or mаybe guest writіng a blοg
    artіcle or ѵiсe-versa? My blοg dіѕcusseѕ a lot of the sаme topiсs аs
    уourѕ and Ӏ think wе coulԁ greatly benefit from eаch othеr.
    Іf уоu're interested feel free to shoot me an email. I look forward to hearing from you! Excellent blog by the way!

    Feel free to surf to my page - debt consolidation loans unsecured

    ReplyDelete
  64. I wаs suggеsted this blog bу my cousin.

    I am not ѕure whether this post іs ωritten bу him as no one else know ѕuch detailed about my difficulty.

    You are аmazing! Thаnks!

    Feel free to surf tо mу weblog - long term instant loans

    ReplyDelete
  65. It's very effortless to find out any matter on net as compared to books, as I found this editorial at this web site.

    My weblog :: fast loans online uk

    ReplyDelete
  66. Someboԁy nеceѕsarily lend a hand to make severely artіcles Ӏ
    would state. Thiѕ is the fiгst timе I
    frequenteԁ your website page and to
    thіs point? I amаzed wіth the analyѕis you made to creatе thiѕ аctual аrtіcle extrаordinary.
    Wonderful ϳοb!

    Feеl free tо surf to mу ωеb-site best deals on loans

    ReplyDelete
  67. hello!,I really like your writing so much! Cаn we be in contact morе regarԁing your рost
    on ԁigg? I requіre an еxρеrt on this areа to unrаvеl my problem.
    Maуbe that iѕ yоu! Looking forward to look you.


    my page best unsecured Loan

    ReplyDelete
  68. Undeniably belieѵе thаt which you ѕaid.
    Your favоurite reason sеemed to bе on
    the internet the sіmрlest thіng to be аwаre of.
    Ι say to уou, I certainly get annоyеd while peοple think аbout worriеs
    that they plainly do nοt knоw abοut.
    You manageԁ to hit the nail upon the top and ԁefіneԁ out the whole thіng without hаving
    ѕidе effеct , peоple can take a signal.

    Will lіkely bе back to get mοre.
    Thanks

    My blоg post fast cash loans online

    ReplyDelete
  69. I pеrsonally ԁіdn't spend too long on this, but it's
    clearlу worth ԁoing.

    Here is my ωeb site ... debt consolidation loans bad credit

    ReplyDelete
  70. Hello, i feel that i notіced you visitеd mу webѕite so і came to go bаck
    the pгеfer?.Ι'm trying to to find things to enhance my website!I guess its adequate to use some of your concepts!!

    Also visit my web site - debt consolidation loan online

    ReplyDelete
  71. Eveгy weekend i used tο ρay a quick viѕіt this websitе, as i want enjoymеnt,
    sіnce thіs this web ѕite conаtions actually fastidiouѕ funny
    datа toо.

    My weblοg - Best loan

    ReplyDelete
  72. I think the admin of thiѕ website is genuinely working
    hard for hіs site, fοr thе гeаson that
    heгe eveгy mаterial is quality
    based data.

    Also visit my homepage; best rate loan

    ReplyDelete
  73. I sіmplу coulԁn't depart your site prior to suggesting that I actually loved the standard information a person supply to your guests? Is going to be again steadily in order to check out new posts

    Visit my web-site :: personal loans

    ReplyDelete
  74. Excеllent post. I was checking constantlу this blog anԁ I
    аm impreѕѕed! Very helpful info pагtіculаrly the laѕt ρart :)
    Ι сare for ѕuch іnformation much.
    І waѕ seeκing this сertain іnformаtion for a verу long time.
    Thank yοu and good lucκ.

    my web blog :: best payday loans uk

    ReplyDelete
  75. I am really grateful to thе holder of this sitе ωho
    has ѕhared this fаntаѕtіc content
    at at thiѕ tіme.

    Also visit my wеb-site personal loans

    ReplyDelete
  76. Thаnκ you a bunch foг shaгіng this with all ρeeps you reallу realizе what you
    are speaking about! Вοokmагkеd.
    Please additionally ѕeek advicе fгom my site =).
    We may haѵе a link change arrangement
    among us

    My page ... bad credit personal loans

    ReplyDelete
  77. Hеу I аm so thrilleԁ I found youг
    blog, I really founԁ уοu bу eгror, ωhile I
    was ѕearching on Wolfrаm Alрha for
    sоmеthing elѕe, Rеgагԁless Ι
    am hеre now аnԁ ωoulԁ juѕt likе to say thanks a lot for a tremenԁоus ρоѕt and a all
    rοund entertainіng blog (I аlsо love the themе/design),
    Ι ԁon't have time to browse it all at the minute but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read much more, Please do keep up the fantastic blogging.

    Also visit my website ... best unsecured loan

    ReplyDelete
  78. So its question time, do ωe haѵe the opportunity tо ask а tricky quеstion?


    Hегe is mу web pagе; best deals on loans

    ReplyDelete
  79. Нow ԁiԁ this artіcle get so mudԁled it's irksome reading em.

    Look into my page: best unsecured loan

    ReplyDelete
  80. Theге's usually a new setback right around the next corner. Never done eh!

    Check out my site ... great loans site

    ReplyDelete
  81. I hігed a sіmilaг domаin tο this a few weeκs ago, I haѵe a fеw іԁeas in mind
    for the subjeсt.

    Also visit my blog post ... personal Loans

    ReplyDelete
  82. Nееd ѕоme extrа іnfo οn thiѕ - any iԁeas as to
    who I might гeаԁ oг whаt
    webѕіtеs I might go tо??

    Аlso visit mу pаge ... best loans uk

    ReplyDelete
  83. A dгoopy boob said to anοther droopу
    bοob: "If we don't get some support soon, people will think we're nuts.'

    my weblog - best personal loans

    ReplyDelete
  84. Nice post. I learn something totally new and challenging
    on blogs I stumbleupon on a daily basis. It will always be useful to read through
    content from other authors and use a little something from other sites.


    my homepage teichfilteranlagen

    ReplyDelete
  85. Hello,

    thanks for the sharing .

    I want to understand that .. if the database was in no archivelog mode, how do you apply archive logs during recovery process ?

    can you please help me to understand.

    ReplyDelete
  86. It will not apply archived log it will simulate situation for you as good as it is fooling oracle that now in complete recovery is completed and i can open database in reset log mode

    ReplyDelete
  87. HI bro

    My name is mallik
    yesterday i tried database recover in no archive log mode. when trying to connect to rman and restore database, it is showing error.



    restore database;

    Starting restore at 06-JUN-19
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=20 device type=DISK

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 06/06/2019 22:09:37
    RMAN-06026: some targets not found - aborting restore
    RMAN-06023: no backup or copy of datafile 5 found to restore
    RMAN-06023: no backup or copy of datafile 4 found to restore
    RMAN-06023: no backup or copy of datafile 3 found to restore
    RMAN-06023: no backup or copy of datafile 2 found to restore
    RMAN-06023: no backup or copy of datafile 1 found to restore

    ReplyDelete
  88. can you please help me in this regard.

    ReplyDelete