Skip to Content
0
Former Member
Nov 22, 2011 at 10:12 AM

Redirected restore procedure!!!

494 Views

Dear Experts,

During Redirected restore.

After the restore database confirmation Y.

RESTORE DATABASE VNP FROM 'C:\Backup' TAKEN AT 20110903225320 INTO SBX REDIRECT

WITHOUT ROLLING FORWARD

SQL2529W Warning! Restoring to an existing database that is different from

the backup image database, and the alias name "SBX" of the existing database

does not match the alias name "VNP" of the backup image, and the database name

"SBX" of the existing database does not match the database name "VNP" of the

backup image. The target database will be overwritten by the backup version.

The Roll-forward recovery logs associated with the target database will be

deleted.

Do you want to continue ? (y/n) y

After confirming with Y . Am getting the below error

SQL0902C A system error (reason code = "") occurred. Subsequent SQL

statements cannot be processed. SQLSTATE=58005

Am posting my CLP Script Kindly check & say whether it is correct ?

-- *****************************************************************************

-- ** automatically created redirect restore script

-- *****************************************************************************

UPDATE COMMAND OPTIONS USING S ON Z ON VNP_NODE0000.out V ON;

SET CLIENT ATTACH_DBPARTITIONNUM 0;

SET CLIENT CONNECT_DBPARTITIONNUM 0;

-- *****************************************************************************

-- ** automatically created redirect restore script

-- *****************************************************************************

RESTORE DATABASE VNP

-- USER <username>

-- USING '<password>'

FROM 'C:\Backup'

TAKEN AT 20110903225320

-- ON 'K:\db2\SBX\sapdata1'

-- , 'K:\db2\SBX\sapdata2'

-- , 'K:\db2\SBX\sapdata3'

-- , 'K:\db2\SBX\sapdata4'

-- DBPATH ON '<target-directory>'

INTO SBX

-- NEWLOGPATH 'F:\db2\SBX\log_dir\NODE0000\'

-- WITH <num-buff> BUFFERS

-- BUFFER <buffer-size>

-- REPLACE HISTORY FILE

-- REPLACE EXISTING

REDIRECT

-- PARALLELISM <n>

WITHOUT ROLLING FORWARD

-- WITHOUT PROMPTING;

-- *****************************************************************************

-- ** table space definition

-- *****************************************************************************

-- *****************************************************************************

-- ** Tablespace name = SYSCATSPACE

-- ** Tablespace ID = 0

-- ** Tablespace Type = Database managed space

-- ** Tablespace Content Type = All permanent data. Regular table space.

-- ** Tablespace Page size (bytes) = 16384

-- ** Tablespace Extent size (pages) = 2

-- ** Using automatic storage = Yes

-- ** Auto-resize enabled = Yes

-- ** Total number of pages = 133120

-- ** Number of usable pages = 133112

-- ** High water mark (pages) = 132360

-- *****************************************************************************

-- *****************************************************************************

-- ** Tablespace name = PSAPTEMP16

-- ** Tablespace ID = 3

-- ** Tablespace Type = System managed space

-- ** Tablespace Content Type = System Temporary data

-- ** Tablespace Page size (bytes) = 16384

-- ** Tablespace Extent size (pages) = 2

-- ** Using automatic storage = Yes

-- ** Total number of pages = 4

-- *****************************************************************************

-- *****************************************************************************

-- ** Tablespace name = SYSTOOLSTMPSPACE

-- ** Tablespace ID = 4

-- ** Tablespace Type = System managed space

-- ** Tablespace Content Type = User Temporary data

-- ** Tablespace Page size (bytes) = 16384

-- ** Tablespace Extent size (pages) = 2

-- ** Using automatic storage = Yes

-- ** Total number of pages = 4

-- *****************************************************************************

-- *****************************************************************************

-- ** Tablespace name = SYSTOOLSPACE

-- ** Tablespace ID = 5

-- ** Tablespace Type = Database managed space

-- ** Tablespace Content Type = All permanent data. Large table space.

-- ** Tablespace Page size (bytes) = 16384

-- ** Tablespace Extent size (pages) = 2

-- ** Using automatic storage = Yes

-- ** Auto-resize enabled = Yes

-- ** Total number of pages = 2048

-- ** Number of usable pages = 2040

-- ** High water mark (pages) = 1212

-- *****************************************************************************

-- *****************************************************************************

-- ** Tablespace name = SBX#EL701D

-- ** Tablespace ID = 6

-- ** Tablespace Type = Database managed space

-- ** Tablespace Content Type = All permanent data. Large table space.

-- ** Tablespace Page size (bytes) = 16384

-- ** Tablespace Extent size (pages) = 2

-- ** Using automatic storage = Yes

-- ** Auto-resize enabled = Yes

-- ** Total number of pages = 151552

-- ** Number of usable pages = 151544

-- ** High water mark (pages) = 149992

-- *****************************************************************************

-- TABLE SPACES.........

-- *****************************************************************************

-- ** Tablespace name = SBX#USER1D

-- ** Tablespace ID = 34

-- ** Tablespace Type = Database managed space

-- ** Tablespace Content Type = All permanent data. Large table space.

-- ** Tablespace Page size (bytes) = 16384

-- ** Tablespace Extent size (pages) = 2

-- ** Using automatic storage = Yes

-- ** Auto-resize enabled = Yes

-- ** Total number of pages = 2048

-- ** Number of usable pages = 2040

-- ** High water mark (pages) = 524

-- *****************************************************************************

-- *****************************************************************************

-- ** Tablespace name = SBX#USER1I

-- ** Tablespace ID = 35

-- ** Tablespace Type = Database managed space

-- ** Tablespace Content Type = All permanent data. Large table space.

-- ** Tablespace Page size (bytes) = 16384

-- ** Tablespace Extent size (pages) = 2

-- ** Using automatic storage = Yes

-- ** Auto-resize enabled = Yes

-- ** Total number of pages = 2048

-- ** Number of usable pages = 2040

-- ** High water mark (pages) = 528

-- *****************************************************************************

-- *****************************************************************************

-- ** start redirected restore

-- *****************************************************************************

RESTORE DATABASE VNP CONTINUE;

-- *****************************************************************************

-- ** end of file

-- *****************************************************************************

Am restoring DB of SID VNP to SID SBX. Both are on automatic storage databse. Help me as early as possible...

Thanks in advance....