Re: RMAN backup on RAC w/ ASM
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: Chris King <ckaj111@xxxxxxxx>
- Date: Mon, 12 May 2014 20:59:35 +0200
please specify point 6.
if you have your redo-logs and controlfile available - it will recover
until the state of your point 5. - so the table is gone. - maybe you want
to note down SCN at any of your steps and ckeck which SCN you have at point
8?
Martin
On Mon, May 12, 2014 at 8:51 PM, Chris King <ckaj111@xxxxxxxx> wrote:
> This is probably a real newbie question.. I'm working on a new
> installation of RAC, and am testing an rman backup/restore. (I've done many
> rman backup/restores before on stand-alones.) I am puzzled why the process
> seems to go thru without error, but the data is not actually restored. Does
> anyone have a clue what I'm missing?
>
> I have a two node rac installation, and am storing the backups using ASM.
> I did all the work on node1 only.. Here are the steps.
>
> 1. log on to rac node1. create a table named tester. and insert 3 rows
> into the table, commit.
> 2. alter system switch logfile;
> 3. do a full rman backup + an incremental (from rac node1)
> -- backups are stored in ASM
> 4. drop the table named tester. (from rac node1)
> 5. shutdown the database, mount one instance only (rac node1)
> 6. restore database; recover database; alter database open; (on rac node1)
> 7. bring up the instance on node2 as well.
> 8. connect on node1 and select * from tester -- the table does not exist.
>
> Any idea what I'm missing? Thanks in advance..
>
> ChrisK
>
>
>
--
Martin Berger martin.a.berger@xxxxxxxxx
Lederergasse 27/2/14 +43 660 660 83306
1080 Wien http://berxblog.blogspot.com
Other related posts:
