Copy  RMAN backup files including archive log backup files to the target server

Copy the SNAPSHOT CONTROL FILE or backed up control file from source server to target server.

If you do not remember the snapshot control file location, connect to source rman and query “snapshot controlfile name” and it will give as below: 

Source Server: 

RMAN> connect target /;
connected to target database: HRDMO (DBID=209403493034)

RMAN> show SNAPSHOT CONTROLFILE NAME;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/10g/dbs/snapcf_HRDMO.f'; # default

Comments (8) | Add as favourites (45) | Quote this article on your site | Views: 3592 | Print | Read more...

I have seen in many client sites, the password for user people is default password. If someone wants to get the details of the secure tables like PSOPERDEFN, they can do so if they know the tnsname details of the database by using people user id.

Try this in your production database from your PC from DOS prompt [you should have oracle installed and have the tns entry for your production DB]

Sqlplus people/defaultpassword@yourproductiondbSID

Select * form psoprdefn;

It would give you all the details in your prod db. Even though they can not use it to login to your production DB or update the data in that table, they can get some vital information like OPRID, OPRDEFNDESC, EMAILID, ACCTLOCK, LASTSIGNONDTTM etc.
And someone who knows how to use them, then you are exposing your data to others, which is a SOX breach.

 PS: - I have not mentioned what is default password here for obvious reasons.

Comments (6) | Add as favourites (46) | Quote this article on your site | Views: 960 | Print | Read more...