on 03-14-2014 9:53 AM
Hi there,
I am trying to do a full system copy from PROD into QA on a different host.
I will be using the latest offline backup.
I have read on this site that if you are using an online backup then use the BRRECOVER
and if you are using an offline backup which I am then to use the BRRESTORE.
I am a little confused. I am struggling with the control file creation after the restore has taken place.
Can I use the BRRECOVER even though I will be using an offline backup? Will this re-create
the control file automatically??
Hope this makes sense!
Thanks
Andy
Hi Andy,
brrestore is used to restore the files from the backup media.
brrecover is used to recover the database post restoration.
Whether you have offline backup or online backup you need to use brrestore for restoration.
So you can go ahead with brrrestore -m full -b <backup filename> to start the restore
Once the restore is completed you can open the database using
SQL> alter database open resetlogs;
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.