Database Administration (MOSC)

MOSC Banner

RMAN-06172 when trying to restore spfile

edited Oct 30, 2017 10:12AM in Database Administration (MOSC) 10 commentsAnswered ✓

Hello.

I'm trying to restore a spfile from autobackup.

The autobackup was taken on server A.

I'm trying to restore on server B.

The database name is the same on both databases.

On server A

----------------

list backup of spfile;

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

230     Full    10.02M     DISK        00:00:01     27-OCT-17

        BP Key: 230   Status: AVAILABLE  Compressed: NO  Tag: TAG20171027T021029

        Piece Name: /u02/fast_recovery_area/DBNAME/backupset/2017_10_27/o1_mf_ncsnf_TAG20171027T021029_dz4wpd3r_.bkp

  SPFILE Included: Modification time: 27-OCT-17

  SPFILE db_unique_name: DBNAME

I'm then transferring

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center